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
AWS Cloud DBA

AWS Cloud DBA free download

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 EC2 MySQL replica, migrating the backup to AWS S3 bucket, creating RDS DB instance from "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 the RDS instance

Learning about RDS for MySQL 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



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