Create Your First Amazon 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 10 certification 2 lab-steps 4
Fundamentals of AWS
course-steps 5 certification 6 lab-steps 6 description 2
more_horiz See 2 more

Lab Steps

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

Ready for the real environment experience?

DifficultyBeginner
Duration1h 15m
Students8364
Ratings
4.7/5
star star star star star-half

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

Updates

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
PREVIEW
arrow_forward
Environment after
PREVIEW

About the Author

Students36256
Labs11
Courses4

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.