Building Scalable Web Applications Using AWS CLI & WordPress/

...

/

Types of Databases

Types of Databases

Learn about the different types of databases and their properties.

We'll cover the following...

Now that we know the most important terms regarding databases, let’s take a look at the different types of databases.

Relational databases

Relational databases organize data in tables. A table consists of related columns (attributes) and rows (data entries). The layout of these tables is called the database schema. To relate data from different tables with each other, keys are used to uniquely identify rows. Foreign keys in other tables can then be used to refer to the row of the source table.

Relational databases are still the most common type of database and are widely used across industries. Most relational databases are ACID compliant. Relational databases are usually queried with the Structured Query Language (SQL).

Examples of relational databases:

  • MySQL/MariaDB
  • PostgreSQL
  • Oracle
  • Microsoft SQL Server
...