Create Your First Amazon RDS Database

Lab Steps

Logging in to the Amazon Web Services Console
Creating an RDS Subnet Group
Creating a Database Using RDS
Setting up Security Group Rules for Connecting to the RDS Instance
Starting an AWS Systems Manager Session Manager Browser Shell Session
Connecting to RDS and Creating a Database Table
Deleting an RDS Database

The hands-on lab is part of these learning paths

Working with AWS Databases
course-steps 4 certification 2 lab-steps 4
Certified Developer – Associate Certification Preparation for AWS
course-steps 29 certification 5 lab-steps 22 description 2
AWS Cloud Practitioner Certification Preparation
course-steps 11 certification 2 lab-steps 5
Fundamentals of AWS
course-steps 6 certification 6 lab-steps 6 description 2
more_horiz See 2 more

Ready for the real environment experience?

Time Limit1h 15m
star star star star star-half


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.

Lab Objectives

Upon completion of this Lab you will be able to:

  • Use the AWS Management Console to create RDS subnet groups
  • Create RDS database clusters
  • Manage access to RDS clusters using security group rules
  • Connect to your RDS cluster and edit tables

Lab Prerequisites

You should be familiar with:

  • The basics of working with Linux at the command line
  • Networking rules and database concepts familiarity is helpful but not required


April 19th, 2020 - Updated the Lab to reflect the latest Console interface

March 12th, 2020 - Inserted a lab step that instructs the user to destroy an RDS instance

September 13th, 2019 - Updated the lab IAM policy to allow the RDS DB instance to be created after recent changes AWS' made to IAM condition processing for creating RDS DB instances

August 20rd, 2019 - Updated the Lab to reflect AWS's newest user interface

July 3rd, 2019 - Updated database creation instructions to include the storage autoscaling option

May 31st, 2019 - Replaced SSH connection with a browser-based Session Manager shell

May 30th, 2019 - Updated the formatting of this Lab to improve quality

May 2nd, 2019 - Updated screenshots and instructions to improve the lab's quality

March 7th, 2019 - Updated screenshots and instructions because of AWS dashboard changes

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

Environment before
Environment after

About the Author

Learning paths1

Matt has worked for multiple Fortune 500 companies as a DevOps Engineer and Solutions Architect. He is an AWS Certified Solution Architect - Associate, AWS Certified SysOps Administrator - Associate and an AWS Certified Developer - Associate. He enjoys reading and learning new technologies.