About This Course

 Course Overview

This MySQL Database Administration course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and SQL commands. The course provides practical experience in setting up and maintaining a MySQL server, including backing up, recovery, and configuration and tuning.

Who Should Attend

Anyone who needs to administer, monitor and support MySQL databases and servers. Database Administrators, Database Developers, Technical Consultant.

Course Objectives

To provide the skills necessary to administer, monitor and support MySQL databases and servers. Using Client Programs for MySQL DBA Work, Obtaining Metadata, Configuring the Server, Server Installation, Administration and Upgrading, Setting up Character Set Support, Configuring Log Files, Interpreting Error Messages, Creating, Altering and Dropping Databases and Tables, Locking and Transactions, Using Storage Engines, including the MyISAM and InnoDB engines, Table Maintenance, Backup and Recovery, including Exporting (mysqldump) and Importing (mysqlimport), Administering Users and Privileges, Using Stored Procedures and Triggers for Database Administration Tasks, Securing the Server, Tuning Queries, Tuning Tables and Indexes, Tuning the Server, Using the Event Scheduler, Creating Partitioned Tables, Replication, Using MySQL Workbench.

Prerequisites

A working knowledge of MySQL is required. This can be gained by attendance on the Introduction to MySQL course.

• Follow us