MySQL Administration Training in Bloomington

Enroll in or hire us to teach our MySQL Administration class in Bloomington, Illinois by calling us @303.377.6176. Like all HSG classes, MySQL Administration may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, MySQL Administration may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.

Course Description

 
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 RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class walks the admin through the basics of MySQL administration. Included are an introduction to the available My SQL client software and its use in performing administrative functions, optimization tasks, and general performance tuning. This course covers MySQL 5.5
Course Length: 2 Days
Course Tuition: $790 (US)

Prerequisites

Prior experience installing software and programming in any language, such as HTML, is recommended but not required.

Course Outline

 

1. Course Introduction
Course Objectives
Course Overview
Using the Workbook
Suggested References

2. Introduction to Database Concepts and MySQL
Features of a Relational Database
Where does SQL Fit in?
Database Access
Why MySQL?
The History of MySQL

3. Installation, Configuration, and 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

4. MySQL Client Software and 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

5. 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 and FEDERATED
MERGE and ARCHIVE

6. Utilities
Client Overview
Specifying Options for Command-Line Clients
Client Option Files
Checking Tables with myisamchk and mysqlchk
Using myisamchk and mysqlchk for Repairs
mysqlshow and mysqlimport
Using mysqldump
The MySQL Workbench-General
MySQL Workbench-Execution
MySQL Administration via theWorkbench
Data Modeling with the Workbench
SQL Development
Third Party Tools

7. Administering a Database and Users
The Server-Side Programs
Starting the MySQL Server
Using SET for Server Options
Table Management
Server Log Files
mysqladmin
Backup and Restore
Miscellaneous Functions
User Account Management
Understanding User Privileges
User Account Rights Management
User Account Privileges
Managing Access to the Database
Environment

8. Optimization and Performance
Tuning
Hardware Limitations
Optimizing the MySQL Server’s
Interaction with the ExternalWorld
Adjusting the MySQL Server
Configuration
Optimizing Your Database
Optimizations Specific to MyISAM
Optimizations Specific to InnoDB

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.