Search⌘ K
Home
Courses
Building Scalable Web Applications Using AWS CLI & WordPress

Types of Databases

Discover the main types of databases such as relational, NoSQL, caching, and graph databases. Learn their unique structures and use cases within AWS managed services to build efficient, scalable web applications.

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
...