Skip to page content Skip to section menu Skip to site-wide navigation About Us | Consultancy | Training | Software | Publications | Open Source | Support | Open Standards | FAQ | Jobs
Site Style Info

MySQL Database Administration — A 5-Day Course

Course Synopsis

This course is suitable for delegates intending to sit the 'Certified MySQL DBA I' and 'Certified MySQL DBA 2' examinations.

Course Objectives

This course is designed to give administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of MySQL databases and services. Administrators will gain practical experience in setting up, administering and troubleshooting MySQL databases. They will gain an understanding of the architecture of a MySQL database. They will be able to ensure the integrity and availability of a company's data within the MySQL environment.

Suitable For

Course Prerequisities

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

Publicly scheduled dates, locations, and prices

London — £1495 (+VAT)

  • 3–7 Aug 2009
  • 21–25 Sep 2009
  • 26–30 Oct 2009
  • 7–11 Dec 2009

Manchester — £1495 (+VAT)

  • 13–17 Jul 2009
  • 7–11 Sep 2009
  • 16–20 Nov 2009

Contents

MySQL Architecture

Starting, Stopping and Configuring MySQL

Security-Related Configuration

Database Creation

Client Programs for DBA Work

Character Set Support

Locking

Storage Engines

Table Maintenance

The Information_Schema Database

Backup and Recovery

Stored Procedures

User Management

Securing the Server

Upgrade-Related Security Issues

Optimizing Queries

Optimizing Schemas

Optimizing the Server

Interpreting Error Messages

Optimizing the Environment

Scaling MySQL