Difference Between SQL Vs NoSQL | Database | BDBMS

In this video we are discussing SQL versus no SQL

SQL stands for structured query language and no skill stands for not only SQL

So, what are the differences between them? Let us discuss on them

So at first we are having one comparable that is the SQL versus no SQL

So in case of SQL we're having this point, that is SQL is generally used for RDBMS, that

is a relational database management system. know that in case of relational database management system, the data will be having multiple

tables and tables will have a fixed static structure and tables will have multiple number

of rows and columns and each and every row will be known as a record or tappel and columns

will be denoting the fields or attributes of the tapple. So this is the basic concept in our ADBMS

But on the other hand in case of no SQL where having this no SQL is used for non-relational

and distributed database system. So, here we are having the concept of global data

So, as a result of that, as this no-SQL database will be the global data, so from different

locations, it can easily be accessed. Next one is the structured data can be stored in the tables

So, in case of SQL, we can only keep the structured data. But in case of no-SQL, so using

JSON data, unstructured data, can be stored there. So unstructured, semi-structured. and structured data, all kinds of data can be stored in NoSQL

The schemers are static. So here we cannot have the variability in the schemas but in this case the schemers are dynamic

We know that the NoSQL databases in case of MongoDB at least we having this the MongoDB is actually a cross and document database And in this case a database will have collections and collections will have multiple documents

and those documents may have variable structure. Schemers are rigid and bound to relationships

And in this case, the schemers are non-rigid and they are flexible

So, in this case, what will happen between the two tables, some common columns might be there

and through those column values the two tables will have some relationship

So, helpful to design complex queries but in case of no SQL, no interface to prepare the complex queries

So these are the differences between the SQL and the no SQL

So just consider this one. This is our SQL database. We can represent one SQL database that is a relational database in the forms of tables and tables

will have multiple rows and columns. We are having multiple rows and columns there

each and every row is known as a double or triple or record and these columns are known as a

respective attributes attribute values are there so in case of in case of no school databases

this table will be known as a collection and collection will have multiple documents and documents

will be represented in the form of key value pair so against one key we can have a single

value or multiple values so key value pairs will be there so here we are talking about

the fields and attributes and here the same thing will be known as the column

So this is a column family we are having. So now in case of document oriented database, in case of no SQL databases, we're having

the documents and a document can content other sub-documents, there is a nested documents

under it. So that's why we are having this hierarchical diagram for these documents

So these are the basic differences between the SQL databases and the no SQL databases

Thanks for watching this video