What’s a database?

Every application needs a way to store and persist data. Data can be referred to as a collection of small units of information that exists in various formats like video, text, bytes, and so on.

A database is an organized collection of data. The data is organized in a way that makes it easy to access and manage properly. There are many databases available, like MySQL, Oracle, MongoDB, PostgreSQL, SQL Server, and so on. These databases power dynamic web applications.

SQL relational database

A relational database is a type of database that stores data in a table. It consists of rows and columns. In relational databases, each table can be interlinked with one another.

Suppose that we’re working on e-commerce and need to store customer information. We can use the tables below to represent the tables in a relational database. We can infer two tables, namely the “Customer Table” and the “Customer Contact Table.” The “Customer Table” has a relationship with the “Customer Contact Table” through the customer columns.

The information in a relational database can be obtained by using a query language called SQL (Structural Query Language). Examples of an SQL or relational database are Postgres and MySQL.

Get hands-on with 1200+ tech skills courses.