Course Description

This 2-day MySQL Database Administration training course walks the administrator through the basics of MySQL administration. Included are an introduction to the available MySQL client software and its use in performing administrative functions, optimization tasks, and general performance tuning.

MySQL® is the open source community’s most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP – Linux™, Apache™, MySQL®, PHP/Perl/Python®. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDBMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%.

This course is current to MySQL 5.5 but is suitable for users of other versions of MySQL.

Pre-requisites

Prior experience installing and configuring software and programming in any language is recommended but not required.

Who is this course for?

For Database Administrators and System Administrators who are or will be managing a MySQL database environment.

Further Training

Course content

Introduction to Database Concepts & MySQL
Features of a Relational Database
Where does SQL Fit in?
Database Access
Why MySQL?
The History of MySQL
Installation, Configuration, & Upgrading
Installation, Configuration, & Upgrading
MySQL Software
MySQL Software Features
Preparing to Install MySQL
Available Client Software
After the Download
Configuring the Server
Starting the Server
The Initial User Accounts
Verifying Server Operation
Upgrading
Copying a Database between Architectures
Environment Variables
MySQL Client Software & the mysql Command-Line Tool
Running the mysql Client
Customizing the mysql Prompt
mysql Commands
Using the Help Command
Some Useful mysql Options
Working with a Database
Examining Table Definitions
Other SHOW Options
MySQL Storage Engines
Storage Engine Overview
Other Storage Engine Types
The Basics of Commonly Used Storage Engines
MyISAM Limits and Features
InnoDB and Hardware Limitations
InnoDB Shared Tablespace Configuration
InnoDB Per-Table Tablespaces
InnoDB Data Management
MEMORY & FEDERATED
MERGE & ARCHIVE
Utilities
Client Overview
Specifying Options for Command-Line Clients
Client Option Files
Checking Tables with myisamchk & mysqlchk
Using myisamchk & mysqlchk for Repairs
mysqlshow & mysqlimport
Using mysqldump
The MySQL Workbench – General
MySQL Workbench – Execution
MySQL Administration via the Workbench
Data Modelling with the Workbench
SQL Development
Third Party Tools
Administering a Database & Users
The Server-Side Programs
Starting the MySQL Server
Using SET for Server Options
Table Management
Server Log Files
mysqladmin
Backup & Restore
Miscellaneous Functions
User Account Management
Understanding User Privileges
User Account Rights Management
User Account Privileges
Managing Access to the Database Environment
Optimization & Performance Tuning
Hardware Limitations
Optimizing the MySQL Server’s Interaction with the External World
Adjusting the MySQL Server Configuration
Optimizing Your Database
Optimizations Specific to MyISAM
Optimizations Specific to InnoDB