Do you want to learn how to manage large and/or complex databases with MySQL, in the most efficient manner?
Do you want to receive the undivided attention and instruction of a MySQL expert who will share information and techniques on this topic?
Do you want to avoid time and travel hassles by learning in your own setting, rather than going to an actual training site?
Then the E-Learning: MySQL Partitioning Course is for you!
This instructor-led course is designed for MySQL users who would like to use the new
partitioning features available in the MySQL 5.1 Beta server release. This course
provides in-depth information in an E-Learning classroom format that is easily accessible
and affordable.
At the completion of this course, you should be able to:
Understand the reasons for using partitioning
Understand when partitioning can improve the performance of certain queries
Understand differences between row and physical partitioning
Understand the basic PARTITION BY statement syntax
Understand how/why to optimize a partition
Understand and use the five types of partitioning
Understand and use the methods to add and remove partitions
Understand and use the methods to split and merge partitions
Understand and use the method for partitioning with date/time data
Understand and use the method for partitioning for performance improvement
Understand how major storage engines implement partitioning
Understand methods for physical partitioning
Perform maintenance tasks on partitions
Who should Attend
Developers and database administrators who need to efficiently manage large and/or complex data sets.
Prerequisites
The MySQL for Database Administrators course (or equivalent experience).
Format
Online access, with synchronous delivery of presentation slides. Instructor led, with interactive performance labs. Each student will be provided with a soft copy of the course guide (including the lab instructions), prior to the delivery of the course.
Sistemi per MySQL
