I have heavily worked on the MongoDB NoSQL Database and oracle.

Schema

SQL database has its own predefine schema to store structure data

In NoSQL database, there is no predefine schema, here schema is most dynamic element based on the data elements

Scalability

SQL Databases are vertically scalable, means if we want to scale SQL base database, we need to give hardware boost on which the DBMS System is installed. This is where it sometimes goes for the limitation of scalability.

NoSQL database are horizontally scalable, means if we want to scale it, we need to add more nodes and create distribution network based on our own need and required power. This is how it reduce load on the database

Data Retrieval

In SQL based database, to define and manipulate data we can use SQL (Structure Query Language), which is very powerful now a days

In terms of NoSQL database queries are focus on the collection and documents. Sometimes it is called as UnQL (Unstructured Query Language). This is still in the evolution phase, so it is varies from vendor to vendor of the NoSQL database

For more on key difference here

I have heavily worked on the MongoDB NoSQL Database and Oracle.

Schema

SQL database has its own predefined schema to store structured data.

In NoSQL database, there is no predefined schema, here schema is most dynamic element based on the data elements.

Scalability

SQL Databases are vertically scalable, which means if we want to scale SQL base database, we need to give hardware boost on which the DBMS System is installed. This is where it sometimes goes for the limitation of scalability.

NoSQL databases are horizontally scalable, means if we want to scale it, we need to add more nodes and create distribution network based on our own need and required power. This is how they reduce load on the database

Data Retrieval

In SQL based databases, to define and manipulate data we can use SQL (Structured Query Language), which is very powerful nowadays.

In terms of NoSQL database, queries focus on collection and documents. Sometimes it is called UnQL (Unstructured Query Language). This is still in the evolution phase, so it varies from vendor to vendor of the NoSQL database.

For more on key differences, my blog: Difference between SQL and NoSQL database

I have heavily worked on the MongoDB NoSQL Database and oracle. Please find key difference here

I have heavily worked on the MongoDB NoSQL Database and oracle.

Schema

SQL database has its own predefine schema to store structure data

In NoSQL database, there is no predefine schema, here schema is most dynamic element based on the data elements

Scalability

SQL Databases are vertically scalable, means if we want to scale SQL base database, we need to give hardware boost on which the DBMS System is installed. This is where it sometimes goes for the limitation of scalability.

NoSQL database are horizontally scalable, means if we want to scale it, we need to add more nodes and create distribution network based on our own need and required power. This is how it reduce load on the database

Data Retrieval

In SQL based database, to define and manipulate data we can use SQL (Structure Query Language), which is very powerful now a days

In terms of NoSQL database queries are focus on the collection and documents. Sometimes it is called as UnQL (Unstructured Query Language). This is still in the evolution phase, so it is varies from vendor to vendor of the NoSQL database

For more on key difference here