One lesson
An individual lesson
This track has no lesson ready to buy yet. Each lesson becomes available only after it is built and reviewed.
$5.00Not available yet
All course tracks
Databases and SQL · 30 lessons · up to 10 minutes each
Relational Modeling and Normalization
A planned data-modeling path through keys, normal forms, constraints, and trade-offs.
Coming Soon
One-time purchase · USD
Choose what to unlock
Access is attached to your account after payment is verified. No subscription.
Full category
Relational Modeling and Normalization
Permanent access to the lessons published in this track when you buy. Future lessons are not included. 0 of 30 lessons are published; 0 are in owner review and 30 are Coming Soon.
$29.0030 lessons still in progress
Beginner
Lessons 1–10
01 Relational Modeling and Normalization: Sketch entities and candidate keys
Topic: entities and candidate keys
Draw a small map of entities and candidate keys in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Beginner4 minComing Soon02 Relational Modeling and Normalization: Name the parts of primary and foreign keys
Topic: primary and foreign keys
Label the main pieces in primary and foreign keys in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Beginner5 minComing Soon03 Relational Modeling and Normalization: Trace an example of functional dependencies
Topic: functional dependencies
Follow one input through functional dependencies in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Beginner6 minComing Soon04 Relational Modeling and Normalization: Compare choices for first normal form
Topic: first normal form
Write down one practical difference between first normal form in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Beginner7 minComing Soon05 Relational Modeling and Normalization: Find the boundary in second normal form
Topic: second normal form
Mark where second normal form in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Beginner8 minComing Soon06 Relational Modeling and Normalization: Inspect an example of third normal form
Topic: third normal form
Annotate a minimal example of third normal form in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Beginner9 minComing Soon07 Relational Modeling and Normalization: Connect many-to-many junctions to a neighboring concept
Topic: many-to-many junctions
Show how many-to-many junctions in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Beginner10 minComing Soon08 Relational Modeling and Normalization: Spot a failure mode in check and unique constraints
Topic: check and unique constraints
Describe one likely failure for check and unique constraints in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Beginner3 minComing Soon09 Relational Modeling and Normalization: Read an official example of migration and backfill safety
Topic: migration and backfill safety
Summarize an official example of migration and backfill safety in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Beginner5 minComing Soon10 Relational Modeling and Normalization: Choose a use case for denormalization trade-offs
Topic: denormalization trade-offs
Match one small use case to denormalization trade-offs in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Beginner6 minComing Soon
Intermediate
Lessons 11–20
11 Relational Modeling and Normalization: Build an example with entities and candidate keys
Topic: entities and candidate keys
Create a small working example that uses entities and candidate keys in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Intermediate4 minComing Soon12 Relational Modeling and Normalization: Compose primary and foreign keys with another component
Topic: primary and foreign keys
Combine primary and foreign keys in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Intermediate5 minComing Soon13 Relational Modeling and Normalization: Configure functional dependencies for a small case
Topic: functional dependencies
Set up functional dependencies in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Intermediate6 minComing Soon14 Relational Modeling and Normalization: Validate inputs around first normal form
Topic: first normal form
Add a check around first normal form in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Intermediate7 minComing Soon15 Relational Modeling and Normalization: Use second normal form in a short workflow
Topic: second normal form
Add second normal form in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Intermediate8 minComing Soon16 Relational Modeling and Normalization: Refactor third normal form into a reusable unit
Topic: third normal form
Extract third normal form in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Intermediate9 minComing Soon17 Relational Modeling and Normalization: Exercise many-to-many junctions with sample data
Topic: many-to-many junctions
Run sample data through many-to-many junctions in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Intermediate10 minComing Soon18 Relational Modeling and Normalization: Observe check and unique constraints outputs
Topic: check and unique constraints
Capture the result of check and unique constraints in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Intermediate3 minComing Soon19 Relational Modeling and Normalization: Recover from a migration and backfill safety failure
Topic: migration and backfill safety
Handle one expected failure from migration and backfill safety in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Intermediate5 minComing Soon20 Relational Modeling and Normalization: Document denormalization trade-offs behavior
Topic: denormalization trade-offs
Write a short usage note for denormalization trade-offs in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Intermediate6 minComing Soon
Advanced
Lessons 21–30
21 Relational Modeling and Normalization: Test a boundary around entities and candidate keys
Topic: entities and candidate keys
Add an edge-case test for entities and candidate keys in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Advanced4 minComing Soon22 Relational Modeling and Normalization: Harden primary and foreign keys
Topic: primary and foreign keys
Add the relevant access, safety, or validation control to primary and foreign keys in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Advanced5 minComing Soon23 Relational Modeling and Normalization: Measure functional dependencies
Topic: functional dependencies
Record a small baseline for functional dependencies in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Advanced6 minComing Soon24 Relational Modeling and Normalization: Reduce cost in first normal form
Topic: first normal form
Change one measurable cost in first normal form in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Advanced7 minComing Soon25 Relational Modeling and Normalization: Diagnose a second normal form failure
Topic: second normal form
Use an observable signal to explain a failure in second normal form in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Advanced8 minComing Soon26 Relational Modeling and Normalization: Make third normal form repeatable
Topic: third normal form
Show that rerunning third normal form in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Advanced9 minComing Soon27 Relational Modeling and Normalization: Review trade-offs in many-to-many junctions
Topic: many-to-many junctions
Compare two documented approaches to many-to-many junctions in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Advanced10 minComing Soon28 Relational Modeling and Normalization: Improve check and unique constraints maintainability
Topic: check and unique constraints
Refine check and unique constraints in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Advanced3 minComing Soon29 Relational Modeling and Normalization: Verify migration and backfill safety end to end
Topic: migration and backfill safety
Check that a complete small flow using migration and backfill safety in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Advanced5 minComing Soon30 Relational Modeling and Normalization: Audit denormalization trade-offs against its source docs
Topic: denormalization trade-offs
Check the implementation of denormalization trade-offs in the context of relational keys, dependencies, normalization, and schema changes; save a short example or check that demonstrates the result.
Advanced6 minComing Soon
Reference documentation
References support the selected track topics while its lesson content is built and reviewed progressively.
This track is a catalog outline only. Each lesson remains unavailable until it is built and personally reviewed.