#data-modeling
7 notes, from beginner to advanced.
- Normalization in Plain English: 1NF, 2NF, 3NFdata-modeling · beginner · 2 min
- Star Schema Basics: Facts, Dimensions and Graindata-modeling · beginner · 3 min
- Kimball vs Inmon vs Data Vaultdata-warehousing · intermediate · 2 min
- Surrogate Keys vs Natural Keysdata-modeling · intermediate · 2 min
- Join Fan-Out: How a Correct Query Returns Wrong Revenuesql · intermediate · 3 min
- Three Kinds of Fact Tables: Transaction, Snapshot and Accumulatingdata-modeling · intermediate · 3 min
- Late-Arriving Data: Facts and Dimensionsetl-elt · advanced · 2 min