MySQL Database Administration — A 5 day course

contact usEnquire about this course


This MySQL Database Administration course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and SQL commands.

The course provides practical experience in setting up and maintaining a MySQL server, including backing up, recovery, configuration and tuning.


To provide the skills necessary to administer, monitor and support MySQL databases and servers. The delegates will practise:

Suitable For

Anyone who needs to administer, monitor and support MySQL databases and servers.

Follow-On Course


A working knowledge of MySQL is required. This can be gained by attendance on the Introduction to MySQL course.


The MySQL Database Administration course will teach the major topics required for the delegate to work towards achieving the Oracle Certified Professional MySQL 5.6 Database Administrator Exam (1Z0-883).

Following attendance on the relevant courses, delegates will need to dedicate time for self study and researching the topics covered on the course. They will also need to gain hands-on experience so they can put into practice what they have learnt on the courses.

Attending courses alone will not guarantee exam success, previous experience, practice, self study and aptitude are also key requirements.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course nor in the course fee.

Book your exam with Pearson VUE Testing Services.

Publicly scheduled dates, locations, and prices

A schedule of dates for this subject is not currently available. Please call 0333 210 0140 or use our contact form to enquire about places and availability.


Clients and Tools

Obtaining Metadata

Configuring the Server

MySQL Server Installation and Configuration

SQL Modes, Log Files and Binary Logging

MySQL Architecture

Tables, Data Types and Character Set Support

Transactions and Locking

Storage Engines

The Innodb Engine

Table Maintenance

Backup and Recovery

User Management


User variables and Prepared Statements

Stored Routines for Administration



Tuning Queries

Tuning and Indexes 1

Tuning and Indexes 2

Tuning and Tables

Tuning the Server

The Event Scheduler

Partitioned Tables


MySQL Workbench