CSE Roadmap

Specialist tier · about 3 hours · 6 parts

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.