MySQL Release 5.0+ Database Administrator

Course:  MYSQLA
Duration:  4 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 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.

This course combines the content of our MySQL Administrator Part 1 and Part 2 courses.

« 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

Using Stored Routines

  • Security Uses
  • Performance Enhancement

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

Upgrading

  • 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

Diagnostics

  • 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.

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
MYSQLA1
MySQL Release 5.0+ Database Administrator, Part 1
2 Days
I
Details
MYSQLA2
MySQL Release 5.0+: Database Administrator, Part 2
2 Days
II
Details
MYSHA
MySQL Release 5.0+: High Availability
3 Days
II
Details
MYSSTOR
MySQL Release 5.0+: Stored Routines
2 Days
II
Details
MYSCLUS
MySQL Release 5.0+: MySQL Cluster
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 [email protected]