Choose your language:

Hong Kong
New Zealand
United Kingdom
United States

MySQL for Database Administrators

Course Code



3 Days

Completion of the MySQL for Beginners course or some experience with Relational Databases and SQL is required.
This course provides the foundation for database administrators and developers who want to use this powerful database. In this course you will learn how to secure users privileges, set resource limitations, and access controls. In addition, you will learn multiple new features such as creating and using Stored Procedures, Triggers and Views.
This course is designed for individuals who are Database Administrators

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

  • Install and Upgrade MySQL for the most common operating systems
  • Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server
  • Use the INFORMATION_SCHEMA database to access metadata
  • Perform the MySQL start and shutdown operations
  • Configure MySQL server options at runtime
  • Evaluate data types and character sets for performance issues
  • Describe data locking concepts and the different levels of locking in MySQL
  • Differentiate between the multiple storage engines available in MySQL
  • Perform backup and restore operations utilizing multiple MySQL tools
  • Maintain integrity of a MySQL installation utilizing security protocols
  • Use stored routines and triggers for administration tasks
  • Manage, apply and understand the reason for using views
  • Improve performance through query optimization
  • Optimize Schemas (Databases) utilizing multiple techniques
  • Utilize MySQL monitoring tools to improve server performance
  • Compare multiple environment options to improve server performance

MySQL Overview, Products, Services
MySQL Enterprise Services
Supported Operating Services
MySQL Website
Installing MySQL
Installing the 'world' Database

MySQL Architecture
Client/Server Architecture
MySQL Architecture Overview
How MySQL Uses Disk Space
How MySQL Uses Memory
The MySQL Plug-In Interface

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

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

Overview of Data Types
Data Types
Numeric Data Types
Character String Data Types
Binary String Data Types
Temporal Data Types
Column Attributes

Metadata Access Methods
The mysqlshow Command

Storage Engines
Storage Engine Overview
MyISAM, InnoDB, and MEMORY Storage Engines
Other Storage Engines
Choosing Appropriate Storage Engines
Using Multiple Storage Engines
Storage Engine Comparisons

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

Transactions and Locking
Transaction Control statements
Isolation Levels

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

Table Maintenance
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

Programming with MySQL
Defining, Executing and Examining Stored Routines
Stored Routines and Execution Security
Defining, Creating, and Deleting Triggers
Trigger Restrictions and Privileges
Defining Events
Schedule Events
DBA's Use of MySQL Programming
Backup Stored Routines

What is a view?
Creating Views
Updatable Views
Managing Views

Backup and Recovery
Planning for Recovery Backup
Backup Tools Overview
Making Raw Backups
Making Logical (Text) Backups
Backup Log and Status Files
Replication as an Aid to Backup
Backup Method Comparison
Data Recovery

Introduction to Performance Tuning
Using EXPLAIN to Analyze Queries
General Table Optimizations
Setting and Interpreting MySQL Server Variables

Introduction to High Availability
MySQL Replication

Send Us a Message
Choose one