What is the difference between SQL and NoSQL?

Question

What is the difference between SQL and NoSQL?

Answer 1

SQL stands for Structured Query Language. It is a standard language for Relational Database Management System (RDBMS). It uses queries in to do manipulations such as create a table, read, update, and delete data from the database. SQL databases are table-based and they have a predefined schema. Also, they are vertically scalable. Relational Databases that use SQL include Oracle, MS SQL, and Postgres.

NoSQL on the other hand is a non-relational Database Management System. Unlike SQL, it has no declarative query language. It consists of a number of database technologies. NoSQL databases could be based on documents, key-value pairs or graph databases. They use dynamic schema for the unstructured data and they are horizontally scalable. Databases that make use of NoSQL are MongoDB, Redis, and Hbase.

If you want to learn more about the difference between SQL and NoSQL then read SQL Tutorial.

You must also, check out this video on the ‘SQL vs NoSQL’: