» » Pluralsight.com - MySQL Indexing for Performance

Information of news
4-09-2013, 17:56

Pluralsight.com - MySQL Indexing for Performance

Category: Tutorials

Pluralsight.com - MySQL Indexing for Performance

Pluralsight.com - MySQL Indexing for Performance
English | 40 WebRips (MP4) + Workfiles (PDF, SQL) | Size: 272.62 MB
Category: Computer Science

MySQL course focusing on Indexing Strategies for High Performance Database

MySQL Indexing for Performance. 00:01:36
Introduction 01:36

Types of Indexes. 00:28:59
Introduction 01:32
InnoDB vs MyISAM 03:20
B-Tree Index 01:30
Advantages of B-Tree Index 02:06
Clustered Index 00:42
Advantages of Clustered Index 01:09
Disadvantages of Clustered Index 01:06
Secondary Index 00:38
Building Clustered B-Tree 04:48
Building Secondary Index B-Tree 01:10
InnoDB Clustered Table 02:22
Hash Index 01:07
Limitation of Hash Index 01:19
Adaptive Hash Index 01:49
Building Hash Index 02:32
Other Indexes 01:23
Summary in Sixty Seconds 00:26

Indexing Strategies for High Performance. 00:55:11
Introduction 00:34
Effectiveness of Index 01:03
Demo: List Indexes 02:54
Demo: Basics of Indexes 05:39
Demo: Order of Columns in Index 04:04
Demo: Optimize OR Conditions 07:13
Demo: Optimize OR Conditions - Advanced 07:45
Demo: Optimize AND Conditions 05:31
Demo: Optimize AND Conditions - Advanced 02:26
Demo: Cover Index 04:04
Demo: Clustered Index 08:26
Demo: Index Hints 05:04
Summary in Sixty Seconds 00:28

Index Maintenance. 00:11:10
Introduction 00:58
MySQL Query Optimizer 01:04
Statistics 00:54
InnoDB Statistics 01:48
Data and Index Fragmentation 01:07
Index Maintenance 02:57
Other Index Maintenance Tips 01:51
Summary in Sixty Seconds 00:31
Checklists. 00:02:40
Checklists 02:40

Link Download

Buy Premium To Support Me & Get Resumable Support & Fastest Speed


Site BBcode/HTML Code:

Tags to an Article: Pluralsight, com, MySQL, Indexing, for

Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.