Databases · Intermediate · On-site lab
Postgres Integration Practicum
Transactions, isolation surprises, and migration hygiene for service-backed schemas.
Database work rewards patience. We alternate short lectures with labs that fail loudly so you can see locks, retries, and backoff in action.
Duration: 5 weeks
Tuition (informational): 7,100,000 VND
Final quotes come from admissions. See Money-Back Policy for eligibility.
What ships in the syllabus
- Isolation level sandbox with reproducible anomalies
- Migration ordering workshop with expand/contract pattern
- Index review checklist tied to query plans
- Connection pool tuning lab
- Read replica lag exercises
- Observability hooks for slow queries
- Mentor-led code walkthrough of a sample billing schema
Outcomes we actually assess
- Ship a two-step migration without locking a hot table
- Capture before/after plans for one optimization
- Explain replica lag impact on API responses to stakeholders
Thu Nguyen
Auth specialist covering OAuth2, refresh rotation, and threat modeling.
FAQ — including what we skip
Which Postgres version?
Labs target 15+; older versions may differ for certain catalog queries.
ORM preference?
We allow Prisma or Knex; raw SQL weeks stand apart from ORM sugar.
What is not covered?
No distributed consensus (Raft) deep dive—focus stays relational.
Experience notes
“Expand/contract clicked after the botched deploy simulation—stressful but memorable.”
“Pool tuning numbers finally matched what we saw in staging graphs.”