Deep Instruction · Phases 07–11
PostgreSQL + Prisma — Data Modeling, SQL, and Migrations
Learn the database independently, then use Prisma without surrendering understanding of SQL and migration risk.
01code-first02code-first03code-first04code-first05code-first06code-first07code-first08code-first
SQL Tables, Rows, Constraints, and CRUD
Start with relational fundamentals before ORM abstractions.
Foreign Keys and Relational Modeling
Represent ownership/membership with explicit relationships.
Joins, Indexes, and Query Plans
Connect data efficiently and measure before optimizing.
Transactions and Invariants
Protect multi-statement business changes from partial success.
Prisma Schema as an ORM Mapping
Read Prisma models as mappings to relational structures, not replacements for database design.
Migrations and Production-Safe Schema Evolution
Inspect generated SQL and reason about existing data.
PrismaService and Query Ownership
Centralize client lifecycle without turning Prisma into a global grab bag.
Capstone: Persistent Task CRUD
Connect API contracts to Prisma and verify the database after each mutation.