Administering MySQL

This 5 day class is for anyone who wants to administer a MySQL Database server. The course explains how MySQL works from the ground up, as well as covering the broader MySQL ecosystem. You will learn how to:

You will learn how to:



* Install and configure the server
* Manage user accounts and privileges
* Choose and configure storage engines
* Design, backup, restore and upgrade your databases
* Handle crash recovery and emergency fail over
* Implement database replication and monitoring

Format:

Instructor led course with hands-on lab exercises.
Each student will be provided with an individual computer/workstation

Duration:

5 days

Table of contents (subject to changes):

1.

Introduction
2.

Installation
3.

Client Utilities
4.

Architecture
5.

Configuration
6.

Storage Engines
7.

Resource Usage
8.

Maintenance
9.

Backups
10.

Data Types
11.

Views
12.

Partitioning
13.

Programming
14.

Security
15.

Replication
16.

Monitoring
17.

Troubleshooting
18.

Optimization
19.

High Availability
20.

Conclusion

Forudsætninger

Basic SQL knowledge is needed, as well as a mastery of fundamental database concepts. Prior usage of MySQL is recommended, but not required

Kurset henvender sig til

This course is both for new DBAs who want to learn all the tricks of the trade, as well as more knowledgeable DBAs who want to extend their skills to master all parts of administering a MySQL server.