Choose your language:

France
Germany
Hong Kong

India
Ireland
Japan
Malaysia
Netherlands
New Zealand

Singapore

Sweden
United Kingdom
United States
Course Code

RT645

Duration

5 Days

Completion of the MySQL for Beginners course or some experience with Relational Databases and SQL is required.
This course provides participants with a 12 hour-per-day immersion into the world of MySQL database administration. The program is an accelerated course that provides those individuals who want to learn how to administer MySQL servers along with the know-how to ensure that their servers perform optimally through performance monitoring and tuning. Participants will learn from a MySQL/Database expert through a combination of lab exercises, lectures, and presentations. This is an intense immersion learning experience for MySQL administration and advanced performance tuning for one week.
This course is designed for individuals who are Database Administrators.

Upon completion of this course, participants will be able to:

  • Perform common DBA tasks
  • Use the INFORMATION_SCHEMA database to access metadata
  • Install and Upgrade
  • Perform start and shutdown
  • Configure server options
  • Utilize partitioning
  • Scale MySQL operations up
  • Develop a tuning strategy
  • Create, Maintain and Manage MySQL tables
  • Write queries
  • Display, decipher and edit server configuration variables to improve performance
  • Backup and restore

Installing MySQL
Installing the 'world' Database

MySQL Architecture
MySQL Architecture Overview
Client/Server Architecture
Storage Engine Concept
Data Directory
Data Storage
Locks

The MySQL Server
Types of MySQL Distributions
Starting and Stopping MySQL on Windows
Starting and Stopping MySQL on Linux
Upgrading MySQL

Configuring the MySQL Server
MySQL Configuration
Dynamic Server Variables
Server SQL Modes
Log and Status Files
Binary Logging

MySQL Clients
Overview of Administrative Clients
Invoking MySQL Client Programs
Using the mysql Client
The mysqladmin Client
MySQL Connectors
Third-Party APIs

MySQL Performance Tools
Overview
Benchmarking Tools
Administration Tools
Specific SHOW commands

Overview of Data Types
Data Types
Numeric Data Types
Character String Data Types
NULLs
Column Attributes

Schema Design
Data Modeling
Normalization
Denormalization
Data Types
Partitioning

Metadata
Metadata Access Methods
The INFORMATION_SCHEMA Database/Schema
Using SHOW and DESCRIBE
The mysqlshow Client

Storage Engines
Storage Engine Overview
MyISAM Storage Engine
InnoDB Storage Engine
MEMORY Storage Engine
Choosing Appropriate Storage Engines
Using Multiple Storage Engines
Storage Engine Comparison Chart

Partitioning
Creating a Partitioned Table
Obtaining Partition Information
Modifying and Removing Partitions
Modification Performance Effects
Pruning
Storage Engine Partition Information
Locking
Limitations

Transactions and Locking
Transactions
Transaction Control statements
Isolation Levels
Locking

Security and User Management
Security Risks
Security Measures
Privileges
Access Levels
User Account Maintenance
Client Access Control
Using Secure Connections

Table Maintenance
Tables
SQL Statements for maintenance operations
Client and Utility Programs for table maintenance
Table Maintenance per Storage Engine

Exporting and Importing Data
Exporting Data
Importing Data
Exporting and Importing Data Using SQL
Import Data with the SQL scripts

Views
What is a view?
Creating Views
Updatable Views
Managing Views

Programming with MySQL
Defining, Executing Stored Routines
Execution Security
Defining, Creating, Deleting Triggers
Trigger Restrictions, Privileges
Schedule Events
DBAs Use of MySQL Programming
Backup Stored Routines

Backup and Recovery
Planning for Recovery Backup
Backup Types
Backup Tools Overview
Making Backups
Backup Log and Status Files
Replication as an Aid to Backup
Backup Method Comparison
Data Recovery

Managing Multiple Servers
Using Multiple Servers
MySQL Replication
MySQL Cluster Replication

Indexing
Indexes
MySQL Index Types
Index Optimizations

Index Optimizations
General SQL Tuning
Caching
General Monitoring
Table Cache and Multi-threading Issues
Row Storage Format
MyISAM Tuning
Transactions
Crash Recovery

Send Us a Message
First Name
*
Last Name
*
Company
*
Email
*
Address Line 1
*
Address Line 2
City
*
*
Zip Code
Telephone
*
*
Choose one
*
Comments