What is a Database?

A Database is a digital storage space for some data. Imagine it as an organized file that contains related data in neatly organized sections. It makes it easy to store and retrieve data.

We typically access and modify databases using a Database Management System (DBMS), which is appropriate for that kind of database.

A Database combined with a Database Management System is sometimes referred to as a Database System.

There are many types of database systems. Some databases store data in the form of rows, columns, and tables - such databases are called Relational Databases. Other types of databases are commonly known as Non-Relational or NoSQL Databases, which may store data in the form of documents, key-value pairs, or some other format.

Most of the applications we use in everyday lives, like websites, social media, etc, make use of relational databases as it is the most popular and robust form of database. Therefore, in this section, we will be using a MySQL Server, which is a powerful database management system that uses SQL.

SQL stands for Structured Query Language, which is a language for interacting with a Relational Database, for example, storing and retrieving information. A MySQL database uses SQL for database operations.