Let's explore the differences between SQL and NOSQL databases.

2

1.

NO SQL Not Only SQl

SQL  Structured Query Language

2

Schema

3

SQLL Schema s pre-defined NOSQL A Dynamic schema is used for unstructured data

Type

4

SQLL Table based databases NOSQL Document based, key-value pairs & graph databases

Best Option

5

SQLL When You need to support dynamic queries NOSQL When you need to scale based on changing requirements 

Examples 

6

SQLL Oracle, Postgres & MS-SQL NOSQL Redis, MongoDB, Cassandra & Hbase