Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Introduction to MySQL Administration

Course Summary

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

What You'll Learn:

In the Introduction to MySQL Administration training course, you'll learn:
  • What is MySQL?
  • Review of Basic SQL Concepts
  • Downloading and Installing MySQL
  • Controlling MySQL
    • Manually, with scripts as part of the boot process
  • Configuring and Securing MySQL
  • Working with Logs
  • Data
    • Backup
    • Restoration
    • Replication
  • Optimizing MySQL
    • Tuning databases and queries
  • Setting Up a MySQL Cluster
real world content

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
expert practitioners

Expert Practitioners

Industry experts that bring their battle scars into the classroom.
experiential learning

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
tailored outlines

Tailored Outlines

One-size-fits-all doesn't apply to training teams. That's where we come in!
“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

By filling out this form and clicking submit, you acknowledge our privacy policy.