databases

Prisma & PostgreSQL Data Modelling Labs

Model relational data with migrations, constraints, and Prisma workflows that survive real traffic.

Cover art for Prisma & PostgreSQL Data Modelling Labs

MYR 1,680 · 8 weeks · weekend labs

Weekend intensive labs weekend

Outline

From normalisation to migration squashing, you will work with PostgreSQL locally and in shared staging. Exercises emphasise safe schema evolution and query plans you can explain to teammates.

Inclusions

  • Schema review sessions with live EXPLAIN
  • Migration conflict resolution playbook
  • Indexing strategies beyond “add btree”
  • Prisma middleware for cross-cutting concerns
  • Seed scripts that stay reproducible
  • Row-level security discussion (awareness)
  • Backup/restore dry run with mentors

Outcomes

  1. Deliver a migration set with rollback notes
  2. Tune one slow query with evidence
  3. Document a data dictionary for your project

Participant notes

“Prisma & PostgreSQL labs forced me to write rollback notes — boring on paper, lifesaver in practice.”
— Nadia · Full-stack learner
“Clear material; the indexing week could use one more office hour. Still the best structured data course I have taken regionally.”
— Farhan · Trustpilot

Straight answers

Do I need prior SQL?
Basic SELECT/INSERT helps; we include a refresher module in week one.
Cloud Postgres included?
You receive shared staging credits for exercises; personal cloud bills are not covered.
What is out of scope?
NoSQL stores and analytics warehouses are mentioned comparatively, not taught end-to-end.