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