Create Your First Amazon RDS Database


6536 students completed the lab in ~45m

Total available time: 1h:15m

4260 students rated this lab!

How to launch and connect to an Amazon RDS DB instance

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. You can migrate existing applications and tools that utilize a relational database to the Amazon Web Services because Amazon RDS offers access to the capabilities of a MySQL, Oracle, SQL Server, and the PostgreSQL database engine. Amazon RDS provides cost-efficient and resizable capacity while managing time-consuming database administration tasks. This efficiency frees you to focus on your applications and business.

This lab is focused on Amazon RDS. Follow along and learn to create and use your first RDS database with Amazon AWS.


May 14th, 2018 - Updated screenshots and improved instruction clarity for connecting to the EC2 instance

April 9th, 2018 - Updated screenshots to match new UI

Follow these steps to learn by building helpful cloud resources

Logging in to the Amazon Web Services Console

Your first step to start the Lab experience

Create an RDS Subnet Group

How to create a DB Subnet Group for RDS instances

Create a database cluster using RDS

Create an RDS instance using the MySQL engine

Setup security group rules for connecting to the RDS instance

How to add the right rules to connect to the RDS instance

Create an EC2 instance with a key pair

Launch a new EC2 instance using the AWS Management Console's Launch Instance wizard with a SSH key pair for remote connection

Connect to a remote shell using an SSH connection

How to use a remote Linux shell from Windows, Linux or Mac

Connect to RDS and create a database table

How to use the mysql client to connect to an RDS instance

Destroy an RDS instance

How to destroy an RDS instance