MySQL Release 5.0+ Database Administrator, Part 1

Course:  MYSQLA1
Duration:  2 Days
Level:  I
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 latest version for which an official MySQL Certification Guide is available until May 2012), 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

Architecture

  • The Client / Server Matrix
  • Communications
  • The Two-Tiered Configuration
  • Disk Space Usage
  • Memory Usage

Configuration

  • Binary Distributions
  • Source Distributions
  • Startup Prerequisites
  • Startup Methods
  • Runtime Configuration
  • The General Query Log
  • The Binary Log
  • The Slow Query Log
  • The Error Log
  • Status Files
  • Time Zone Table Loading
  • Security Issues
  • SQL Mode Settings
  • MySQL Upgrades

DBA Client Programs

  • Client Overview
  • The GUI Clients
  • Monitoring The Server
  • Server Configuration
  • Startup Parameters
  • Administering Users
  • Backups
  • Restores

Character Set Support

  • Performance Issues
  • Optimal Datatype Selection

Locking Data

  • Table / Page / Row Locking
  • Explicit Locking
  • Advisory Locking

Storage Engines

  • MyISAM
  • The MERGE Engine
  • The InnoDB Engine
  • ACID Compliance
  • Transactions
  • Isolation Levels
  • Multi-Versioning
  • Concurrency
  • Foreign Keys
  • The MEMORY Engine
  • The FEDERATED Engine
  • Other Available Engines

Data Maintenance

  • Maintenance Operations
  • CHECK / REPAIR TABLE
  • ANALYZE / OPTIMIZE
  • MySQLCheck Utility
  • MyISAMChk Utility
  • MyISAM Auto-Repair

The INFORMATION_SCHEMA

  • Access Syntax
  • The SHOW Command
  • Limitations

Backup & Recovery

  • Text Vs. Binary Backups
  • MyISAM Backups
  • InnoDB Backups
  • Binary Backup Tools
  • Backup Portability
  • SQL Backups
  • MySQLDump Backups
  • GUI Tool Backups
  • Backing Up Support Files
  • Replication And Backup
  • MySQL Cluster
  • MySQLDump Recovery
  • GUI Tool Recovery
  • Binary Log Processing
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.

Training Style

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

« Hide The Details
Related Courses
Code Course Title Duration Level
MYSQLD
MySQL Release 5.0+ Developer
4 Days
I
Details
MYSQLA
MySQL Release 5.0+ Database Administrator
4 Days
I
Details
MYSQLA2
MySQL Release 5.0+: Database Administrator, Part 2
2 Days
II
Details

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 info@verhoef.com