What is the difference between NoSQL and SQL?

SQL databases are primarily called as Relational Databases (RDBMS) whereas NoSql database are primarily called as non-relational or distributed database

SQL/NoSQL databases are similar, but there will be minor differences in features and syntax.

Hi Annas,

SQL databases are primarily called as Relational Databases (RDBMS); whereasNoSQL database are primarily called as non-relational or distributed database. SQLdatabases are table based databases whereas NoSQL databases are document based, key-value pairs, graph databases or wide-column stores.

SQL tables are ideal for storing data that is structured, grouping the categories into Schemata. Structured data like names, addresses, contact numbers, etc. fits nicely into an SQL format.

However, today’s data isn’t always neatly structured, and another format is needed that is not dependent on the relationships of the data. This is where NoSQL comes in. It allows for the storage of unstructured data across multiple processing nodes without categorizing the data into fixed tables and schemata. Usually, a NoSQL database scales horizontally.

Hope this helps.

for more read an article in detail:

https://www.sitepoint.com/sql-vs-nosql-differences/

Feel free to contact in case of any query.

Thanks,

Mazhar Ali | Oracle DBA

SQL databases uses SQL ( structured query language ) for defining and manipulating the data, which is very powerful. In NoSQL database, queries are focused on collection of documents. Sometimes it is also called as UnQL (Unstructured Query Language). The syntax of using UnQL varies from database to database.

SQL databases are primarily called as Relational Databases (RDBMS); whereas NoSQL database are primarily called as non-relational or distributed database.