AWS Cloud DBA

• Migrate on-premises MySQL database to the RDS for MySQL on the AWS cloud
• Manage RDS for MySQL Multi-AZ DB Cluster
• Master AWS Command Line Interface - AWS CLI
• Learn how to create RDS DB instance by Restore from S3 Method
• Learn Cross-Account, Cross-Region RDS DB Snapshots
• Learn about RDS DB Subnet Groups, DB Parameter Groups, RDS Proxy
• Learn how to failover Multi-AZ DB instance, create RDS Read-Replica
• Master the Amazon RDS Blue/Green Deployments for databases
• Learn from real-world, hands-on practical examples

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 DBcluster, 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'snew 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 & DBSnapshots

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 CLIMasterClass

8. Application Migration to RDS for MySQL

9. Multi-AZ RDS Setup

10. RDS Backup &Recovery

11. RDS Monitoring & Performance Tuning

12. Amazon RDSfor 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)