MySQL: Storage Engines, Advanced Indexing, and Maintenance
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
A well designed and high performance database depends on its storage engine and index structure. In this course, you'll take an in-depth look at storage engines and how they affect the performance of your MySQL databases. The course also covers index structures and types, indexing for performance, and index maintenance.
Target Audience
Personnel at all levels of an enterprise seeking to attain competency in MySQL.
Prerequisites
None
Expected Duration (hours)
3.0
Lesson Objectives MySQL: Storage Engines, Advanced Indexing, and Maintenance
start the course
examine the available storage engines for MySQL databases
examine the features and abilities of different storage engines to best support applications
compare the features of two common storage engines
set your default storage engine and work with multiple storage engines
set the internal structure of indexes
recognize the clustered index structure
recognize the secondary index structure
create a clustered index on a table
create a secondary index on a table
recognize how MySQL automatically defines and creates hash indexes
examine the various index types available in MySQL
determine what types of indexes have been implemented and their properties
create multi-column indexes and examine their sequences
examine how AND and OR conditions affect query results and performance
examine the effect of an AND condition on query performance
examine the effect of an OR condition on query performance
recognize the use and effectiveness of a covered index
create a covered index to improve query performance
examine how to explicitly direct your queries to use a specific index
examine how indexes need to be maintained over time
examine the process which can adversely affect index performance
recognize how MySQL uses statistics to make the best use of your indexes
examine the MySQL query optimizer and how it determines the most effective method to retrieve data
improve index performance using drop and recreate methods
recognize general methods for maintaining tables and indexes
recognize recommendations for keeping your data and indexes current and effective
describe and use storage engines and describe and manage indexes
Course Number: df_mysq_a06_it_enus
Expertise Level
Beginner