Academy 3T

MongoDB 301: Aggregation

Go deeper into MongoDB Aggregation

MongoDB 301: Aggregations is Academy 3T’s intermediate MongoDB course that builds on both MongoDB 201 and MongoDB 101.

Packed with just the right amount of theory and hands-on exercises, you’ll get to understand more about Aggregation in MongoDB.

  • Learn the basics of creating an Aggregation pipeline in the MongoDB shell
  • Use the Studio 3T Aggregation Editor to make and debug more powerful Aggregations
  • Dig deeper into how to work with arrays in the Aggregation date.
  • Find out how to $lookup documents from another collection and add them into your pipeline.
  • Going beyond just aggregation and restructuring your data’s schema with Reschema.
  • Turn your data into views, spreadsheets and charts with Aggregations.

Who this MongoDB course is for

  • Students who have completed MongoDB 101 and 201 want to learn intermediate MongoDB concepts
  • Students switching from SQL or relational databases to MongoDB

A couple of prerequisites

For the exercises in this course, you’ll need to access a MongoDB database and Studio 3T.

Happy MongoDB aggregating!

Begin with Building a Basic Aggregation

Course Content

Expand All
  • Course Home Expand All
    Building a Basic Aggregation
    4 Topics | 1 Quiz
    Exercise 1: Filtering the documents in the aggregation pipeline
    Exercise 2: Grouping the documents in the aggregation pipeline
    Exercise 3: Sorting the documents in the aggregation pipeline
    Exercise 4: Adding processing options to the aggregation
    Building a Basic Aggregation: Test your skills
    Introducing the Aggregation Editor
    4 Topics | 1 Quiz
    Exercise 1: Importing an aggregate statement into the Aggregation Editor
    Exercise 2: Replace a field in the aggregation pipeline
    Exercise 3: Reorder the fields in the aggregation pipeline
    Exercise 4: Changing the sort order in the aggregation pipeline
    Introducing the Aggregation Editor: Test your skills
    Working with Arrays in the Aggregation Pipeline
    4 Topics | 1 Quiz
    Exercise 1: Using expression operators to filter input documents
    Exercise 2: Unwinding an array to create individual documents
    Exercise 3: Grouping array values and generating a document count for each group
    Exercise 4: Writing pipeline results to a new collection
    Working with Arrays in the Aggregation Pipeline: Test your skills
    Adding Lookup Data to the Aggregation Pipeline
    4 Topics | 1 Quiz
    Exercise 1: Adding lookup data to the aggregation pipeline
    Exercise 2: Converting string values in one of the lookup fields to integers
    Exercise 3: Adding a computed ratio field based on the converted lookup field
    Exercise 4: Limiting the number of returned documents
    Adding Lookup Data to the Aggregation Pipeline: Test your skills
    Working with Reschema for MongoDB
    4 Topics | 1 Quiz
    Exercise 1: Setting up a reschema unit that includes lookup data
    Exercise 2: Defining a target collection in the reschema unit
    Exercise 3: Adding and scheduling a task to create the target collection
    Exercise 4: Running an aggregate statement against the target collection
    Working with Reschema for MongoDB: Test your skills
    Reporting with Studio 3T Aggregations
    3 Topics | 1 Quiz
    Exercise 1: Creating a view based on an aggregation query
    Exercise 2: Exporting a collection as a .csv file for use by a third-party tool
    Exercise 3: Visualizing collection data in MongoDB Charts
    Reporting with Studio 3T Aggregations: Test your skills
    Course Extras