Level 2: Data · L2.1 Data models, SQL vs NoSQL, storage engines & indexing
Choosing a database (decision practice)
Pick and justify a store for 5 scenarios.
15 min · Pro
What you take away
- Five questions decide it: access patterns, scale and ratio, consistency, query flexibility, and what your team can run.
And 3 more inside the class, in Pro.
How the class is laid out
- The procedure
- Data models
- Normalisation
- B-trees
- LSM-trees
- OLTP vs OLAP
- Five scenarios