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]