MySQL DBA

Learn to operate self-managed MySQL with InnoDB: architecture, configuration, users and roles, query plans, buffer pool and redo maintenance, backups and point-in-time recovery, GTID replication, read replicas, high availability, and incident routines. Follow the ideas in small steps: first understand the concept, then practice it in the browser, and finally connect it to a realistic coding problem. Each lesson builds on the previous one so the track becomes a skill you can explain and use, not just a list of terms.

180 interactive lessons across 6 units · 36+ hours · advanced level

What you will learn

Build practical skills in MySQL, InnoDB, Database Administration, Operations, Backups, Replication, High Availability through browser-based coding exercises, guided feedback, unit quizzes, a debugging challenge, and a final project.

Course access

Unit 1, including its first 30 lessons and unit quiz, is free. The remaining 5 units require a CodeLearning365 Pro subscription.

View Pro access options

MySQL DBA curriculum

The curriculum progresses from foundations to applied practice and mastery. Representative topics from every unit are listed below.

Unit 1: Foundations

30 lessons covering topics such as InnoDB Architecture and Memory, Server Initialization and Data Directory, my.cnf Layers and Persisted Settings, MySQL Accounts, Hosts, and Authentication, Privileges and Role-Based Access.

InnoDB Architecture and Memory
Server Initialization and Data Directory
my.cnf Layers and Persisted Settings
MySQL Accounts, Hosts, and Authentication
Privileges and Role-Based Access

Unit 2: Core Concepts

30 lessons covering topics such as MySQL DBA Incident Capstone, Power Up 032: InnoDB Architecture and Memory, Power Up 033: Server Initialization and Data Directory, Power Up 034: my.cnf Layers and Persisted Settings, Power Up 035: MySQL Accounts, Hosts, and Authentication.

MySQL DBA Incident Capstone
Power Up 032: InnoDB Architecture and Memory
Power Up 033: Server Initialization and Data Directory
Power Up 034: my.cnf Layers and Persisted Settings
Power Up 035: MySQL Accounts, Hosts, and Authentication

Unit 3: Building Skills

30 lessons covering topics such as Power Up 061: Configuration Change and Restart Planning, Power Up 062: MySQL DBA Incident Capstone, Power Up 063: InnoDB Architecture and Memory, Power Up 064: Server Initialization and Data Directory, Power Up 065: my.cnf Layers and Persisted Settings.

Power Up 061: Configuration Change and Restart Planning
Power Up 062: MySQL DBA Incident Capstone
Power Up 063: InnoDB Architecture and Memory
Power Up 064: Server Initialization and Data Directory
Power Up 065: my.cnf Layers and Persisted Settings

Unit 4: Applied Practice

30 lessons covering topics such as Power Up 091: Minor Patching and Major Version Upgrades, Power Up 092: Configuration Change and Restart Planning, Power Up 093: MySQL DBA Incident Capstone, Power Up 094: InnoDB Architecture and Memory, Power Up 095: Server Initialization and Data Directory.

Power Up 091: Minor Patching and Major Version Upgrades
Power Up 092: Configuration Change and Restart Planning
Power Up 093: MySQL DBA Incident Capstone
Power Up 094: InnoDB Architecture and Memory
Power Up 095: Server Initialization and Data Directory

Unit 5: Projects

30 lessons covering topics such as Power Up 121: Routine Integrity and Table Maintenance, Power Up 122: Minor Patching and Major Version Upgrades, Power Up 123: Configuration Change and Restart Planning, Power Up 124: MySQL DBA Incident Capstone, Power Up 125: InnoDB Architecture and Memory.

Power Up 121: Routine Integrity and Table Maintenance
Power Up 122: Minor Patching and Major Version Upgrades
Power Up 123: Configuration Change and Restart Planning
Power Up 124: MySQL DBA Incident Capstone
Power Up 125: InnoDB Architecture and Memory

Unit 6: Mastery

30 lessons covering topics such as Power Up 151: Partitioning and Retention Operations, Power Up 152: Routine Integrity and Table Maintenance, Power Up 153: Minor Patching and Major Version Upgrades, Power Up 154: Configuration Change and Restart Planning, Power Up 155: MySQL DBA Incident Capstone.

Power Up 151: Partitioning and Retention Operations
Power Up 152: Routine Integrity and Table Maintenance
Power Up 153: Minor Patching and Major Version Upgrades
Power Up 154: Configuration Change and Restart Planning
Power Up 155: MySQL DBA Incident Capstone

Continue learning with a related course

PostgreSQL Database Administrator coding course — Learn to operate self-managed PostgreSQL: architecture, configuration, roles, query planning, vacuum, backups and point-in-time recovery, streaming replication, read replicas, high availability, and incident routines. Follow the ideas in small steps: first understand the concept, then practice it in the browser, and finally connect it to a realistic coding problem. Each lesson builds on the previous one so the track becomes a skill you can explain and use, not just a list of terms.
Oracle Database Administrator coding course — Learn to operate self-managed Oracle Database: multitenant architecture, instance memory, Oracle Net, users and roles, ASM and tablespaces, RMAN recovery, Data Guard, read-only standby operations, RAC, patching, performance diagnosis, and daily maintenance. Follow the ideas in small steps: first understand the concept, then practice it in the browser, and finally connect it to a realistic coding problem. Each lesson builds on the previous one so the track becomes a skill you can explain and use, not just a list of terms.
JavaScript Fundamentals coding course — Build a confident JavaScript foundation with variables, functions, collections, and asynchronous code. Follow the ideas in small steps: first understand the concept, then practice it in the browser, and finally connect it to a realistic coding problem. Each lesson builds on the previous one so the track becomes a skill you can explain and use, not just a list of terms.

Compare all coding tracks