Relational Modelling
Normalize until it hurts, denormalize until it works
Free
5h · 5 lessons
Overview
Relational modelling, indexes, transactions, the NoSQL families and what each one is actually for, then replication and sharding. More interviews are lost on the storage layer than on any other part of the diagram.
This module is 02.1 of the 6 in Data Storage & Retrieval. It runs about 5 hours across 5 lessons, and closes with Schema — Turn six requirements into a schema, then survive three change requests that a bad model cannot absorb.
Lessons
1. Entities, relationships and the normal forms
Concept · 40 minutes
2. When denormalizing is the right answer
Concept · 30 minutes
3. Keys, constraints and referential integrity
Concept · 30 minutes
4. Modelling time: history, soft deletes, audit
Concept · 35 minutes
5. Model a marketplace from a paragraph of prose
Lab · 60 minutes
Module information
Duration
5 hours
Lessons
5
Level
Beginner
Track
Data Storage & Retrieval
Drill
Schema
Price
Free
Related modules
