Back

Database

PostgreSQL

Relational database design for backend services.

0 / 9 done — updated as I actually learn each topic.

Roadmap checklist

Beginner

  • Tables & basic SQL
  • Data types & constraints
  • Joins & indexes

Intermediate

  • Query optimization & EXPLAIN
  • Transactions & isolation levels
  • Views & functions

Advanced

  • Partitioning & replication
  • Performance tuning at scale
  • Extensions (PostGIS, pg_stat, etc.)

Roadmap graph

1
Tables & basic SQL
2
Data types & constraints
3
Joins & indexes
4
Query optimization & EXPLAIN
5
Transactions & isolation levels
6
Views & functions
7
Partitioning & replication
8
Performance tuning at scale
9
Extensions (PostGIS, pg_stat, etc.)