PostgreSQL in Depth
The planned outline of 14 modules. Lessons are written, run and reviewed before they are published.
Before this track
Planned outline
- Module 1
How PostgreSQL works and how to run it
Coming soon - Module 2
PostgreSQL data types, chosen well
Coming soon - Module 3
Query plans and indexes
Coming soon - Module 4
The planner in depth
Coming soon - Module 5
MVCC, VACUUM and freezing
Coming soon - Module 6
Concurrency, locks and safe migrations
Coming soon - Module 7
Partitioning large tables
Coming soon - Module 8
Server-side code and extensions
Coming soon - Module 9
Search, vectors and maps
Coming soon - Module 10
WAL, replication and high availability
Coming soon - Module 11
Backup, recovery and upgrades
Coming soon - Module 12
Security and access control
Coming soon - Module 13
Monitoring, tuning and connection pooling
Coming soon - Module 14
Applications, scaling and what comes next
Coming soon
Related tools
Official documentation
- www.postgresql.org/docs/current (postgresql.org)
- www.postgresql.org/docs/current/using-explain.html (postgresql.org)
- www.postgresql.org/docs/current/mvcc.html (postgresql.org)
More in Data and databases
- Data Analysis with Python (pandas, polars, DuckDB) (coming soon)
- Probability & Statistics (coming soon)
- Excel & Google Sheets (coming soon)
- MySQL & MariaDB in Depth (coming soon)
- All Data tracks
- How we make lessons