Indexing Design Fundamentals
Learn how to design efficient indexes to speed up queries, and reduce resource consumption in MongoDB.
|
Upon completion of the Indexing Design Fundamentals skill and skill check, you will earn a Credly Badge that you are able to share with your network. |
Learning Objectives
Apply Indexing Best Strategies
Apply best practices including identifying the most frequent queries, creating the minimal number of indexes needed to support those frequent queries and understanding how to build efficient compound indexes.
Optimize Indexes for Performance
Be able to apply strategies such as ESR (equality, sort, range) when appropriate and know how to create indexes for a specific strategy.
Measure Index Performance
Use and interpret the outputs of the tooling such as explain() with your queries to determine if queries are using indexes.
Sarah Evans | Senior Curriculum Engineer
Sarah is a Senior Curriculum Engineer on the Curriculum team at MongoDB. Prior to MongoDB, she taught and developed curricula for developer bootcamps. Sarah has a MAT degree from Columbia University Teachers College and studied Software Engineering at Flatiron School in Chicago, IL.
Manuel Fontan Garcia | Senior Technologist, Education
Manuel is a Senior Technologist on the Curriculum team at MongoDB. Previously he was a Senior Technical Services Engineer in the Core team at MongoDB. In between Manuel worked as a database reliability engineer at Slack for a little over 2 years and then for Cognite until he re-joined MongoDB. With over 15 years experience in software development and distributed systems, he is naturally curious and holds a Telecommunications Engineering MSc from Vigo University (Spain) and a Free and Open Source Software MSc from Rey Juan Carlos University (Spain).
Daniel Curran | Senior Software Engineer
Daniel is a Senior Software Engineer at MongoDB. Before joining MongoDB, he worked as an Instructional Designer and Content Developer specialising in technical content for a host of international clients. Daniel's goal is to remove obstacles so learners can feel confident on their journey to become masters of MongoDB.
John McCambridge | Curriculum Engineer
John is a Curriculum Engineer on the University team at MongoDB. Before his work as a Curriculum Engineer, he was an instructor and teaching assistant for coding boot camps at UT (Austin), and UCLA. Additionally, he worked as a QA engineer for a startup called Coder and spent five years at Apple Inc. John is a passionate software engineer and educator who enjoys taking complex topics and making them digestible for the community.
