Terminus Expanse
CurriculumBlogPricingSign in
Back to catalog
Databases & data

Databases: The Foundations

How structured data is really organized, and why it works this way.

Prerequisite: Data & Applications

What you'll actually learn

Every database course jumps straight to SQL syntax and skips the part that actually matters: why data gets organized into tables and rows in the first place, and what breaks when it isn't. This track starts from the real problem — how do you store data so it survives a crash, stays consistent when two things try to change it at once, and can still be found in milliseconds — and builds normalization, indexes, and transactions as the concrete answers, not abstract rules to memorize.

What you'll be able to do

You'll design a schema for a real scenario — say, an e-commerce order system — and be able to explain exactly why a bad design corrupts data under concurrent writes or grinds to a halt as the table grows, instead of just knowing "normalize to third normal form" as a rule you follow without understanding.

Syllabus

1What a Database Really Iscore~9 min
2The Relational Model: Tables, Rows, Keyscore~10 min
3Primary and Foreign Keyscore~10 min
4Normalization: Fixing a Bad Tablecore~11 min
5ACID: The Promise a Database Makes Youcore~10 min
6Indexes: Why Queries Get Fastcore~9 min
7Transactions in Practicecore~9 min
8Synthesis: Design a Schemaexpert~30 min

Frequently asked

How long does Databases: The Foundations take to complete?

Roughly 2 hours across 8 hands-on quests — you can go at your own pace and pick up exactly where you left off.

What do I need to know before starting Databases: The Foundations?

You should be comfortable with Data & Applications first — the skill tree unlocks Databases: The Foundations once you've cleared those.

Is Databases: The Foundations free to learn?

Yes — Databases: The Foundations is fully available on the free tier, starting with a free first quest and no payment method required to sign up. Plus and Elite remove pacing limits but don't gate any of the Databases: The Foundations curriculum behind a paywall.

Start this skill for free

Create a free account and begin your first quest — no card required.

Start free