What is the difference between SQL and NoSQL?

Question

Accepted Answer

SQL is a relational database management system while NoSQL is a non-relational database management system.

SQL databases are table-based while NoSQL databases are document-based, key-value pairs, graph databases, or column-based.
SQL databases are structured while NoSQL databases are unstructured.
SQL databases use SQL (Structured Query Language) for querying and managing data while NoSQL databases use different query languages like MongoDB uses JSON-like documents.
SQL databases are vertically scalable while NoSQL databases are horizontally scalable.
SQL databases are good for complex queries while NoSQL databases are good for large amounts of unstructured data.
Examples of SQL databases are MySQL, Oracle, and PostgreSQL while examples of NoSQL databases are MongoDB, Cassandra, and Redis.

HashedIn by Deloitte Senior Software Engineer 1 interview questions & answers