SQL vs NoSQL, Data Models, ACID & Isolation
Relational, document, key-value, wide-column, graph and time-series models; normalization trade-offs; transactions, ACID vs BASE; isolation levels, anomalies and MVCC; choosing a database.
About 110 minutes · 17 exam questions · 9 interview questions · 2 code labs
What you will learn
- The data model decides your future: start from access patterns
- Relational model and why normalization exists
- Document databases: model the aggregate
- Key-value and wide-column: model by query
- Graph and time-series models
- Transactions, ACID and BASE
- Isolation levels and the anomalies they allow
- MVCC: how readers and writers avoid blocking each other
- Preventing lost updates in application code
- Choosing a database: decision table and worked examples
- How databases make transactions serializable: serial execution, 2PL and SSI
Previous: SQL Fundamentals: Joins, Query Execution Order, Normal Forms & Schema Design · Next: Indexing & Query Optimization