What is SQL?

Introduction to SQL:

SQL stands for Structured Query Language. This is called a language because this works as a language to communicate between SQL and databases. We have data stored in databases, So SQL is used to manage, retrieve, manipulate and organizing data from database. With the help of SQL, we can solve real world data problems.

SQL is used in many fields such as Data Science and Machine Learning, Business Analytics and Management, Marketing and market research.

This makes SQL one of the most in demand skills to learn right now.

?Relation between SQL and Databases:

?Introduction to Database:

Understanding the database and its structure is very important before we start leaning SQL, SQL is a language, we communicate with data base using this language called SQL.

A data base – Database Management System (DBMS)- is a collection of data organized and stored in structured format.

There are 2 types of databases:

1.??????Relational Database (SQL is used here)

2.??????Non-Relational

Non- Relational Database:

You may be aware or might have heard about python data type Dictionary, we store data in a key-value pair format in dictionary and also use same format for a dictionary within a dictionary (nested dictionary type)

Similarly, in a non-relational data base, data is stored in a key-value pair system. Let’s see this here.

Customer is a container in non-relational database and we have added details for 2 customers here, there may be a lot of containers like this in non- relational database.

For understanding purpose, the above-mentioned information can be read in tabular format like this.

Relational database:

In a relational data base, data is stored in a tabular format. see the below table for country by their GDP value.

Here this table is in relational database, there may be other tables like this as well in the database.

The word relational is used because there can be a relation between 2 or more tables present in relational database.

Thank you for reading!!