Courses by Category
Click on a category below to see a listing of courses.

This course is available for customized on-site delivery for groups of 3 or more students.
Contact us today at 877-258-8987 for more information or a quote.

Scroll down the page for a list of upcoming course dates in our public calendar.

MySQL Administration (5 days)

Designed for MySQL administrators, this MySQL course covers advanced topics that are of particular importance to database administration.

These topics, such as backup, recovery, and clustering, ensure administrators have the skills and knowledge needed to effectively deploy and administer large-scale MySQL implementations.

This MySQL course is a combination of hands-on exercises and lecture.

MySQL Administration Course Calendar (5 days)


Call for upcoming dates or on-site delivery.
¹ Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services. ² Include course and course materials only. ³ Requires a broadband internet connection and microphone. Note that Virtual LIVE courses are led by an instructor, and as such start and end in local time (based on the course location), this my differ from your time zone. For government and education pricing, please contact us.

Recommended Pre-requisites

Students attending this course (which maps to the MySQL Professional certification) should have some experience using SQL database servers. An understanding of Structured Query Language is fundamental in order to this course.

Course Outline/Agenda

Below is a brief course outline, for a more detailed view of course contents, please view the Table of Contents from our Course Guide (link below)

Introduction
MySQL Architecture
Installing & configuring MySQL
- MySQL Installation for Windows
- MySQL Installation for Linux/Unix
- Compiling MySQL Server
- Upgrading MySQL Servers
- OS & Hardware Optimization
Understanding & using MySQL client software
Understanding MySQL Storage
- Choosing a storage engine
Managing MySQL Configuration
MySQL Server Security
- MySQL security-related configuration
- Understanding the MySQL privilege system
- Managing users in MySQL
- Installing & using OpenSSL
Optimizing Queries
- Using Explain to analyze queries
- Optimizing Indexes
- Optimizing updates
Understanding and using FULLTEXT indexes
Understanding MyISAM Tables
- MyISAM storage engine features
- MyISAM table locking mechanisms
- MyISAM table relocation
- Backup up & restoring MyISAM tables
Understanding & managing InnoDB Tables
- Managing InnoDB tablespaces
- Configuring InnoDB buffers and logs
- Utilizing multiple InnoDB tablespace
- Using Raw devices for InnoDB tablespaces
- Determining InnoDB engine status
- InnoDB table restrictions
Table Backup & Maintenance
- Using myisamcheck and mysqlcheck to perform table maintenance.
- Using mysqldump to perform server backups
- Performing MyISAM file-level backups
- Performing InooDB tablespace backups
- Using & managing MySQL binary logs
- Other backup methods
Using Advanced MySQL Server Features
- Measuring & managing server load
- Understanding the MySQL query cache
- Performance tuning the MyISAM engine
- Performance tuning the InnoDB engine
- Configuring MySQL replication
  - Multiple servers and replication
  - Configuring MySQL 4.x replication
  - Configuring MySQL 5.x replication
  - Circular replication
  - Querying replication status

Class Size

This class is limited to a maximum of 12 students.

On-Site Delivery

This course is available for on-site delivery for groups of 3 or more students.

OTG offers discounted training for on-site courses of more than 3 students - call us at 877-258-8987 (or submit the form on the upper right side of this page) for more information.

Course Details

Developed and delivered by our SME's, this course provides a depth and breadth of coverage unmatched in the industry. It is a definite requisite to those looking to add MySQL administration to their skill set. The course is a combination of lecture and hands-on, with each student having his/her own workstation.

This course is delivered with our exclusive MySQL course guide, as well as the MySQL Administrators Guide (a reference document).

Instructional Materials

The following materials are used to deliver this course:

MySQL Administrators Guide (MySQL Press)
OTG MySQL Administration Course Guide

View course guide table of contents
Requires Adobe Acrobat Reader

Enroll in this course

View upcoming course calendar

info@otg-nc.com
877-258-8987