A hands-on PostgreSQL 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