Skip to content
M LearnwithManoj

SQL vs NoSQL - How to Choose the Right Database (System Design #8)

Picking the wrong database early can haunt your system for years. SQL or NoSQL - here's how to make the right call every time.

1 min read

Picking the wrong database early can haunt your system for years. SQL or NoSQL - here’s how to make the right call every time.

What’s in the video (8m 22s)

  • 0:00 — SQL vs NoSQL Databases
  • 0:52 — The World of SQL - Structured and Ordered
  • 1:25 — Key Features of SQL Database
  • 1:55 — ACID Properties
  • 2:32 — The Rise of NoSQL - Flexibility and Scale
  • 3:15 — Four Main Types of NoSQL
  • 3:48 — Key Differences of SQL (Relational) and NoSQL (Non-Relational) Databases
  • 4:26 — Vertical Scaling (Scaling Up) vs Horizontal Scaling (Scaling Out)
  • 4:57 — Strong Consistency (SQL) vs Eventual Consistency (NoSQL)
  • 5:34 — Usecases and Tradeoffs of SQL & NoSQL
  • 5:52 — When to Choose SQL Database?
  • 6:22 — When to Choose NoSQL Database?
  • 7:10 — Decision Framework - No One-Size-Fits-All Solution

Resources

For more in this series, visit the #system-design tag page or jump to the channel uploads list for everything else.

Related posts