AWS Cloud DBA

Grab a highly demanded, job-oriented MySQL DBA career, mastering the AWS RDS for MySQL from this top Cloud DBA course

AWS Cloud DBA Course Overview

Welcome to this amazing course on Cloud MySQL Database Administration. You will learn all aspects of MySQL Server, including setting GTID-based Master/Slave Replication, creating an EC2 MySQL replica, migrating the backup to AWS S3 bucket, and creating an RDS DB instance from the "Restore from S3" method.

Creating & managing Multi-AZ DB instance, Multi-AZ DB cluster, RDS Read Replicas.

Managing RDS Automated Backups, Copying/Upgrading/Migrating/Exporting/Replication DB Snapshots.

Upgrading your RDS instance by leveraging Blue/Green Deployments.

Performance Tuning & Enhanced Monitoring of the RDS instance

Learning about RDS for MySQL's new features

All with real-world, practical exercises & examples.

Topics Covered in AWS Cloud DBA Course

1. MySQL Community Server installation on Red Hat Enterprise Linux

2. GTID-based Replication Setup

3. AWS Virtual Private Cloud (VPC), Subnets, Security Group, IGW

4. AWS Command Line Interface Tool (AWS CLI)

5. XtraBackup

6. AWS S3 buckets

7. RDS for MySQL

8. DB Subnet Groups

9. DB Parameter Groups

10. Multi-AZ DB Instance & Clusters

11. RDS Read Replicas

12. RDS Automated Backups & DB Snapshots

13. RDS Events

14. RDS Proxy

15. Performance Insight & Enhanced Monitoring

16. Blue/Green Deployments

17. Data Migration Services (AWS DMS)

Course Content

1. Course Introduction

2. On-Premises MySQL Setup

3. Setting Up AWS EC2 Replica

4. AWS S3 Setup

5. Creating AWS RDS for MySQL

6. Setting Up RDS Replica

7. AWS CLI MasterClass

8. Application Migration to RDS for MySQL

9. Multi-AZ RDS Setup

10. RDS Backup & Recovery

11. RDS Monitoring & Performance Tuning

12. Amazon RDS for MySQL Features

13. AWS Data Migration Services (DMS)

14. Course Wrap-Up
    

Course Prerequisites

Basic understanding of any RDBMS, especially MySQL. It is highly recommended that, prior to enrolling in this course, you should have taken the Becoming a Production MySQL DBA course.

Who is this course for

• Database Administrators

• Cloud Administrators

• Junior DBAs

• MySQL Database Administrators

COURSE UPDATES:

* DBA interview questions added per section

* AWS Database Migration Services (DMS)