BBuddyAI Learn
Databases · Beginner → Expert

🐬 MySQL Developer and DBA Masterclass

Learn SQL, relational modeling, MySQL administration, indexing, transactions, security, backup, replication, optimization, and production troubleshooting.

Sign in to enroll

Course roadmap

Pass each module exam to unlock the next module.

Module 1 · Beginner

Relational Databases and MySQL Setup

Locked
Module 2 · Beginner

MySQL Architecture, Editions, Installation and Server Components

Locked
Module 3 · Beginner

SQL SELECT, Filtering, Sorting and Expressions

Locked
Module 4 · Beginner

MySQL Clients, Connections, Configuration Files and Server Variables

Locked
Module 5 · Beginner

Joins, Aggregation, Subqueries and Set Logic

Locked
Module 6 · Beginner

Databases, Tables, Data Types, Character Sets and Collations

Locked
Module 7 · Beginner

Schema Design, Keys, Constraints and Normalization

Locked
Module 8 · Beginner

DDL: CREATE, ALTER, DROP, Metadata and Information Schema

Locked
Module 9 · Intermediate

Data Changes, Transactions and Concurrency

Locked
Module 10 · Beginner

SELECT Fundamentals, Expressions, NULL and Three-Valued Logic

Locked
Module 11 · Intermediate

Views, Stored Programs, Triggers and Events

Locked
Module 12 · Beginner

Filtering, Sorting, LIMIT, CASE and Built-In Functions

Locked
Module 13 · Intermediate

Indexes, EXPLAIN and Query Optimization

Locked
Module 14 · Beginner

Joins, Join Cardinality, Self Joins and Multi-Table Query Design

Locked
Module 15 · Advanced

Users, Roles, Privileges and Database Security

Locked
Module 16 · Beginner

Aggregation, GROUP BY, HAVING and Analytical Reporting

Locked
Module 17 · Advanced

Backups, Restore, Import and Export

Locked
Module 18 · Beginner

Subqueries, Common Table Expressions and Window Functions

Locked
Module 19 · Advanced

Server Configuration, Monitoring and Logs

Locked
Module 20 · Intermediate

INSERT, UPDATE, DELETE, Upserts and Safe Data Modification

Locked
Module 21 · Advanced

Replication, High Availability and Recovery Concepts

Locked
Module 22 · Intermediate

Primary Keys, Foreign Keys, UNIQUE, CHECK and Referential Integrity

Locked
Module 23 · Expert

Advanced SQL Patterns and Reporting

Locked
Module 24 · Intermediate

Normalization, Denormalization and Relational Schema Design

Locked
Module 25 · Expert

Production Troubleshooting and Performance Tuning

Locked
Module 26 · Intermediate

InnoDB Architecture, Pages, Buffer Pool, Redo and Undo Concepts

Locked
Module 27 · Expert

Expert Capstone: Design and Operate a Production Database

Locked
Module 28 · Intermediate

Transactions, ACID, Autocommit and Transaction Boundaries

Locked
Module 29 · Intermediate

Isolation Levels, MVCC, Locks, Deadlocks and Concurrency Control

Locked
Module 30 · Intermediate

Views, Derived Tables and Reusable Query Abstractions

Locked
Module 31 · Intermediate

Stored Procedures, Functions, Variables and Control Flow

Locked
Module 32 · Intermediate

Triggers, Events and Database-Side Automation

Locked
Module 33 · Advanced

B-Tree Indexes, Composite Indexes, Covering Indexes and Selectivity

Locked
Module 34 · Advanced

EXPLAIN, EXPLAIN ANALYZE, Optimizer Plans and Query Cost Reasoning

Locked
Module 35 · Advanced

Query Optimization, Sargability, Join Strategy and Anti-Patterns

Locked
Module 36 · Advanced

Users, Roles, Privileges, Account Policies and Least Privilege

Locked
Module 37 · Advanced

TLS Connections, Secrets, Auditing and Database Security Hardening

Locked
Module 38 · Advanced

Logical Backup, mysqldump, mysqlpump Concepts and Restore Verification

Locked
Module 39 · Advanced

Physical Backup, Snapshots, Binary Logs and Point-in-Time Recovery

Locked
Module 40 · Advanced

Import, Export, CSV, Bulk Loading and Data Migration

Locked
Module 41 · Advanced

Binary Logging, Replication Fundamentals and Replica Operations

Locked
Module 42 · Advanced

High Availability, Group Replication and Failover Concepts

Locked
Module 43 · Expert

Partitioning, Large Tables, Archiving and Data Lifecycle Management

Locked
Module 44 · Expert

JSON Data, Generated Columns, Full-Text Search and Specialized Features

Locked
Module 45 · Expert

Performance Schema, sys Schema, Metrics, Slow Log and Monitoring

Locked
Module 46 · Expert

Memory, Buffer Pool, Connections, Temp Tables and Server Tuning

Locked
Module 47 · Expert

Lock, Deadlock, Replication and Performance Troubleshooting

Locked
Module 48 · Expert

Upgrades, Compatibility, Schema Change and Migration Planning

Locked
Module 49 · Expert

Automation, Maintenance, Capacity Planning and Production Runbooks

Locked
Module 50 · Expert

Expert Capstone: Design, Secure, Tune, Back Up and Operate a Production MySQL Platform

Locked
Certification gate

Final course exam

Pass mark: 80%. Time limit: 360 minutes. All module exams must be passed first.

Locked until modules are passed