LearnDev
All courses
DatabasesBeginner

Database Design Fundamentals

Schemas that don't punish you six months later.

Normalization, denormalization, indexes, transactions, and the migration patterns that keep production data safe.

Modules
3
Lessons
6
Read time
61 min
Premium lessons
3
Start course

What you'll learn

  • Design schemas that won't bite you in six months
  • Reason about indexes and query performance
  • Run safe migrations on production tables
  • Know when to denormalize and when to stop

Prerequisites

  • Wrote a few SELECT and INSERT queries

Curriculum

3 modules · 6 lessons · 61 min total

  1. 1

    Schema Foundations

    2 lessons
    • 01.01Tables, Relations, and Keys
      8 minComing soon
    • 01.02Normalization in Practice
      11 minComing soon
  2. 2

    Performance

    2 lessons
    • 02.01How Indexes Actually Work
      10 minComing soon
    • 02.02Reading Query Plans Premium
      12 min
  3. 3

    Migrations

    2 lessons
    • 03.01The Expand/Contract Pattern Premium
      9 min
    • 03.02Online Schema Changes Premium
      11 min