0845 450 6120

MySQL Database Administration for Experienced Database Administrators

Anyone with substantial experience of an alternative relational database management system who now needs to administer, monitor and support MySQL databases and servers.

Learning Objectives

To provide the skills necessary to administer, monitor and support MySQL databases and servers.

Delegates will practise:
• Using Client Programs for MySQL DBA Work
• Obtaining Metadata
• Configuring the Server
• Server Installation, Administration and Upgrading
• Setting up Character Set Support
• Configuring Log Files
• Interpreting Error Messages
• Creating, Altering and Dropping Databases and Tables
• Locking and Transactions
• Using Storage Engines, including the MyISAM and InnoDB engines
• Table Maintenance
• Backup and Recovery, including Exporting (mysqldump) and Importing (mysqlimport)
• Administering Users and Privileges
• Using Stored Procedures and Triggers for Database Administration Tasks
• Securing the Server
• Tuning Queries
• Tuning Tables and Indexes
• Tuning the Server
• Using the Event Scheduler
• Creating Partitioned Tables
• Replication
• Using MySQL Workbench

Pre-Requisites

Substantial experience of a relational database management system such as Oracle or Microsoft SQL Server is required.

This course is NOT suitable for delegates who only have experience with Microsoft Access.

Course Content

This MySQL Database Administration for Experienced Database Administrators course is designed for Database Administrators who already have substantial experience in the administration of another relational database management system such as Oracle or Microsoft SQL Server.

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

Exams & Certification

The MySQL Database Administration for Experienced Database Administrators 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).

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.

One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include