Do you need to manage an increasing amount of data in your MySQL applications?
Do you want to monitor, diagnose problem areas and tune MySQL for optimal performance?
Do you want to write queries that take advantage of the MySQL 5.0 performance enhancements dealing with queries and indexing?
Do you want to Evaluates the application architecture for efficient design, structure, caching, number of connections and other factors affecting performance?
Then MySQL 5.0 Performance Tuning is the class for you! The MySQL 5.0 Performance Tuning course is designed for Database Administrators and others who wish to monitor and tune MySQL. 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.
Skills Gained
At the completion of this course, you should be able to:
Develop a tuning strategy
Display knowledge of MySQL architecture
Display knowledge and ability to use diagnostic tools
Display knowledge and ability to use tuning tools
Write queries against the INFORMATION_SCHEMA database and be able to decipher the metadata obtained
Understand the relational database model and both the positive and negative implications on performance
Display, decipher and edit server configuration variables to improve performance of your applications
Display and analyze status variables to ensure that their applications are utilizing the settings in the most effective manner
Write queries that take advantage of the MySQL 5.0 performance enhancements dealing with queries and indexing
Decide which of the storage engines could be used in their specific application needs
Evaluate the application architecture for efficient design, structure, caching, number of connections and other factors affecting performance
Evaluate hardware and OS for effects on performance
Evaluate techniques for loading data into the database and effects on performance
Who Can Benefit
Database Administrators who currently maintain MySQL server(s)
Database developers and programmers who currently design and/or interact with MySQL database(s)
System Administrators whose systems currently interact with MySQL server(s) or who also work with MySQL Administrators
Prerequisites
Students who wish to attend this course, should have attended the MySQL 5.0 for DBAs course or have similar knowledge:
Have previously worked with a MySQL Server instance and database
Have working knowledge of MySQL architecture
Can use MySQL tools to connect to the MySQL Server
Understands different methodologies for modeling database structures
Have knowledge of general SQL statement structure and basic SQL tuning principles
Can define table structures, Index structures, constraints and other objects
Can state general knowledge of hardware and OS
Format
Instructor led, with extensive hands-on lab exercises
Each student will be provided with their own computer
Applies to MySQL Version:
Instructor led, with extensive hands-on lab exercises
Each student will be provided with their own computer
Code:
MySQL5-PT
Length:
4 days
Type:
Instructor-Led
Certified By:
MySQL
Tuition:
$1,999
This course is taught by Certified MySQL instructors. There is a difference. Learn More
This course is in the following categories. Click the categories to find similar courses and topics of interest.
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
Course Topics
The MySQL 5.0 Performance Tuning course is designed for Database Administrators and others who wish to monitor and tune MySQL. 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.
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
