MySQL Database Administration — A 5 day course

contact usEnquire about this course

Synopsis

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.

Objectives

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

Prerequisites

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

Examination

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

Select a date to enquire about availability of places. For dates after 28 January 2017, please call 0333 210 0140 or use our contact form to enquire about places and availability.

London — £1495 (+VAT)


Contents

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

Privileges

User variables and Prepared Statements

Stored Routines for Administration

Triggers

Security

Tuning Queries

Tuning and Indexes 1

Tuning and Indexes 2

Tuning and Tables

Tuning the Server

The Event Scheduler

Partitioned Tables

Replication

MySQL Workbench