PostgreSQL

Full PostgreSQL course — 24 topics from the basics to advanced use.

Lessons

• JSON with jsonb
• Arrays, Enums & Range Types
• Full-Text Search
• Functions in SQL and PL/pgSQL
• Triggers
• Views & Materialized Views
• Indexes & EXPLAIN
• Transactions, MVCC & Isolation
• Roles, Privileges & Row-Level Security
• Table Partitioning
• Backups, Replication & Maintenance
• SQLite: The Embedded Database
• SQLite SQL vs PostgreSQL
• Using SQLite from a Program
• What Is PostgreSQL?
• psql: The Command-Line Client
• Data Types
• Constraints & Identity Columns
• INSERT, UPDATE, DELETE & UPSERT
• SELECT, Filtering & Sorting
• Joins: Inner, Outer, Self, Anti & LATERAL
• GROUP BY, HAVING & Aggregates
• CTEs & Recursive Queries
• Window Functions