E-Learning: MySQL Partitioning

• 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.

Applies to MySQL Version:

5.1

Duration

4 Hours

Upcoming Sessions