Your Instructor - Cloud Certified DBA
(OCP, MCDBA, KCA, RHCSA, MSIT)
Rest assured, You're in excellent hands with your instructor, Abid Malik. A traditional DBA turned cloud certified database administrator with over 20 years of experience across diverse technical roles supporting Oracle, SQL Server, MySQL, MongoDB in 24x7 critical production environments.
Abid Malik has unique teaching style where he teaches Bob by challenging him with real-world DBA tasks & at the end of each section, Bob places check marks next to each concept that he has learned so for.
Recognized with distinguished title as a best instructor for his top-rated premium "Becoming a Production MySQL DBA" course with over 10,000 students worldwide, 4.8 instructor rating, and ever growing 5-star reviews.
What You Will Learn
- End to end On-premises to AWS cloud database migration.
- GTID-based master-slave replication.
- RDS instance by Restore from S3 method.
- Managing Multi-AZ DB cluster.
- RDS Read Replicas.
- Blue Green Deployments.
- RDS Monitoring & Performance Tuning.
- RPO & RTO.
- Automated Backups & AWS Backup.
- Cross-Region Replication (CRR) of DB Snapshots.
- AWS Command Line Interface (CLI) Masterclass.
- Amazon RDS for MySQL Features.
- AWS EC2 Replica Setup.
- XtraBackup tool for hot backups.
- Major & Minor MySQL version upgrade.
- Application migration for backend database from data center to RDS.
- Switching Replica from On-Premises Primary to RDS.
- And many more Real-world scenarios.
Excellent MySQL Course
I have never experienced such an excellent and well-structured training before. This phenomenal tutorial on MySQL is outstanding. Now, I can confidently say I know MySQL thanks to your extraordinary training sessions. God bless you with immense blessings. Happiness truly lies in sharing, and you have generously shared your expertise, simplifying complex topics with concise and clear videos - Rajesh G
Best DBA Course
The best course I have ever did by far, I did six and this one is the only one that show real administration tasks, the other just show how to insert a row in a table...... Excellent course, keep up - Mariela A
Real DBA Course
Many tutorials label themselves as DBA but actually provide sql developer content. This tutorial here actually deals completely with DBA stuff. Good for developers who want to know the internals of MySQL and tune their db better - Sagun S
Interactive Tutorials
Grasp the concept through visually engaging presentation, followed by practically doing it. Each topic is visually explained to enhance the knowledge of student.
Check Mark Your Success
Put a green check mark on each concept at the end of each section indicating that you have mastered these tasks.
Challenging Exercises
Test your knowledge by solving challenging exercises to gain read-world cloud database administration experience.
Money-Back Guarantee
Your satisfaction is our top priority, we are committed to provide you quality content with 100% guarantee. We offer 7-day money-back guarantee, watch the course for a week and if you don't like it, just email us and we will refund you your money.
Certificate of Completion
Upon successful completion of the course, a Certificate of Completion will awarded.
Course Curriculum
- Section Introduction (1:37)
- Project Overview (6:26)
- Creating VMs (6:58)
- Disabling SELINUX (6:30)
- Installing MySQL on Primary & Replica (9:27)
- Securing MySQL Installation (7:09)
- Setting Up GTID-Based Replication (15:16)
- Testing GTID-Based Replication (4:14)
- Project Checkpoint (4:10)
- Section Summary (0:57)
- Quiz
- Section Introduction (1:43)
- Introduction to RDS for MySQL (4:55)
- RDS Terminology (8:07)
- RDS Interface (15:06)
- Creating IAM Role for RDS (3:34)
- What is Subnet Group? (7:44)
- Creating Subnet Group for RDS Instance (4:50)
- Creating Security Group for RDS Instance (3:21)
- What is DB Parameter Group? (10:13)
- Creating DB Parameter Group for RDS Instance (4:11)
- Creating RDS for MySQL Instance (9:00)
- Section Summary (1:14)
- Section Introduction (1:53)
- Project Overview (5:13)
- AWS CLI Structure (9:13)
- Configuring AWS CLI Tool (3:12)
- Creating & Assigning VPC & IGW (12:15)
- Creating Subnets (4:35)
- Creating Route Table (5:30)
- Attach Subnets to Route Table (4:31)
- Creating Security Group (4:49)
- Creating DB Subnet Group (3:32)
- Creating DB Parameter Group (2:51)
- Creating IAM Role (5:45)
- Restoring RDS Instance from S3 Backup (6:06)
- Configuring RDS for GTID-Based Replication (8:38)
- Deleting RDS Instance (3:07)
- Deleting VPC & Network Stack (4:12)
- Section Summary (0:59)
- Section Introduction (6:18)
- Removing EC2 Replica (5:52)
- Pointing On-Prem Replica to RDS (7:00)
- Understanding Replication Filter (7:18)
- Cutting Over from On-Premises to RDS (8:34)
- Performing Minor MySQL Version Upgrade (9:13)
- Troubleshooting Replication Error (8:59)
- Performing Major MySQL Version Upgrade (7:09)
- Removing On-Prem Replica (11:30)
- Creating RDS Read-Only Replica (6:54)
- Section Summary (2:41)
- Section Introduction (4:13)
- RDS Overview (6:34)
- RDS Events (4:26)
- RDS Certificate (5:37)
- Recommendations for RDS (3:48)
- Option Group for RDS (4:17)
- Reserved Instance for RDS (5:07)
- Zero-ETL Integrations (3:42)
- Default Network (3:21)
- Creating & Managing RDS Proxy (11:54)
- EC2 Connection (6:28)
- Section Summary (5:51)
- Section Introduction (3:50)
- Assigning Custom Parameter Group to RDS Read-Only Replica (6:52)
- Performing Minor Version Upgrade on RDS Read-Only Replica (5:50)
- Promoting RDS Read-Only Replica (4:15)
- Converting into Multi-AZ DB Instance (5:27)
- Stopping a RDS Instance Temporarily (4:43)
- Deleting RDS Multi-AZ DB Instance (3:02)
- Converting into Multi-AZ DB Cluster (12:07)
- Rebooting Multi-AZ DB Cluster Reader (3:43)
- Failing Over Multi-AZ DB Cluster (3:06)
- Creating Read-Only Replica from Multi-AZ DB Cluster (7:33)
- Promoting Replica to Writer & Deleting Multi-AZ DB Cluster (6:54)
- Section Summary (2:28)
- Section Introduction (1:48)
- What is RPO & RTO (5:19)
- RDS Automated Backups (10:00)
- How to Perform Point-in-time Recovery (8:43)
- Cross-Region Replication (10:09)
- Taking Manual DB Snapshot (4:02)
- Restoring DB Snapshot (4:55)
- Copying DB Snapshot (3:48)
- Sharing DB Snapshot (11:37)
- Migrating DB Snapshot (5:23)
- Upgrading DB Snapshot (4:49)
- Exporting DB Snapshot to S3 (5:02)
- Deleting DB Snapshot (4:13)
- Introduction to AWS Backup Service (7:07)
- Taking On-Demand AWS Backup (4:35)
- Navigating AWS Backup Interface (5:00)
- Creating AWS Backup Plan (6:25)
- Dashboard, Vaults, Jobs, Restore Points ARNs (4:23)
- Deleting AWS Backup Plans (4:01)
- Section Summary (1:06)
- Section Introduction (4:01)
- Binary Log Disk Usage (9:22)
- CPU Utilization (4:04)
- Database Connection Monitoring (4:18)
- DB Load Monitoring (3:30)
- Disk Queue Depth Monitoring (7:20)
- LVM Monitoring (3:18)
- Configuring the Slow Queries Log (9:21)
- DB Instance Types (7:24)
- Temp Table Size Optimization (5:49)
- Time Zone Settings (4:14)
- Sync Bin Log Parameter (8:05)
- Tuning Max Connections Parameter (5:39)
- Slave Parallel Workers (6:59)
- Performance Insight & Enhanced Monitoring (11:07)
- Section Summary (2:39)
- Section Introduction (2:27)
- Built-in RDS Admin User - rdsadmin (6:30)
- RDS Admin User - admin (5:28)
- Introduction to Blue Green Deployment (3:44)
- Blue Green Deployment for Standalone RDS Instance (7:07)
- Blue Green Deployment for Multi-AZ DB Instance (5:53)
- Blue Green Deployment - Replication Issues (3:20)
- Blue Green Deployment - Fixing Replication Issues (3:17)
- Blue Green Deployment - Testing (6:04)
- Blue Green Deployment - Switching (4:37)
- Section Summary (1:57)
Featured Courses
Showcase other available courses, bundles, and coaching products you’re selling with the Featured Products block to provide alternatives to visitors who may not be interested in this specific product.
