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

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.

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
MYSQLD	MySQL Release 5.0+ Developer	4 Days	I	Details
MYSQLA1	MySQL Release 5.0+ Database Administrator, Part 1	2 Days	I	Details
MYSQLA	MySQL Release 5.0+ Database Administrator	4 Days	I	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]

Privacy Notice