SQL VS NOSQL
SQL stands for Structured Query Language. SQL uses query commands to define and manipulate data.
SELECT id, name. price FROM products
SQL requires you use a schema to define the structure of data before the can be manipulated. All of your additional data will require you to use the structure defined in the schema.

Here we have an example of a SQL users table. The table here has a top row that holds the fields(columns). Each subsequent row holds the records. You can not add records that don’t adhere to this schema.
The important benefit of SQL is table relations. this allows you to split data into multiple tables that are connected via relations. Here in the example we have whats called a one to many relationship.

If we wanted to know what pilots were flying what planes we would only have to check our flights table. The flights table has been related to the pilots and the planes. The main benefit of relations is you don’t end up with incorrect data in one table whilst having correct data in others. Data can be managed in one table and its not duplicated across tables.
NOSQL
NOSQL is named because it follows the opposite approach of SQL. There are no schemas , data is structured in collections and records are referred to as documents.

One of the main benefits of the NOSQL world is that you have the ability to add data of different structures into the same collection. SQL does not allow this you have to adhere to the schema for adding data.
NOSQL also lacks relations in SQL you relate relate data to the same location. if we had many flights to check in our above example we would check that one table and its related data. In the NOSQL world there is no joining or relation concept, instead what happens is you duplicate data across collections so that each collection holds the data that you’re searching for.