MySQL Database Administration

Course Overview

This MySQL Database Administration course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and a good working knowledge of SQL commands.

The course provides an understanding of MySQL Architecture and practical experience in setting up, configuring and maintaining a MySQL server, and backing up and recovering data. This MySQL Database Administration course also covers MySQL replication and its role in high availability and scalability.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

The delegate will learn and acquire skills as follows:

• Using Client Programs for MySQL DBA work

• Using MySQL Workbench

• Obtaining metadata

• Configuring the MySQL Server

• Install and configure the MySQL Server and client programs

• Administer and tune a server

• Setting up Character Set Support

• Configuring log files and using them to monitor database activity

• Interpreting error messages

• Locking and transaction handling

• Using different storage engines

• Table Maintenance

• Implementing a backup strategy

• Performing physical and logical backups of data

• Administering Users and Privileges

• Using the Event Scheduler

• Configure simple replication topologies

• Administer a replication topology

Who will the course benefit?

Database Administrators, Database Developers and Technical Consultants who need to setup, administer, monitor and support MySQL databases and servers.