MySQL Performance Tuning

Hakkında

This training teaches how to safely and effectively optimize the performance of MySQL server. Students understand how to use the tools to monitor, evaluate and tune. The course makes participants proficient in evaluating architecture, using tools, configuring databases, and tuning SQL code and applications.

This certification also validates your skills to perform tasks like server tuning, storage engine examination, and application architecture assessment. Candidates additionally get acquainted with general concepts related to tuning. The course is appropriate for developers, as well as database and system administrators.

Candidates understand the fundamentals of performance tuning, and learn about the usage of performance tuning tools.

Önkoşullar

• 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

• Instructor-led training: 4 days with hands-on lab practice 
• Virtual instructor-led training: 4 days of web-based classes with hands-on lab practice 
• E-learning: Equivalent of 4 days of instruction with hands-on lab practice

• Improve performance by implementing appropriate Schema Design
• Portray additional items regarding performance tuning
• Enhance performance by tuning MySQL Server instance