Databases on AWS

As mentioned in the introduction, AWS currently offers 15 different databases for you to choose from. This is a huge number, and therefore, this topic is seen as one of the hardest by many solutions architects. For the SAA-C03 exam, you will need to know the basic use cases and benefits of each database type, and for the most used databases, you will also need to know how to perform basic admin and troubleshooting tasks. We will start by looking at relational databases.

Relational Databases

First, let’s explain what relational databases are and why they exist. Back in the 1970s, when databases first became popular for data storage and retrieval, storage costs were extremely expensive. Any data that was duplicated or redundant was very costly. To prevent duplication, tables became a store for one type of object, and they were linked to other tables if you needed more details. For example, a table holding Orders would only hold orderID, customerID, and...