MySQL Database Administration - 5 days Online Classroom

MySQL Database Administration - 5 days Online Classroom

Become a confident MySQL Database Administrator with the practical skills to install, configure, secure, and maintain high-performing MySQL databases. This hands-on course is designed for IT professionals responsible for managing MySQL environments in development, testing, and production.

You'll learn how to administer databases, manage users and permissions, implement backup and recovery strategies, monitor server health, optimize performance, and troubleshoot common issues. The course also covers replication, security, storage engines, and routine maintenance to help ensure database availability, reliability, and scalability.

By the end of the course, you'll be equipped to manage MySQL databases efficiently while applying industry best practices for administration, security, and performance.

Key Features

• Course and material in english
• Beginner - Intermediate level
• 5 days of live instructor-led virtual training (8 hours / day)
• Interactive live labs with real-world tasks
• Course handbook and helpful reference sheets
• Hands-on access to a Linux-based training setup
• Up-to-date MySQL content and tools
• 60+ recommended study hours
• Certificate included

Learning Outcomes

• Transactions & Locking: Learn transaction management, locking mechanisms, and concurrency control to maintain data integrity and optimize performance in multi-user environments.
• Event Scheduling & Automation: Automate routine database tasks using the MySQL Event Scheduler, including maintenance, backups, and scheduled operations.
• Replication & High Availability: Configure and manage MySQL replication, monitor replication health, troubleshoot issues, and implement high-availability strategies.
• Performance Tuning: Optimize MySQL using server configuration, indexing, query tuning, performance monitoring, and logging to improve speed and reliability.

Target Audience

• MySQL database administrators (DBAs)
• Linux and system administrators
• DevOps and infrastructure engineers
• Database support engineers
• IT operations professionals
• Developers responsible for administering MySQL databases

Prerequisites

• Basic knowledge of relational databases
• Familiarity with SQL fundamentals
• Basic Linux or Windows server administration experience
• Understanding of database concepts such as tables, users, and queries is recommended

Course Outline

Day 1: MySQL Administration Fundamentals

• Introduction to MySQL architecture, server, clients, and administration tools
• Install and use MySQL Workbench
• Retrieve database metadata using SHOW, DESCRIBE, and INFORMATION_SCHEMA
• Configure MySQL server settings, variables, and auditing
• Manage SQL modes, logs, and binary logging

Day 2: Storage Engines & Database Maintenance

• Understand MySQL architecture, memory, and storage management
• Configure and optimize the InnoDB storage engine
• Explore MyISAM and other storage engines
• Perform table maintenance, optimization, and repair

Day 3: Backup, Recovery & Security

• Implement backup and recovery strategies with mysqldump and Percona XtraBackup
• Import and export databases using SQL and command-line tools
• Manage users, passwords, roles, and privileges
• Configure access control and resource management

Day 4: Transactions, Performance & Automation

• Manage transactions, locking, concurrency, and deadlocks
• Tune MySQL performance using configuration variables and Performance Schema
• Automate database tasks with the MySQL Event Scheduler

Day 5: Replication & High Availability

• Configure MySQL replication and GTID-based replication
• Monitor replication and troubleshoot replication issues
• Implement failover and high-availability strategies
• Apply advanced performance tuning and production best practices

FAQ

When is the class held?

The majority of the class is a full-day online course from morning to afternoon CET with 8 hours / day straight. However, please contact us to confirm the final detailed schedules.

What is MySQL?

MySQL is a widely used open-source relational database that stores, manages, and retrieves data for web, enterprise, and cloud applications. This course teaches you how to install, configure, administer, and maintain MySQL databases.

Is this course suitable for aspiring database administrators?

Yes. It provides a strong foundation in MySQL administration, equipping you with the practical skills needed to begin a career as a Database Administrator (DBA).

How does the course cover MySQL security?

You'll learn essential security practices, including user and privilege management, password policies, auditing, secure deployment, and access control to protect MySQL environments.

Will I learn backup and recovery?

Yes. The course covers backup and recovery techniques using tools such as mysqldump, mysqlimport, binary logs, and hot backup methods to help you restore databases in production environments.

Does the course include performance troubleshooting?

Yes. You'll learn to diagnose and resolve performance issues using logs, Performance Schema, query analysis, locking management, and server tuning techniques to optimize MySQL performance.

Will I learn backup and recovery?

Yes. The course covers backup strategies, database restoration, replication, and disaster recovery concepts.

Does the course cover database security?

Yes. You'll learn user management, authentication, privileges, access control, and security best practices for MySQL environments.

Is the course practical?

Yes. The training includes hands-on labs that simulate real-world MySQL administration tasks and troubleshooting scenarios.

What skills will I gain?

You'll learn to install, configure, secure, monitor, optimize, back up, recover, and maintain MySQL databases while ensuring high availability, performance, and reliability.