ILT: DF200: Optimizing Storage and Retrieval
This training day covers the fundamentals of indexing in theory and in 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.
Training: Optimizing Storage and Retrieval (DF200)
+ Annual Pass Content
This course is available both as a live, virtual, instructor-led training and as an on-demand version exclusively for Annual Pass Holders. If you're an Annual Pass Holder, you can access the course through your Learner Dashboard.
Overview
On completion of this training day you will know how to avoid common MongoDB mistakes (failing to correctly index queries or leverage database capabilities for computation of data) and design your data access for optimal performance. This training is a must for any developer writing code which needs to perform quickly and efficiently.
Agenda
Introduction
- 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
Database Profiling
- 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 *
End of day test
* includes hands-on exercise
Duration
1 day
Learning Paths
Please see the MongoDB Learning Paths here!
Program Datasheets
Course prerequisites
This course has the following prerequisites:
- DF100: MongoDB Developer Fundamentals
Language
This course is offered in multiple languages. Check the session title to see which language your selected session will be offered in.
Course access
This course is entirely virtual, and will be conducted over Zoom video conferencing and Strigo hands-on lab environments.
