PostgreSQL Tutorial

Hands-on PostgreSQL Tutorial

SCaLE 18x

Introduction

• Quick introduction to relational databases
• PostgreSQL software and community
• The SQL programming language

Hands-on Learning

• Connect to PostgreSQL for the first time
  • Create a database
  • Create a user
• Connect to the tutorial database as your user
• Play around with a simple test table
• Create the measure and program tables
• Write data into the measure and program tables
• Write queries
• Create views
• Create materialized views
• Export data from the database

Advanced Features

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