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

  1. The data model decides your future: start from access patterns
  2. Relational model and why normalization exists
  3. Document databases: model the aggregate
  4. Key-value and wide-column: model by query
  5. Graph and time-series models
  6. Transactions, ACID and BASE
  7. Isolation levels and the anomalies they allow
  8. MVCC: how readers and writers avoid blocking each other
  9. Preventing lost updates in application code
  10. Choosing a database: decision table and worked examples
  11. 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