> > D61820GC20

MySQL Performance Tuning (D61820GC20)

Course Description Schedule Course Outline
 

Who Should Attend

  • Database Administrators
  • Developer
  • System Administrator

Prerequisites

Required Prerequisites

  • 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

Suggested Prerequisites

  • An ability to locate and execute commands on Linux
  • Experience with a MySQL Server instance and MySQL tools
  • Experience writing SQL retrieve, insert, modify and delete
  • MySQL for Database Administrators

Course Objectives

  • Understand the basics of performance tuning
  • Use performance tuning tools
  • Tune the MySQL Server instance to improve performance
  • Improve performance of tables based on the storage engine being used
  • Implement proper Schema Design to improve performance
  • Improve the performance of MySQL Queries
  • Describe additional items related to performance tuning

Course Content

In this class, you'll learn practical, safe, highly efficient ways to optimize performance for the MySQL Server. This course will prepare each student with the skills needed to utilize tools for monitoring, evaluating and tuning. Students will evaluate the architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts.

Classroom Training
Modality: C

Duration 4 days

Price (VAT excl.)
  • Belgium: 2,680.- €
  • The Netherlands: 2,708.- €
Dates and Booking
 
Schedule

Currently there are no training dates scheduled for this course.  Enquire a date