Workshop: Hands-on PostgreSQL


A hands-on tutorial designed to quickstart anyone looking to work directly in PostgreSQL.

The tutorial will first lay the groundwork for the hands-on session by covering fundamential concepts:

  • Quick introduction of relational theory
  • The SQL programming language
  • PostgreSQL software and community

We will then dive into creating, modifying, and querying databases hands-on. Topics will include:

  • Creating a database
  • Creating and modifying tables
  • Writing data into the database
  • Writing queries
  • Exporting data out of the database

We will wrap-up by introducing some of the more advanced features that build on the hands-on experience participants have just gained,  including:

  • Triggers
  • Stored Procedures
  • Functions
  • Views and Materialzied Views
  • Foreign Data Wrappers


Room 104
Thursday, March 5, 2020 - 09:30 to 12:15