Learn more about the Oracle MySQL Administration training certification course.
The MySQL for Database Administrators training is designed for DBAs and other database professionals. Expert instructors will teach you how to install and configure the MySQL Server, set up replication and security, perform database backups and performance tuning and protect MySQL databases.
5 days full time.
You should be comfortable working on the command line and using command line utilities. The MySQL server will run on Linux but you can use the MySQL client tools from Windows, Linux or Mac OS X.
The is course is primarily offered as a private course. The course can be run onsite or on our site. We have offices in Cape Town and Johannesburg. The course price is R9 500 onsite and R12 599 on our premises. There is no set date to run the course, we schedule the date that suits your team. A minimum of 4 delegates is required to schedule the course.
Download the full course schedule below
MySQL Overview, Products, Services
MySQL Services and Support
Supported Operating Services
MySQL Certification Program Training
Curriculum Paths
MySQL Documentation Resources
Describe the Client/Server Model
Understand the Communication protocols that Clients Use to Connect to the MySQL
Understand How the Server Supports Storage Engines
Describe the Relationship Between the MySQL Storage Engines and its SQL parser and Optimizer
MySQL SQL Layer
MySQL Storage Layer
Describe How MySQL Uses Memory and Disk Space
Describe the MySQL Plugin Interface
Set up MySQL Server Configuration Files
Explain the Purpose of Dynamic Server Variables
Review the Server Status Variables Available
Configure Operational Characteristics of the MySQL Server
Describe the Available Log Files
Explain Binary Logging
Types of MySQL Distributions
Installing MySQL Server
Starting and Stopping MySQL Server
Running Multiple MySQL Servers on a Single Host
Specifying Options for Server Runtime Configuration
Log and Status Files
Loading the Time Zone Tables for Named Time Zone Support
Security-related Configurations Options
Setting the Default sql-mode
Upgrading an Older Installation to a Newer Version of MySQL
MySQL Workbench Graphical Client
The mysql
The mysqladmin Command-line Client
The mysqlimport Command-line Tool
The mysqldump Command-line Tool
The mysqlcheck Command-line Tool
The myisamchk Command-line Tool
The mysqlhotcopy Command-line Tool
The innochecksum — Offline InnoDB File Checksum Utility
The myisam_ftdump — Display Full-Text Index Information
The myisamchk — MyISAM Table-Maintenance Utility
The myisamlog — Display MyISAM Log File Contents
The myisampack — Generate Compressed, Read-Only MyISAM Tables
The mysql_config_editor — MySQL Configuration Utility
The mysqlbinlog — Utility for Processing Binary Log Files
The mysqldumpslow — Summarize Slow Query Log Files
Available APIs and Drivers and Connectors
Requirements for User Authentication
Using SHOW PROCELIST to Show Which Threads are Running
Creating, Modifying and Dropping User Accounts
Alternative Authentication Plugins
Requirements for User Authorizations
Levels of Access Privileges for Users
Types of Privileges
Granting, Modfying, and Revoking User Privileges
Major Categories of Data Types
Meaning of NULL
Column Attributes
Character Set Usage with Data Types
Choosing an Appropriate Data Type
The ACID Properties of Transactions
Transaction Isolation Levels
Locking Concepts
Using Explicit Table Locks
Using Advisory Locks
Available Metadata Access Methods
Using INFORMATION_SCHEMA Compared to Using SHOW Statements
Syntax for Accessing INFORMATION_SCHEMA
Limitation of INFORMATION_SCHEMA
The mysqlshow Client Program
An Overview of Storage Engines in MySQL
InnoDB Storage Engine
InnoDB System and file-per-tablespaces
NoSQL and Memcached API
Configuring Tablespaces Efficiently
Using Foregin Keys to Attain Referential Integrity
InnoDB Locking
Features of Available Storage Engines
MERGE Storage Engine
FEDERATED Storage Engine
MEMORY Storage Engine
MyISAM Storage Engine
Describe the InnoDB Storage Engine
Set the Storage Engine to InnoDB
Illustrate the InnoDB tablespace storage system
Efficiently Configure the Tablespace
Use Foreign Keys to Attain Referential Integrity
Explain InnoDB Locking
Partitions and its Use in MySQL
Reasons for Using Partitioning
Types of Partitioning
Creating Partitioned Tables
Subpartitioning
Obtaining Partition Metadata
Modifying Partitions to Improve Performance
Storage Engine Support of Partitioning
Type of table maintenance operations
SQL statements for table maintenance
Client and utility programs for table maintenance
Repairing InnoDB tables
Maintaining tables for other storage engines
Exporting Data
Importing Data
Creating and Executing Stored Procedures
Describing Stored Routine Execution Security
Creating and Executing Triggers
Creating, Alerting and Dropping Events
Event Execution Scheduling
Types of Backups
Backup Tools and Utilities
Making Binary and Text Backups
The Role of Log and Status Files in Backups
Performing Data Recovery
Using a Replication Slave for Backups
Managing the MySQL Binary Log
MySQL Replication Threads and Files
Setting up a MySQL Replication Environment
Desigining Complex Replication Topologies
Multi-Master and Cluster Replication
Performing a Controlled Switchover
Monitoring and Troubleshooting Replication
Replication with Global Transaction Identifiers(GTIDs)
Using EXPLAIN to Analyze Queries
General Table Optimizations
Monitoring Status Varaibles that Affect Performance
Setting and Interpreting MySQL Server Variables
Overview of PERFORMANCE_SCHEMA
Recognizing Common Security Risks
Security Risks Specific to the MySQL Installation
Security Problems and Counter Measures for Network, Operating Systems, Filsystems and Users
Protecting your Data
using SSL for secure MySQL server connections
How SSH enables a secure remote connection to the MySQL Server
Choose your training options. Attend a public or private training.
This is what our clients have to say
Answers to some of the most frequently asked questions.
With public training you attend the course with other delegates from other companies at our premises. If you would like private training we can arrange that the training be done at your premises, however, we require a minimum of 4 delegates for a private course.
The training runs at your premises or you can come to us. We require a minimum of 4 delegates for a private training.
Should you not be happy with the training, this should be raised within the first hour of training. We will try to resolve the issue and if we can't we refund 100% your money.
You can not cancel the course once you have booked. Please make sure that you have resolved your dates before making a booking. It takes a long time to organise the training, so we will not be able to refund once you book, however we can try to re-schedule the course at a later date for you.
The course price depends on whether the course will be on your site(private training) or at our offices(public). For a private course we require a minimum of 4 delegates in order to schedule the course.
Most of our coruses are offered over 5 days full time, except for the Xamarin Cross Platform Mobile App Development course which is offered over 2 weeks. No part-time courses are offered at the moment.
We don't provide accomodation but we can help you find accomodation close to the center. We can also help you with arranging transport to pick you up from the airport.
Our preferred accomodation provider is AirBnb. We recommmend if its your first time, only book from a Super Host on AirBnB.
Our mobile app development courses are hands on, for you to receive a certificate of completion, you will need to demonstrate that you have master the concepts during the course by developing a production mobile application and deploying it to the Google Play or Apple store. No certificates of completion will be awarded without proof that you have developed and deployed your app to the relevant store.