Create Your First Amazon RDS Database

The hands-on lab is part of these learning paths

Working with AWS Databases
course-steps 4 certification 1 lab-steps 4
Developer – Associate Certification Preparation for AWS - June 2018
course-steps 26 certification 4 lab-steps 22 description 2
Cloud Practitioner Certification Preparation for AWS
course-steps 10 certification 1 lab-steps 4 quiz-steps 2
SysOps Administrator – Associate Certification Preparation for AWS
course-steps 6 certification 1 lab-steps 18 quiz-steps 6
Solutions Architect—Associate Certification for AWS (2016)
course-steps 9 lab-steps 13 quiz-steps 12
Certified Developer—Associate Certification for AWS
course-steps 14 lab-steps 15 quiz-steps 18
SysOps Administrator—Associate Certification for AWS
course-steps 14 lab-steps 18 quiz-steps 13
Fundamentals of AWS
course-steps 6 certification 3 lab-steps 6
more_horiz See 6 more

Lab Steps

Logging in to the Amazon Web Services Console
Create an RDS Subnet Group
Create a database cluster using RDS
Setup security group rules for connecting to the RDS instance
Create an EC2 instance with a key pair
Connect to a remote shell using an SSH connection
Connect to RDS and create a database table
Validate Create Your First Amazon RDS Database

Ready for the real environment experience?

Duration1h 15m


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.


November 27th, 2018 - Added a validation Lab Step to check the work you perform in the Lab

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

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

About the Author


Antonio is an IT Manager and a software and infrastructure Engineer with 15 years of experience in designing, implementing and deploying complex webapps.

He has a deep knowledge of the IEEE Software and Systems Engineering Standards and of several programming languages (Python, PHP, Java, Scala, JS).

Antonio has also been using and designing cloud infrastructures for five years, using both public and private cloud services (Amazon Web Services, Google Cloud Platform, Azure, Openstack and Vmware vSphere).

During his past working experiences, he designed and managed large web clusters, also developing a service orchestrator for providing automatic scaling, self-healing and a Disaster Recovery Strategy.

Antonio is currently the Labs Product Manager and a Senior DevOps Engineer at Cloud Academy; his main goal is providing the best learn-by-doing experience possible taking care of the Cloud Academy Labs platform.