SQL vs NO-SQL Databases — Everything you need to know

Image Source: https://gowithcode.com/wp-content/uploads/2021/04/sql-vs-nosql.jpg

Hello everyone. In this article, we will be looking at what is SQL and NoSQL databases and then we will continue in-depth about both these types and also discuss their benefits and use cases.

What is a SQL / Relational Database?

SQL databases have been used for decades and they are also called Relational databases. Relational databases store data in a structured tabular format (using rows and columns). In this way, the data can be easily identified and retrieved. It is called relational because the relationships can be established between the tables through mapping fields.

SQL stands for Structured Query Language, the language used by relational database management systems. It is a declarative language and the SQL commands can be divided into 5 categories based on their functionalities as follows

Image Source: https://blog.devart.com/wp-content/uploads/2021/12/sql-commands-1.png

1. Data Definition Language(DDL)
2. Data Control Language (DCL)
3. Data Manipulation Language (DML)
4. Transaction Control Language (TCL)
5. Data Query language (DQL)

Some of the popular relational databases are

• MySQL
• Oracle
• PostgreSQL
• Microsoft SQL Server
• SQLite
• MariaDB
• IBM DB2

ACID Properties in Relation Database

Relational Databases follow the ACID principles as follows

Image Source: https://miro.medium.com/max/700/1*NiBUO-GUctIeR6bgHTb51g.png

What is a NO-SQL Database?

Image Source: https://cdn.educba.com/academy/wp-content/uploads/2019/05/what-is-Nosql-database1.png

NoSQL stands for Not only SQL Database and any database which is non-relational falls under NoSQL database. These databases are non-tabular…