advanced · cohort
Schema Modeling Sprint
5 weeks · 7 hrs/week
Model a realistic subscription billing slice with upgrades, proration flags, and audit fields. Emphasis on constraints that encode business rules and migrations that roll forward safely.
What ships in this outline
- Event storming light for domain nouns
- Constraint-first modeling exercises
- Migration ordering workshop
- Peer review rubric for schema pull requests
- Office hours on temporal tables (conceptual)
Outcomes
- Deliver a migration series with reversible steps where feasible
- Defend nullable vs non-null choices with user stories
- Produce an ERD teammates can navigate without you
Lead mentor
Haruto Watanabe
Former data platform lead at a logistics SaaS; PostgreSQL contributor talks in Tokyo.
FAQ
Pairs are welcome; pricing is per seat.
We generate SQL-first; ORM mapping is your homework layer.
Graph databases and document-first modeling are not taught here.
Experience notes
“The proration edge cases in week 4 mirrored our billing bugs. Naming workshop cleaned our legacy tables mentally.”
“Tough but fair. One lecture audio was thin — slides carried it.”