Course Overview
This training day covers the fundamentals of indexing in theory and practice, how to profile database operations to identify bottlenecks, the aggregation query language, and how to move beyond simple retrieval of raw data to in-database computation.
Prerequisites
This course has the following prerequisites:
- DF100: MongoDB Developer Fundamentals
Audience Profile
- developers
Learning Objectives:
On completing this training day, you will know how to avoid common MongoDB mistakes (failing to correctly index queries or leverage database capabilities for data computation) and design your data access for optimal performance. This training is necessary for any developer writing code to perform quickly and efficiently.
Content Outline
- What are indexes?
- MongoDB misconceptions
- Single field indexes
- Reading explain plans *
- Indexes and performance
- Limits
- Best practices
- Compression
- Multikey indexes
- Compound index design *
- Covered queries
- Geospatial indexing *
- 2d indexes
- Spherical indexes
- TTL indexes
- Text indexes
- Wildcard indexing
- How indexes are chosen
- Query planner / Query optimizer
- Hints and tips
- Finding slow operations
- Slow query log
- Enabling the profiler
- Causes of slow operations
- Aggregation basics
- How to code aggregation
- Using the GUI pipeline builder
- Stages and expressions *
- Grouping *
- Joining / Classifying / Reshaping
- Database internal statistics
- Expression variables
- Optimizing aggregation *
FAQs
This training day covers the fundamentals of indexing in theory and practice, how to profile database operations to identify bottlenecks, the aggregation query language, and how to move beyond simple retrieval of raw data to in-database computation.
As you would expect, an index is a data structure that the database uses to find records within a table more quickly. Indexes are built on one or more table columns; each index maintains a list of values in that field sorted in ascending or descending order.
This course has the following prerequisites:
- DF100: MongoDB Developer Fundamentals
To attend the training session, you should have operational Desktops or Laptops with the required specification and a good internet connection to access the labs.
Technical issues are unpredictable and might occur with you as well. Participants must ensure that they have the system with the required configuration and good internet speed to access online labs.
If the problem persists or you face any challenge during the class, you can report it to us or your trainer. In that case, Radiant would provide you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption and NOT for distribution or any commercial use.
Radiant Techlearning offers training programs on weekdays, weekends, and a combination of weekdays and weekends. You can always choose the schedule that best suits your need.
Once we receive your enrollment request, we will share the enrollment details with you to select and complete the enrollment process.
You can email us at the below email address (whichever is applicable) to know the upcoming schedule for a specific technology training program.
Individual: training@radianttechlearning.com
Corporate: Corporate@radiantechlearning.com