Think of a database as a massive digital filing cabinet where all a company's information is securely locked away. SQL is simply the universal key that lets you open that cabinet, instantly sorting through millions of files to pull out the exact answer you need.

We have just introduced some new words that we are going to define below:

Data - Is raw pieces of information that can be stored, processed and analyzed

Database - Is an organized collection of related data stored in a structered way

SQL(Structured Query Language) - Is a structured language used to interact with relational databases

Benefits of a database

Easy updates and modification

Easy retrieval of specific information

Efficient storage of large volumes of data

Reduced duplication of data

There are two types of databases:

1.Relational Databases(Relational Databases Management System)

This is a database that stores tables made up of rows and columns.

Tables can be related to each other using keys

eg - PostgreSQL, MySQL, Oracle…