Guided PostgreSQL journeys
Follow a path: a curated sequence of hands-on courses and real incident simulations that build one skill end to end.
Each path blends hands-on courses with real incident simulations — follow it end to end, or cherry-pick what you need.
PostgreSQL Foundations
Get comfortable with the client and basic investigation before going deep.
3 courses · 2 simulationsReading Query Plans
Read EXPLAIN, find the slow query, and understand why the planner chose a plan.
3 courses · 7 simulationsIndexing Mastery
Pick the right index for the access pattern — B-tree, composite, partial, covering, GIN, trigram.
3 courses · 7 simulationsLocks & Concurrency
Transactions, isolation, lock contention and deadlocks under real concurrency.
2 courses · 10 simulationsConnection Pool Mastery
Why connections are expensive, pgbouncer modes, sizing, and the storms that exhaust a pool.
2 courses · 10 simulationsVacuum, Bloat & Wraparound
MVCC, dead tuples, autovacuum tuning, bloat and the xid-wraparound emergency.
2 courses · 11 simulationsReplication & WAL
Streaming replication, WAL, replication slots, lag and conflicts.
2 courses · 10 simulationsBackup & Recovery Drills
Logical and physical backups, WAL archiving, PITR and restore drills under pressure.
2 courses · 10 simulationsHA & Failover On-Call
Detect a crash, promote a replica, avoid split-brain, validate after failover.
1 course · 10 simulationsSafe Schema Migrations
Lock-safe DDL, CONCURRENTLY, expand/contract and zero-downtime rollouts.
2 courses · 12 simulationsSecurity & Access Control
pg_hba, roles and privileges, default privileges, RLS, search_path and SSL.
1 course · 10 simulationsMulti-Tenant Operations
Many databases on one cluster: wrong-database mistakes, per-db limits and schema drift.
1 course · 9 simulationsStorage Pressure
Disk fills from temp files, WAL, archives, tablespaces and logs — and how to recover.
1 course · 6 simulationsDiagnose a Slow Endpoint
A task-focused journey: from a slow endpoint to the root cause and fix.
3 courses · 4 simulationsLive Diagnostics & Observability
See who is doing what, find the heavy queries, spot blocking and unmonitored lag.
2 courses · 4 simulationsPlanner & MVCC Internals
How the planner estimates and chooses, and how MVCC shapes visibility and bloat.
2 courses · 3 simulationsBackend Engineer Path
What a backend engineer needs to ship and operate a service on Postgres.
5 courses · 5 simulationsSRE On-Call Path
Operate Postgres under fire: diagnose, mitigate, fail over and recover.
4 courses · 13 simulationsDBA Path
Own the cluster: maintenance, replication, backup/recovery, security and capacity.
5 courses · 19 simulationsProduction Readiness
Make a Postgres-backed service survive load, deploys and migrations.
4 courses · 4 simulationsZero-Downtime Operations
Ship schema and infra changes without taking the app down.
2 courses · 4 simulationsPostgreSQL Interview Prep
The core topics interviewers probe: plans, indexes, transactions, MVCC and locks.
4 courses · 4 simulationsIncident Response Readiness
Compound, multi-cause incidents — the way production actually breaks.
2 courses · 10 simulationsCapstone: Incident Control
Final timed production incidents that demand the whole toolkit.
2 courses · 5 simulations