Module 4: ACID and Database Scalability Trade-offs
Module Overview
SQL or NoSQL? Why not both! Picking the right database for a situation can be a tricky problem, with many tradeoffs. SQL gives us ACID (Atomicity Consistency Isolation Durability) guarantees and powerful analytical queries, and NoSQL gives us huge scale and usually "good enough" guarantees. But innovation is happening all the time, with NewSQL proposing to give us the best of both worlds.
Learning Objectives
- Be able to explain how ACID Database properties and Scalability Tradeoffs apply to SQL and NoSQL databases
- Understand and explain the advantages and disadvantages of SQL and NoSQL databases
Guided Project
In this guided project, we'll explore ACID properties and database scalability trade-offs, comparing SQL and NoSQL approaches. Open guided-project.md in the GitHub repository below to follow along with the guided project.
Module Assignment
For this assignment, you'll analyze ACID properties and database scalability trade-offs, comparing different database systems and their use cases.