Announcement: Mindasys is now Skillet! Check out our new website.

Key points about this course

Duration : 4 Days
Course Fee : RM 4,799.00

HRD Corp Claimable Course

MySQL 5.7 for Database Administrators
Exam Code : 1Z0-888

Live Virtual Class

Public Class

In-House Training

Private Class

Course Overview

This MySQL 5.7 for Database Administrators training is a foundation course. It teaches database administrators and developers how to use this powerful database. Learn how to secure users privileges, set resource limitations and access controls. Instructors will show you how to create and use Stored Procedures, Triggers and Views.

The learning objectives including 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 and many more.

This MySQL Database Administrator course is available in our face to face classroom or through a live virtual class training. This training is available for a public and private group. It is open for Malaysia and international students.


Who should attend?

  • DBAs and developers who want to administer MySQL.
  • Anyone who needs to administer, monitor and support MySQL databases and servers.
Course Prerequisites

A working knowledge of MySQL is required or attended on the Introduction to MySQL course.

Course Content


  • Describing MySQL
  • Listing MySQL Products and Professional Services
  • Describing MySQL Enterprise Subscription
  • Currently Supported Operating Systems
  • Describing MySQL Certification Program
  • Listing Available MySQL Courses
  • Describing Installation of MySQL
  • Describing Installation of 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
  • NULLs
  • Column Attributes


  • Metadata Access Methods
  • The INFORMATION_SCHEMA Database/Schema
  • Using SHOW and DESCRIBE
  • 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 Comparison Chart


  • Overview of Partitioning and reasons for using 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

  • Transactions
  • Transaction Control statements
  • Isolation Levels
  • Locking

Security and User Management

  • Security Risks
  • Security Measures
  • Privileges
  • Access Levels, including: 1 – User Accounts, 2 – Databases, 3 – Tables, 4 – Columns, 5 – Stored Routines
  • User Account Maintenance
  • Client Access Control
  • Using Secure Connections

Table Maintenance

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

Exporting and Importing Data

  • Exporting and 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


  • Course Overview
  • Training and Certification Website
  • Course Evaluation