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
Course Modules
Exam & Certification
This course is not associated with any Certification.
