Level 2: Data · L2.1 Data models, SQL vs NoSQL, storage engines & indexing
Normalization vs denormalization
Decide when to duplicate data for read speed.
12 min · Pro
What you take away
- Normalised data stores each fact once, so writes are cheap and correct and reads may need joins.
And 3 more inside the class, in Pro.
How the class is laid out
- The problem
- The simple version
- What each choice costs
- Check your understanding