Course details

MongoDB for Data Wrangling: Aggregation

MongoDB for Data Wrangling: Aggregation


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

This Skillsoft Aspire course explores MongoDB, a cross-platform document-oriented database that has become a popular tool for data wrangling and data science. MongoDB is a NoSQL (not only structured query language) that uses Javascript Object Notation (JSON)- like documents with schemata. This course demonstrates reshaping, aggregating and summarizing documents in a MongoDB database, and gather, filter, modify, and query data, and to perform MongoDB actions related to data wrangling. Learners observe demonstrations of how to recognize the structure of aggregate operations in MongoDB; how to use the group operator to perform aggregate computations; and how to use limit and sort operators in an aggregations pipeline. Next, learn how to use the unwind operator to expand an array field in an aggregation, and how to use the Lookup operator to perform a joint operation between 2 collections in an aggregation, and how to use the index stats operator in an aggregation stage to view the statistics on the indexes. Finally, you will learn how to use a Geospatial Index for a geosearch operation.



Expected Duration (hours)
0.9

Lesson Objectives

MongoDB for Data Wrangling: Aggregation

  • Course Overview
  • recognize the structure of aggregate operations in MongoDB
  • use the $group operator to perform a computation using an accumulator operator
  • use the $match operator to filter data in an aggregation query
  • use the $project operator to specify fields in an aggregation query
  • use the $limit and $sort operators in an aggregation pipeline
  • use the $unwind operator to expand an array field
  • use the $lookup operator to perform a join
  • use createIndex to build an index on a collection
  • use a geospacial index for a geoSearch operation
  • implement a multi-stage aggregation pipeline
  • Course Number:
    it_dsmgswdj_02_enus

    Expertise Level
    Intermediate