Learning path
Backend Engineer Path
What a backend engineer needs to ship and operate a service on Postgres.
backend · Intermediate · 5 courses · 5 simulations
The path
Courses, then incidents
Work through the courses, then practise the incidents — each step links to its page.
- Course psql: The PostgreSQL Client →
- Course Reading a Query Plan →
- Course B-tree Indexes and Selectivity →
- Course Why Connections Are Expensive →
- Course PostgreSQL Production API →
- query-performance Missing index on a hot endpoint →
- query-performance N+1 query pattern (missing child-table index) →
- connections-pooling Too many connections →
- locks-transactions Deadlock from inconsistent lock ordering →
- migrations-releases Bad nullable column rollout →