Oracle MySQL Database Administration Certification Training Course

Prepare for the Oracle MySQL Database Certification Training Course


Upcoming Course Schedule

About this course

Learn more about the Oracle MySQL Administration training certification course.



What is the course about

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.

Duration

5 days full time.

Technical Skill

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.

Private Training

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.

Course Schedule

Download the full course schedule below

Introduction to MySQL Server

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

User Management

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

InnoDB 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

Programming MySQL

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)

Introduction to Performance Tuning

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

Download Course Outline
Course Pricing

Choose your training options. Attend a public or private training.

Public Training
R13860
  • Training at our center
  • Small class size
  • 5 days instructor led
  • Access to Slack channel
  • Access to materials website
  • 6 months after training support
  • Teamviewer, email and telephone support
  • Personalized feedback
  • Light lunches
Reserve Seat
Popular
Private Training - Onsite
R10450
  • Training on your site
  • Choose as many delegates as you want
  • 5 days instructor led
  • Access to Slack channel
  • Access to materials website
  • 6 months after training support
  • Teamviewer, email and telephone support
  • Personalized feedback
  • Customized course content
  • You provide the lunches
Enquire Now

Newsletter Sign Up

No Spam - Only latest news, price and activity updates
What people say about our courses

This is what our clients have to say

After attending the Xamarin training from Peruzal on our site, we were able to drastically accelerate our internal mobile app development efforts. Peruzal was a phone call away each time we needed support.
Jonathan Winnaar Scientist @ Institute for Maritime Technology
Came across your courses on Google search, after searching for Ruby training around South Africa. We were completely blown away with how much your trainers know stuff.
Divan Santan Infrastrucutre Engineer @ First National Bank
After our DBA left, we were left with noone with the skills to manage the research and scientific database Infrastrucutre. With Peruzal, we were able to get our team running in a matter of a week.
Encarni Colmenero Astronomer @ Southern African Large Telescope
Our team had different backgrounds, application programmers and astronomers with varied database interactions, we did not have formal training in the MySQL database. Peruzal delivered the training onsite and we were comfortable working with MySQL.
Lucian Botha Astronomy Information System Specialist @ South African Astronomical Observatory
“Coming from an academic background, with no prior exposure to programming, I had to develop an Android mobile app for tuition and research purposes. Peruzal helped me to build and implement the app in record time!”
Thuli Shandu Lecturer @ Univeristy of South Africa
Having years of experience in automation and embedded systems, we wanted our team to have experience in developing for Android. Peruzal did send a trainer onsite and we were blown away with the amount of information we had learnt in just 5 days
Cobus Smith Automation Manager @ ArcelorMittal
FAQS

Answers to some of the most frequently asked questions.



Public Training
What is public training

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.

What is private training

The training runs at your premises or you can come to us. We require a minimum of 4 delegates for a private training.

Refund Policy

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.

Cancelling Training

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.

Course Pricing
How much does the course cost?

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.

How long does it take to complete 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.

Accomodation

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.

Certificate of Completetion

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.