MySQL Indexing for Performance
Pluralsight
Course Summary
MySQL course focusing on Indexing Strategies for High Performance Database
-
+
Course Description
Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. Indexes are the silver bullets for Performance. In this course we will gain an understanding of the basics of Indexes and further explore practical tips and tricks for performance tuning.
-
+
Course Syllabus
MySQL Indexing for Performance- 1m 35s
—Introduction 1m 35sTypes of Indexes- 29m 0s
—Introduction 1m 32s
—InnoDB vs MyISAM 3m 20s
—B-Tree Index 1m 30s
—Advantages of B-Tree Index 2m 5s
—Clustered Index 0m 42s
—Advantages of Clustered Index 1m 9s
—Disadvantages of Clustered Index 1m 6s
—Secondary Index 0m 38s
—Building Clustered B-Tree 4m 47s
—Building Secondary Index B-Tree 1m 9s
—InnoDB Clustered Table 2m 22s
—Hash Index 1m 6s
—Limitation of Hash Index 1m 19s
—Adaptive Hash Index 1m 49s
—Building Hash Index 2m 31s
—Other Indexes 1m 23s
—Summary in Sixty Seconds 0m 26sIndexing Strategies for High Performance- 55m 12sIndex Maintenance- 11m 10sChecklists- 2m 39s
This course is listed under
Open Source
, Development & Implementations
and Data & Information Management
Community
Related Posts:
