Data Modeling & Schema Design
Model for the query, not the entity — if you design tables before knowing your access patterns, you've already failed. Normalization vs denormalization as a write-amplification budget, embed vs reference tradeoffs, and how Uber, Airbnb, and Twitter evolved schemas under 10x growth.
This study guide is part of the full calibration library.
Staff interviews are decided on nuance — tradeoff framing, ownership boundaries, and failure anticipation. This study guide covers the depth that separates Senior from Staff+.
What's inside this study guide
Practice & Reference
- •Why This Matters
- •The 60-Second Version
- •How Data Modeling Works
- •Document vs. Relational
- •Schema Evolution
- •Visual Guide
- •The Numbers That Matter
- •How This Shows Up in Interviews
- •In the Wild
- •Staff Calibration
- •Practice Drill
- •Where This Appears