SQL vs NoSQL Explained
Tables or documents? How each stores data, and when to pick which
What you'll learn
- Tables, joins and transactions in SQL databases
- Document, key-value, wide-column and graph databases
- The scaling and consistency trade-offs
- Why Postgres is a good default, and when NoSQL fits better
In this video, we'll look at how SQL and NoSQL databases differ and when to use each one. We'll cover relational databases like PostgreSQL and MySQL, document databases like MongoDB, key-value stores like Redis, and how they store data differently.
We'll also look at joins, transactions, flexible data, spreading data across servers, and the trade-offs between the two.
By the end, you'll understand the key differences and why Postgres is a good default unless you have a clear reason to pick NoSQL.
