difference between sql and nosql with example

Example 1: difference between nosql and sql

SQL						|    NoSQL
  relational			| non-relational
  						|
use structured query	| NoSQL databases have 
language and have a		| dynamic schemas for 
predefined schema.		| unstructured data.
						|
are vertically scalable | are horizontally scalable.
are table based			| are document, key-value,
						| graph or wide-column stores.
                        |
are better for multi-row| are better for unstructured 
transactions			| data like documents or JSON.

Example 2: sql vs nosql

-----------------
key differences |
-----------------
SQL databases are usually RDBMS or DBMS
(Relational DataBase Management Systems) and are table based,
NoSQL uses unstructured data (like graphs)

-----------------
Examples        |
-----------------
SQL Databases:
MySQL
SQLite
Oracle DB

NoSQL:
MongoDB
DynamoDB

Tags:

Sql Example