Part 1 of 6 · 1 min read
Why this page comes first
In this module you will
- Design a normalized schema for a content-and-progress platform with subjects, levels, modules, and learners.
- Choose indexes that match the platform's actual dominant queries, not guesswork.
- Apply the four-question framework from earlier in this level to this platform's own consistency, scale, and pattern needs.
- Propose a concrete scaling plan for the moment read traffic outgrows a single instance.
- State, out loud, what this design gives up.
Every page in this subject built toward exactly this moment: a real platform, not a textbook example, designed from scratch using every tool covered. A free study-notes site with subjects, levels, modules, and learners tracking their own progress is a small but genuine database design problem. Working through it end to end is the best final exercise this subject can offer.
Remember this
A content platform's hardest problem is rarely the content; it is correctly and cheaply tracking what each learner has actually done.