SkillSoft Explore Course – Lambers, Inc.

Aspire Data Analyst to Data Scientist Data Science Track 2: Data Wrangler

This 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.

Asset ID	it_dsmgswdj_02_enus
Course Type	Video Course
Course Category	Data Analyst to Data Scientist

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

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