Skip to content
UdemyMySQLPaid courseExpert levelCertificate

Becoming a Production MySQL DBA (Udemy.com)

An awesome journey towards world's most popular open source database to become a Production MySQL DBA.

Created by: Abid Malik

Last updated October 2025

icon
What you will learn

  • You will learn how to install latest version of MySQL Server including MariaDB and Percona Server for MySQL.
  • You will learn how to secure the installation of MySQL and how to start/stop/restart MySQL service using systemd.
  • You will learn how to customize MySQL server configuration, how to store InnoDB log files, binary log files, MySQL server log files in separate locations.
  • You will learn how to connect to MySQL locally as well as remotely and how to perform database administration.
  • You will learn how to perform minor and major MySQL upgrades, how to install new components and remove plugins.
  • You will learn how to setup GTID-based master-slave replication, and how to setup filtered replication.
  • You will learn how to take logical as well as physical backup, how to restore MySQL backups, how to setup a new slave from backup.
  • You will learn how to troubleshoot MySQL server issues.

How it compares

Against the other 43 rated Udemy courses in MySQL on CourseDuck:

  • Rating4.5 out of 5higher than 62% of them
  • Reviews1,076#19 of 44 by number of reviews
  • Length20.1 hourslonger than 88% of them
  • Last updatedOctober 2025more recently than 81% of them

icon
Course Description

**Disclaimer**

For the section Running MySQL on Docker, This course requires you to download Docker Desktop If you are a Udemy Business user, please check with your employer before downloading software.


**Course Overview **

Welcome to this amazing course on MySQL Server Administration. You will learn all aspects of MySQL Server including setting it up, managing it, troubleshooting it. You will learn how to upgrade MySQL, how to setup replication, how to migrate to AWS cloud, and much more!


** Course Contents **

  1. MySQL Server Introduction

    1. Why MySQL?

    2. Meet Bob, The future DBA

    3. MySQL Websites

  2. MySQL Server Installation

    1. Installing MySQL Server Community Edition

    2. Installing MariaDB Database Server

    3. Installing Percona MySQL Server

    4. installing Specific MySQL Version

    5. Removing MySQL


  3. Exploring MySQL Server

    1. MySQL Architecture

    2. MySQL Installed File Locations

    3. MySQL Executable Programs

    4. MySQL Shell Commands

    5. MySQL Socket File

    6. MySQL Global & Session Variables

    7. MySQL Remove vs Local Connections

  4. MySQL User Administration

    1. MySQL Accounts

    2. Creating DBA Account WITH GRANT OPTION

    3. MySQL Roles

    4. Granting Permissions to Roles

    5. Granting Roles to Users

  5. MySQL Database Administration

    1. Storing Auth Credentials using mysql_config_editor

    2. MySQL Administrative Programs

    3. mysqlimport, mysqlshow, mysqlcheck utilities

    4. Loading Time Zone Data

    5. Downloading Example Databases

  6. MySQL Server Configuration

    1. MySQL Default Option Files

    2. Adding Option Files

    3. Option File Inclusions

    4. MySQL Error Log

    5. MySQL Binary Log Files

    6. Relocating InnoDB System Tablespaces

    7. Moving Redo Log Files

  7. Upgrading MySQL Server

    1. Performing MySQL Minor Version Upgrade

    2. Performing MySQL Major Version Upgrade

    3. Running Pre-Upgrade Checks

    4. Version Comparison Between Primary & Replica

  8. MySQL Replication

    1. Performing Traditional Position-Based Relication

    2. Performing GTID Replication

    3. Ignoring Databases for Replication

    4. Excluding Tables from Replication

  9. MySQL Storage Engines

    1. BLACKHOLE 

    2. MEMORY

    3. INNODB

    4. CSV

  10. MySQL InnoDB Storage Engine Configuration

    1. InnoDB Architecture

    2. Memory-Based Architecture

    3. InnoDB Buffer Pool

    4. Dedicated Server

    5. Doublewrite Buffer

    6. System Tablespaces

  11. MySQL Backup & Restore

    1. Performing Hot Backup

    2. Performing Cold Backup

    3. Performing Logical Backups

    4. Restoring from Hot/Cold Backups

  12. Running MySQL on Docker

    1. Installing Docker Engine

    2. Pulling MySQL Image

    3. Running MySQL Container

  13. DBA Tips & Tricks Club

    1. Customizing MySQL Prompt

  14. MySQL Database Objects

    1. Views

    2. Stored Procedures

    3. Functions

    4. Triggers

    5. Events


** January 2023 - Course Update **

SECTION: Running MySQL on Docker

Lessons Added:

  1. Converting MySQL Instance to Container

  2. Installing MySQL Server on Docker Host

  3. Demo - Attach Container to Instance



** Feburary 2023 - Course Update **

NEW SECTION: Cloud Database Administration

Lessons Added:

  1. Cloud Database Lab Setup

  2. Creating Droplets on DigitalOcean

  3. Disabling SELINUX

  4. GTID Based Replication Setup

  5. Online Data Duplication using xbstream

  6. Setting up AWS Cloud Replica


NEW SECTION: Database Scripting

