MySQL Release 5.0+: Database Administrator, Part 2

Course:  MYSQLA2
Duration:  2 Days
Level:  II
Course Summary

This course is designed to give you hands-on practice working with a MySQL database. Although the focus is to enable students to meet the standards of MySQL 5.0 Certification.  The enhancements in versions 5.1, 5.5 and 5.6 will also be discussed and the class will be conducted using a MySQL Version 5.5 database.

« Hide The Details
Topics Covered In This Course

Managing Users

  • MySQL User Privileges
  • MySQL Grant Tables
  • Account Management Strategies
  • Account Name Specification
  • Granting / Revoking Privileges
  • Changing Passwords
  • Privilege Activation
  • Setting Resource Limits
  • User Management Privileges
  • Access Control

Installation Security

  • Security Issues
  • Securing The OS
  • Securing The File System
  • Securing Support Files
  • Securing The Network
  • Security For FEDERATED Tables


  • Grant Table Considerations
  • SQL Mode Considerations

Query Optimization

  • Selecting Queries
  • The EXPLAIN Command
  • Query Analysis
  • EXPLAIN Output
  • The SHOW WARNINGS Command
  • MyISAM Index Caching

Database Optimization

  • Optimizing Tables
  • Data Normalization
  • MyISAM Optimizations
  • InnoDB Optimizations
  • MERGE Optimizations
  • MEMORY Optimizations

Server Optimizations

  • MySQLD Interpretation
  • System Variables
  • Status Variables
  • Server Load Measurement
  • Memory Tuning
  • Query Cache Use


  • Sources Of Information
  • Using The Error Log
  • Using the Slow Query Log

Environmental Optimization

  • Choosing Optimal Hardware
  • Disk Configuration
  • Symbolic Links / Symlinking
  • OS Vs. Raw Partitions
  • OS Optimization

Scaling A MySQL Installation

  • Multiple Servers
  • Replication
  • MySQL Cluster
Who Should Take This Course

Application Developers, Database Administrators, Support Staff, Management and anyone seeking an OCA or OCP Certification.

Recommended Prerequisites

Participants should be well familiar with IT terminology and computer use. They should also be familiar with relational database concepts.

It's recommended that participants should have already taken our MySQL Release 5.0+ Database Administrator, Part 1 course.

Training Style

Short lecture sessions (60%) along with hands-on lab sessions (40%).

« Hide The Details
Related Courses
Code Course Title Duration Level
MySQL Release 5.0+ Developer
4 Days
MySQL Release 5.0+ Database Administrator, Part 1
2 Days
MySQL Release 5.0+ Database Administrator
4 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]