// module

Postgres for Builders

Databases · Cohort · 5 weeks

AUD 860 (informational)

Visual for Postgres for Builders

Responsible mentor

Avatar for Elena Park

Elena Park

Databases mentor; cares about boring, reliable data paths.

Outcomes

  • Produce a migration series another developer can replay
  • Present one explain plan improvement with evidence
  • Document retention notes for a fictional product

Description

You evolve a schema across weekly migrations, defend index choices, and write data repair scripts with dry-run modes. Ethics of data retention are discussed with AU context in mind.

Inside the track

  • Migration review checklist
  • Index experiments with before/after timings
  • Row-level security intro lab
  • Backup/restore drill on a sample dataset
  • Query plan reading sessions
  • CSV ingest pipeline with validation

Reviews

Explain plan sessions in Postgres for Builders rewired how I read slow pages — specific, not hand-wavy.

— Ravi

FAQ

Docker compose is provided. 8GB RAM minimum recommended.