Assignments.

What are the differences between No SQL and SQL.

   Answer;

The SQL is a programming language used to manage relational databases

Whereas;

No SQL is collective name for databases which provide mechanism for storage and retrieval of data in means other than used in relational databases.

 No SQL:

I. No SQL is non relational 2. No SQL Is dynamic schema 3. No SQL document is based key value pairs 4 No SQL is horizontally scalable 5. No SQL follows CAP the aram.

Example of no SQL databases

1. Red is

2. Found DB

3. Couch DB

4. Mongo DB

5. Cassandra

6. Elastic search.

    SQL :
   

   Answer;

7. SQL is relational

8. SQL is predefine schema

9. SQL is table is based

10. SQL is vertically scalable

11. SQL is emphasis on ACID properties

    Example of SQL databases

12. Db2

13. Db3

14. My SQL

15. Gugabyte DB

16. Cockroach DB

17. Oracle database

18. Microsoft SQL server.