Lessons Added:

  1. Introduction to Shell Scripting

  2. Shell Script Permissions

  3. Bash Shell Shebang

  4. Mixing Text with Shell Commands

  5. Shell Script Arguments

  6. Shell Variables

  7. Output of Command as Variable

  8. For Loop in Shell Scripting

  9. Assignment: Create Shell Sript to Create MySQL Accounts

  10. Assignment: Create Shell Script to Download Example Database

  11. Assignment: Create Shell Script to Create tables in specific databases

  12. Introduction to Percona Toolkit

  13. Installing Percona Toolkit

  14. pt-mysql-summary

  15. pt-summary


NEW SECTION: MySQL Database Objects

Lesson Added:

1. Section Introduction


COURSE UPDATES:

* DBA interview questions are added for section 2

* DBA interview questions are added for section 3


We will be adding more content to this course soon...

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Abid Malik

I'm Abid Malik, a Senior Database Administrator with over 15 years of experience in database administration, infrastructure solutions, cloud migrations, and providing 24X7 production support.

I have worked in some of the top companies in the United States like Verizon, ChannelAdvisor, Cengage Learning. I am passionate about learning new technology and teaching.

I have extensive experience in MySQL, MongoDB and supporting them on AWS Cloud.

icon
More MySQL courses

$13.99

$11.99

$54.99

$79.99

$199.99

$11.99

icon
Reviews

4.5

1,076 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Lakshmi Narasimhan Yellavarjula on 2/14/2026

The presenter took so much care to engage,cover the topics in interesting yet practical way to make the audiance/students appreciate the depth of mysql in a simple yet effective practical scenarios/examples. I loved the course and look forward to more learnings. one of the best presentors, i have really learned the subjects with no pressure/confusion/gaps. Thank you very much for the course.

By Coskun Demiral on 12/29/2025

This is a very good learning course as it shows all the details of MySQL as a complete RDMS. I have taken another 28 hours of course but that was nothing like this one. It only focused on basic DBA knowledge and development side rather than what an actual MySQL DBA does. I have one suggestion/request, please keep this course alive so that we can go back to it as we need to review again parts of it. If you come up with a newer version of this course, please keep it with the same learning subjects and materials as they are most useful. Big thanks to everyone who made this course available especially the instructor Abid Malik. Regards.

By Vivek Singh on 12/28/2025

One of the best courses I took in udemy. It really gave my good amount of knowledge when it comes to MySQL. Our team works with a lot of clients whose infra is running on MySQL both on EC2 and RDS, having knowledge of MySQL Administration was absolutely necessary for, and this course really came as a savior. I can now say that I enough of MySQL that I can do my work confidently. Kudos to Abid for creating such a great course. I will keep coming back to this whenever I am confused with some concepts or just really want to revise stuff.

By Stone Zhang on 9/21/2025

only listt parts of lession has resources can download

By Rohan Suresh Mahadik on 4/29/2025

A very comprehensive course that covers most key areas. I appreciate that the instructor doesn't hide mistakes but corrects them live during the class—it makes the learning experience more authentic and relatable. It's clear how much effort has been put into the course. I would love to learn more about Point-in-Time Recovery, best practises for tablespace management and performance tuning, explaining with examples and resolutions. Also if you could explain how to raise a case with support.

By Aamir on 4/19/2025

This course didn’t just teach me MySQL it empowered me with the confidence, hands-on experience, and real-world knowledge needed to step confidently into a MySQL DBA role at an MNC. I'm incredibly grateful to Abid Malik for designing such a comprehensive, practical, and career-focused learning journey. His course bridges the gap between theory and the real demands of the industry. Highly recommended to anyone who’s serious about becoming a successful MySQL DBA.

By Alex Iving on 3/12/2025

The major concepts of MySQL aren't covered clearly. What is the purpose of Change Buffer, why the data from Change Buffer is written to the system tablespace, what is stored in the latest version of MySql in system tablespace, what is the difference between variables and options and why we need both? For backup of VLDB do we need to archive redolog files ?Also, the first part of the course is very slow. The sections related to installation, docker, migration to cloud, upgrade , backup/recovery and replication are actually very good. I would recommend to improve Innodb section. Possibly, add the example how the transaction is executed in MySQL in details in respect to all memory structures and files.

By Craig Greenwood on 10/2/2024

Its fine. I need to learn this stuff. I am using el9 and he's using el7 so there have been some hurdles I've had to overcome but I'm getting through it. Mostly struggling with the speed. The course is taking a LONG time for me because I need to listen to what he says, then pause so that I can emulate his work, then unpause, sometimes rewind and rewatch if I want to absorb some things. I just need more time and experience with mysql but I wish the presenter would just slow down and give us a second to breath and confirm and verify things. He'll switch from the mysql prompt back to the linux prompt and not say anything about it sometimes which causes a pause and rewind and relisten.

By Ashutosh Kumar Singh on 3/20/2024

MySQL Database Administrator (DBA) course offers a comprehensive and valuable learning experience for individuals looking to pursue a career in database administration. With its thorough coverage of essential topics, experienced instructors, hands-on approach, and robust support system, it equips students with the skills and knowledge needed to excel in managing MySQL databases effectively. I highly recommend this course to anyone interested in mastering MySQL database administration.

By Tejas Thakur on 1/23/2023

Really great course and touch a lot of BAU topics which makes you complete DBA. I would say I was looking for the course from 2020 and finally landed on this which fulfilled all my expectations. This course is excellent! Like the way the course is designed that takes you on a good journey. at the same time, Abid made sure that the length of the video is enough to keep interested and not make you bore. that something special aspect. Tejas

Showing all 10 reviews on CourseDuck

Read all 1,076 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100