Amazon RDS in 60 Minutes: Stop worrying about databases

Name: Amazon RDS in 60 Minutes: Stop worrying about databases
Rating: 4.3 (21 reviews)

Learn from Releaseworks Cloud Engineers: How to run and manage databases in AWS with Amazon Relational Database Service.

Created byReleaseworks Academy

Last updated 5/2020

English

English [Auto],

What you'll learn

How to create managed MySQL and PostgreSQL databases in RDS
How to create and restore snapshots
How to choose the right storage backend for your database
How to build a LAMP stack in AWS with RDS and EC2
How to set up monitoring for your database instance
How to architect for High Availability with RDS
How to manage RDS with Terraform (Infrastructure as Code)
You will get access to code examples that you can use in your own projects

Course content

6 sections • 24 lectures • 1h 2m total length

Welcome to Amazon RDS in 60 Minutes0:47
Join religious works academy to explore theory and hands-on exercises that build cloud engineering expertise, featuring Joe's dev ops guidance and prerequisites to help you release better software faster.
What you will learn on this course0:51
Learn to deploy and manage an rds-backed WordPress site, create and restore snapshots via the web console, AWS CLI, and Terraform.
How to create an AWS account3:15
Learn how to create an Amazon Web Services account, set up personal details and payment information, verify your email, and access the AWS management console to start using cloud services.
How to install Ubuntu Linux on Windows 10 with Windows Subsystem for Linux (WSL)3:19
Install and set up Windows Subsystem for Linux on Windows 10, choose a Linux distribution from the Microsoft Store, create a user, and run Unix command line tools with WSL.
How to install Terraform2:06
Install Terraform on Linux by downloading the Linux binary, unzipping it, setting permissions, and moving the binary to a system path so you can run Terraform from anywhere.

What is Amazon RDS0:51
Learn how Amazon RDS makes running relational databases easy on the internet by supporting MySQL, MariaDB, PostgreSQL, Oracle, and SQL Server, plus Aurora, with scalable read replicas and managed provisioning.
Benefits of using Amazon RDS0:41
Discover the benefits of using Amazon RDS, including easy setup, Multi-AZ high availability, automated backups, point-in-time restores within a 35-day retention window, encryption at rest, and access management.
Components of Amazon RDS0:46
Explore Amazon RDS components: instances as building blocks hosting isolated databases, configurable storage with auto scale, security via IAM and security groups, and multi-AZ standby replicas.

Database Instances1:06
Manage Amazon RDS instances, each with a regionally unique identifier tied to the ATO U.S. account; choose from dozens of instance classes and enable read replicas for elastic scaling.
Choosing the right storage0:35
Choose the right RDS storage by balancing provisioned storage at launch, auto scanning limits, and options like general purpose SSD, provisioned IOPS, and magnetic storage for legacy.
Database Engines0:44
Compare six database engines—Aurora, MySQL, MariaDB, PostgreSQL, Oracle, and SQL Server—within Amazon RDS, highlighting Aurora's performance edge, licensing impacts, multiple major/minor versions, and the option to disable automatic upgrades.
Architecting for High Availability0:51
Architecting for high availability in Amazon RDS uses multi-AZ standby databases and VPC designs that avoid single points of failure. Cross-region read replicas can be promoted during failover.
Billing and costs of Amazon RDS0:41
Understand Amazon RDS billing, covering instance hours, storage per GB per month, input and output requests per million, backup storage, data transfer, and reserved instances for 1 or 3 years.
Backing up your RDS databases0:59
Learn how to back up and restore your RDS databases with automated backups, daily snapshots, point-in-time restore, and manual snapshots, balancing cost and performance.
Monitoring your RDS databases0:40
Learn to monitor RDS databases using SNS alerts via email, access database logs via console or API, and export metrics to CloudWatch with enhanced monitoring and alarms.

