MySQL 5.0 Performance Tuning

ExitCertified Canada English

ExitCertified Canada French



	start > courses and registration > training feature sheet

MySQL 5.0 Performance Tuning

course schedule			who can benefit
prerequisites			skills gained
other notes			course content
related solutions

code.

MySQL5-PT

length.

4 days

type.

Instructor-Led

partner.

MySQL

price.

$1,999

	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.

course schedule

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

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

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

format

	Instructor led, with extensive hands-on lab exercises
	Each student will be provided with their own computer

applies to mysql version:

4.1, 5.0

course content details

	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.

Organize your IT training. Contact an expert training consultant to put together the best training package for your organization.

	go to top

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include: