The following below difference between SQL & NoSQL
| SQL | NoSQL | |
| 1 | Table Base Database Approach | Document base Database approach |
| 2 | Predefined Data , | Non Predefined , |
| 3 | Support Structured Data | Support Unstructured Data |
| 4 | Store Data as Tabular Format | Store Data Format as Key-value pair, Document-oriented, Column-oriented, Graph-based, Time series, |
| 5 | Store Less Volume of Data | Store Large Volume of Data |
| 6 | SQL databases are vertically scalable | NoSQL databases are horizontally scalable |
| 7 | Used for multi-row transactions records | Used for documents or JSON records |
| 8 | Used Normalized Data Structure | Used Non Normalized Data Structure |
| 9 | SQL databases follow ACID properties (Atomicity, Consistency, Isolation, and Durability) | NoSQL database follow CAP theorem (Consistency, Availability, and Partition tolerance) |
| 10 | Popular SQL Database as MySQL, SQL Server, SQLite, PostgreSQL | Popular NoSQL as MongoDB, Redis |