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