The Introduction to MySQL Administration training course focuses on installing, configuring, and tuning MySQL as a Relational Database Management System (RDBMS) for use with Java, Hypertext Preprocessor (PHP), Ruby, and .NET. The MySQL Administration training is structured around the most recent MySQL 5.6 release.
The course begins with an overview of MySQL and its basic concepts and downloading and installing. With the foundations laid, the course then dives into manually controlling MySQL with scripts, configuring and securing MySQL and working with logs. The course concludes with reviewing how to backup, restore and replicate data in MySQL and setting up a cluster.
Purpose
|
Learn how to install, configure, and administer MySQL. |
Audience
|
Experienced Developers and Administrators wanting to have a production-quality command of MySQL. |
Role
| System Administrator |
Skill Level
| Intermediate |
Style
| Learning Spikes - Workshops |
Duration
| 3 Days |
Related Technologies
| MySQL | SQL |
Productivity Objectives
- Discuss basic MySQL concepts
- Produce MySQL scripts
- Indicate how to configure and secure MySQL
- Analyze data backup, restoration, and replication
- Manage databases and queries