PostgreSQL Tutorial

Welcome to the postgres-tutorial wiki!

Introduction

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

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
• Writing queries
• Create views
• Create materialized views
• Exporting data out of the database

Advanced Features

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