> > D61820GC20

MySQL Performance Tuning (D61820GC20)

Cursusbeschrijving Beschikbare data Gedetailleerde cursusinhoud
 

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.

Klassikale training
Modality: C

Duur 4 dagen

Prijs (excl. BTW)
  • Nederland: 2.708,- €
  • België: 2.680,- €
Beschikbare data
 
Beschikbare data

Op dit moment is deze training niet beschikbaar in het open rooster. De kans is echter groot dat wij u toch een passende oplossing kunnen bieden. Wij horen graag wat uw specifieke wensen zijn. U bereikt ons via 030 658 2131 of info@flane.nl. We helpen u graag!  Vraag een datum aan

 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!