SQL Unleashed: Mastering Data with Precision and Power

This sounds odd when i say that i am a Backend Developer with no knowledge of SQL database. But it true when i start learning MERN tech stack i had learn MongoDB for tech stack and have to start working on MongoDB. Which follow NoSQL architecture. But as far as i dive into the Backend technologies i learned that you won’t find NoSQL every company.

Cause NoSQL is used by them who has the large amount of Datasets with no relations between data. For example Amazon, Google and Netflix using the NoSQL database. Cause they have huge amount of users and their data.

But when a startup starts its data is not that large so its easy and convenient to use SQL database. SQL follows the Table structure where in NoSQL data store in objects like for user John there a documents which holds his name, contacts, address and other details in a single objects, and for every user their data objects stores in DB.

Whereas in SQL data stores in row means for user Alex and John there are 2 rows which holding their details such as name, contact etc.

DBMS vs RDBMS

DBMS stands for database management system. I was used to confused whenever someone ask what is DBMS and RDBMS. RDBMS is Relational database management system. But then i read some documentations and find that. I’ll with a example : When you use MongoDB that is not database .

Database is the container which store your data that means its a memory and its obvious it is secondary memory aka Hard Disk usually. DBMS is a software system that provides an interface to interact with databases, enabling the storage, retrieval, insertion, deletion, and update of data. And then who manage this storage , maintain them Management System. And after combining all a Management System who mange the NoSQL database called DBMS. And one who mange SQL which follow the relational structure called RDBMS.

• DBMS = Software that manages databases (SQL and NoSQL alike).

• RDBMS = A specific type of DBMS that follows relational models (uses SQL, tables, and defined relationships).

— DBMS: MongoDB, Cassandra, CouchDB, Redis

—RDBMS: Postgres, MySQL, Oracle, SQLite