PostgreSQL

A deep PostgreSQL curriculum covering SQL, MVCC, indexing, planner internals, VACUUM, WAL, replication, partitioning, JSONB, extensions, security, observability, high availability, logical replication, and production engineering.

Browse curriculum Back to all courses

24chapters

120lesson paths

Intermediate → Advancedlearning level

Publishedcourse state

Coverage baselinePostgreSQL 18 current stable baseline, with upgrade-aware coverage

Course brief

From engine fundamentals to advanced production operations.

This syllabus deliberately separates conceptual foundations, hands-on SQL, engine internals, operational tooling, reliability, security, performance, and capstone work so future lesson generation can go deep without compressing advanced subjects into generic chapters.

By the end

You will be able to

Use advanced PostgreSQL SQL and data types including JSONB, arrays, ranges, windows, and recursive queries
Reason from MVCC, heap storage, VACUUM, WAL, indexes, and execution plans
Design physical/logical replication, partitioning, extensions, RLS, and connection scaling
Build evidence-driven observability and performance workflows using PostgreSQL statistics
Operate upgrades, PITR, failover, schema change, security, and disaster-recovery runbooks

Complete syllabus

24 chapters · 120 lessons.

Every lesson path was reserved in the planned syllabus and is now linked because its lesson HTML is available. The sequence moves from foundations through internals, advanced features, administration, reliability, security, tuning, upgrades, and a production capstone.

Chapter 1

PostgreSQL Foundations, Release Cadence, Installation, and Lab Design

5 lessons

PostgreSQL Architecture and Philosophy: Process Model, Catalogs, and ExtensibilityPublished lesson · Chapter01/Lesson1.html

PostgreSQL

From engine fundamentals to advanced production operations.

You will be able to

24 chapters · 120 lessons.

PostgreSQL Foundations, Release Cadence, Installation, and Lab Design

Cluster Architecture, Processes, Memory, Files, and Configuration

Databases, Schemas, Roles, Catalogs, and Object Namespaces

Data Types, Domains, Constraints, Identity, and Generated Data

SQL Querying: Joins, Subqueries, CTEs, Set Operations, and LATERAL

Advanced SQL: Aggregates, Windows, GROUPING SETS, and MERGE

MVCC, Transactions, Isolation, Locks, and Serialization

Heap Storage, TOAST, HOT Updates, Bloat, and Page-Level Internals

VACUUM, Autovacuum, ANALYZE, Freeze, and Maintenance Engineering

B-Tree and Specialized Indexes: Hash, GiST, SP-GiST, GIN, and BRIN

Planner and Executor Internals, EXPLAIN, Statistics, and Cost Modeling

WAL, Checkpoints, Crash Recovery, and Durability Engineering

Backup, Restore, PITR, Base Backups, and Archiving

Physical Streaming Replication, Standbys, and High Availability

Logical Replication, Publications, Subscriptions, and Data Movement

Partitioning, Pruning, Routing, and Large-Table Operations

JSONB, Arrays, Full-Text Search, Range Types, and Advanced Data Modeling

Functions, Procedures, Triggers, PL/pgSQL, and Server-Side Programming

Extensions, Foreign Data Wrappers, Languages, and PostgreSQL Extensibility

Authentication, Authorization, TLS, Row-Level Security, and Hardening

Observability: Statistics Views, pg_stat_statements, Logs, and Wait Events

Performance Engineering: Memory, I/O, Parallelism, JIT, and Connection Scaling

Upgrades, pg_upgrade, Compatibility, Migrations, and Production Change

Production Capstone: Operate a Secure, Highly Available PostgreSQL Platform

Help the academy stay free and grow.