hands-on lab

Create Your First Amazon RDS Database

Difficulty: Beginner
Duration: Up to 1 hour and 15 minutes
Students: 37,297
Rating: 4.7/5
Get guided in a real environmentPractice with a step-by-step scenario in a real, provisioned environment.
Learn and validateUse validations to check your solutions every step of the way.
See resultsTrack your knowledge and monitor your progress.

Description

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 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

Updates

May 2nd, 2024 - Resolved AWS Systems Manager issue

March 21st, 2024 - Resolved RDS database creation issue

August 30th, 2023 - Updated the instructions and screenshots to reflect the latest UI

February 3rd, 2023 - Updated the instructions and screenshots to reflect the latest UI

March 29th, 2022 - Added instructions for clarity

December 28th, 2021 - Updated screenshots to reflect the latest UI

December 24th, 2020 - Added a warning to prevent a bug in the AWS Console that doesn't allow the selection of availability zones when creating the subnet group

November 3rd, 2020 - Updated db instance type screenshot and instruction

August 11th, 2020 - Resolved an issue causing the MySQL security group inbound access check to fail

August 10th, 2020 - Updated the steps to create a VPC security group to associate to the RDS DB

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 20th, 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 the new UI

Environment before

Environment after

Covered topics

Lab steps

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