Introduction to Amazon RDS
Relational databases are also known as SQL databases (as opposed to non-relational databases, classified as NoSQL or Not Only SQL). You will learn more about the non-relational or NoSQL databases later in this chapter. However, this definition is incorrect. SQL stands for Sequel Query Language and is a language used to manage data (add, edit, update, retrieve, and delete data among others) on databases. The term SQL is often used interchangeably with relational databases.
Amazon RDS is a managed relational database service offering six database engines. These are MySQL, PostgreSQL, Microsoft SQL Server, Oracle, MariaDB, and Amazon’s own proprietary database, Amazon Aurora. It’s important to note that Amazon Aurora is a different product that you will look at in more detail later in this chapter.
A relational database uses the concept of tables to store data. Relational databases allow you to define multiple tables within the database;...