NoSQL vs SQL
Question
What is a key difference between NoSQL and SQL databases?
Hint
NoSQL types: document, key-value, column, graph.
Explanation
SQL databases (relational) use rigid, predefined schemas with tables, rows, and columns. NoSQL databases use flexible schemas: 1) Document (MongoDB) — JSON-like documents with varying fields. 2) Key-value (Redis) — simple key-value pairs. 3) Column-family (Cassandra) — wide columns. 4) Graph (Neo4j) — nodes and edges. NoSQL sacrifices some ACID guarantees for scalability, flexibility, and performance. SQL is better for complex queries, relationships, and transactions. NoSQL is better for unstructured data, horizontal scaling, and rapid development. Many systems use both (polyglot persistence).
Related Resources
Related Lessons
- NoSQL
Learn NoSQL.
Look up unfamiliar terms
A beginner-friendly glossary explains jargon in plain English — variables, functions, DOM, Promise, and more.
Decode error messages
Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.
Build real projects
Apply what you learned by building guided projects with starter code and solutions.