Overview

Keep your mission-critical applications and essential services up and running with comprehensive MySQL training. To grow your skillset and be more productive in your job, access a rich library of digital courses at your own convenience, then test your new skills through interactive, hands-on labs. Deepen your understanding of MySQL administration, development, security, and high availability in a risk-free environment through role- and topic-based courses. Learn what you need to know to deliver high-performance and scalable applications, then create new opportunities by getting MySQL certified.
This OM8-PT: MySQL 8.0: Performance Tuning course teaches you how to use a wide range of configuration options, monitoring tools, and techniques used by MySQL database professionals to keep your applications fast, efficient, and secure.

Through a blend of hands-on labs and interactive lectures, you will learn how to do performance tuning; test and configure your server; examine performance metrics using a range of database system metrics, command line and graphical tools; design a circuit for optimal performance; identify and optimize slow queries and troubleshoot common performance issues.

Skills Covered

After completing this course, you will be able to:

  • How to troubleshoot common performance issues
  • Checking the MySQL Server
  • Configuring MySQL Server Parameters
  • Explore performance metrics using a range of database system metrics, command line utilities, and graphical tools.
  • Build database and queries for optimal performance.
  • Diagnose and fix replication delays

Who Should Attend

This course intended for Database Administrators, Developer and System Administrator

Course Curriculum

Prerequisites

  • MySQL for Database Administrators
  • Experience maintaining a database server (preferably a MySQL server)
  • Can use MySQL tools to connect to the MySQL Server
  • Have knowledge of general SQL statement structure and basic SQL tuning principles
  • Working knowledge of Linux operating systems

Download Syllabus

Course Modules

Request More Information