Using Amazon RDS0:39
Explore creating database instances with Amazon RDS using the AWS console, API, and infrastructure-as-code tools like CloudFormation and Terraform, including a WordPress deployment later.
Lab: Create an RDS Database Instance using the AWS console8:56
Create an AWS RDS Postgres database using the console, configure engine and version, set storage and VPC, adjust security groups, enable backups, and connect via the endpoint for testing.
Lab: Create and restore database snapshots in the AWS console2:37
Create and restore database snapshots in the AWS console to form a new database instance. Downgrade the instance class and delete snapshots and databases to avoid costs.
Lab: Create an RDS instance using the AWS CLI6:32
Create and connect an AWS RDS Postgres instance using the AWS CLI, configuring engine, storage, instance class, security group, subnet group, master user, and backup retention, then connect via psql.

Introduction: Build and deploy WordPress on a LAMP stack in AWS with RDS1:05
Apply infrastructure as code to manage cloud resources, enabling code reviews, testing, and rollbacks, while deploying WordPress on a lamp stack in AWS with RDS database in a six-subnet VPC.
Lab: Build and deploy WordPress on a LAMP stack in AWS with RDS22:59
Build a complete WordPress infrastructure on a lamp stack in aws using rds and terraform, with vpc subnets, security groups, and plans for high availability.

Five Takeaways from this course0:56
Discover how to run highly available databases with minimal admin overhead using audience as a service, with Amazon handling provisioning, installation, updating, replication, private subnets, and point-in-time restores.
Congratulations0:37
Celebrate completing the course and showcase your cloud and dev ops skills by downloading your certificate for your CV and social media.
Bonus: Recommended further learning0:11

Requirements

Basic understanding of relational databases is helpful
You will need an AWS account (instructions provided in course)

Description

"In my 20 years in technology, I have never met a person who would passionately enjoy managing relational databases. The good news is that now you won't have to."

- Miiro Juuso, Founder of Releaseworks

Learn from industry-leading DevOps and Cloud Engineers at Releaseworks:

In the next 60 minutes, you will learn how to run managed databases in AWS with Amazon RDS. Amazon Relational Database Service, or RDS, takes care of the operational aspects of running databases, like taking backups, upgrading versions, and setting up high availability, helping you to concentrate on what matters most. Amazon RDS supports MySQL, PostgreSQL, MariaDB, MS SQL Server, Oracle, and Aurora databases.

Amazon RDS in 60 Minutes includes 4 labs to help you practice along with the instructor, and learn by doing.

This course includes all you need to know to get started with RDS, carefully distilled into just one hour of lessons and hands-on labs. We will also provide you access to all the code examples and commands we use in this course to get you started in your own projects.

If you want to have a managed SQL database running in AWS within the next hour, tap Enroll Now, and let’s get started.

Did you know that DevOps is one of the most sought-after set of skills in the job market right now, with tens of thousands of open roles globally. According to PayScale, the median DevOps salary in the U.S. is $93,770 per year. The best DevOps specialists on the market can name their price, and often earn more than $200,000 in a year. The best time to start learning DevOps was 5 years ago - the second best time is now!

Releaseworks is an upskilling-focussed DevOps and cloud engineering consultancy based in London. We help some of the largest digital organizations in the world to take full advantage of the cloud, and implement DevOps ways of working. Our mission is to help software development teams release better software, faster. Releaseworks Academy is the collection of learning resources that we use to upskill the software development teams of our clients, as well as our own cloud engineers.

Who this course is for:

Software developers who want to outsource the trouble of managing databases to AWS
System administrators who are looking to migrate on-premises databases into AWS

Amazon RDS in 60 Minutes: Stop worrying about databases

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 10min

Getting Started3 lectures • 2min

Diving into RDS7 lectures • 6min

Hands On with Amazon RDS4 lectures • 19min

Managing RDS with Terraform2 lectures • 24min

Afterword & Next Steps3 lectures • 2min

Requirements

Description

Who this course is for: