This course on MongoDB Indexing aims to teach students the importance of indexes in databases, specifically focusing on MongoDB. By the end of the course, learners will be able to understand the creation process of indexes, utilize different index creation options, improve query performance using indexes, and effectively delete indexes when necessary. The course covers topics such as B-Tree structures, default _id index with ObjectID, and query performance analysis using explain(). The teaching method includes theoretical explanations, practical examples, and hands-on exercises. This course is intended for database administrators, developers, and anyone interested in optimizing database performance in MongoDB.
Overview
Syllabus
01 MongoDB Indexing - Introduction to Indexes.
02 MongoDB Indexing Overview.
03 MongoDB Indexing - Index Creation Process.
04 MongoDB Indexing - B-Tree and how index works.
05 MongoDB Indexing - Default _id index with ObjectID.
06 MongoDB Indexing - getIndexes().
07 MongoDB Indexing - Create new index.
08 MongoDB Indexing - Index Creation Options.
09 MongoDB Indexing - Example 1: Create Unique index.
10 MongoDB Indexing - Example 2: Create index in background.
11 MongoDB Indexing - Example 3: Index with custom name.
12 MongoDB Indexing - Query Performance and explain().
13 MongoDB Indexing - Example 4: Query performance with index.
14 MongoDB Indexing - Example 5: ExecutionStats with Index.
15 MongoDB Indexing - Example 6: Query performance without index.
16 MongoDB Indexing: Example 7 ExecutionStats without Index.
17 MongoDB Indexing - Example 8: ExecutionStats with RegExp.
18 MongoDB Indexing - Indexes deletion.
19 MongoDB Indexing Summary.
Taught by
Bogdan Stashchuk
