MongoDB for Data Wrangling: Querying


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

This course explores how to use 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 JSON (Javascript Object Notation) like documents with schemata. One advantage of MongoDB is the flexibility of how it stores data. You will learn how to perform MongoDB actions related to data wrangling by using Python with the PyMongo library. You will learn how to perform basic CRUD (create, read, update, delete) operations on a Mongo DB document. Next, learn how to use the find operation to select documents from a collection, and to use query operators to match document criteria. You will learn how to select documents using a specified criterion, similar to a WHERE clause in an SQL statement. Finally, this course demonstrates how to use the mongoimport tool to import from JSON or CSV, and mongoexport to export data from a MongoDB collection to JSON or CSV (comma separated values).



Expected Duration (hours)
1.1

Lesson Objectives

MongoDB for Data Wrangling: Querying

  • Course Overview
  • configure and test PyMongo in a Python program
  • work with MongoDB document structure
  • perform create, read, update, and delete operations on a MongoDB document
  • work with MongoDB document ObjectIDs and Timestamps
  • use the find operation to select documents from a collection
  • specify the fields to be returned from the find operation
  • use the comparison query operators to match criteria
  • apply the $exists and $type elements to a query
  • use the $regex operator to query documents
  • use the $size and $all operators to query array fields
  • perform a text search query on string content
  • use the mongoimport tool to import from JSON and CSV
  • use the mongoexport tool to export data from MongoDB to JSON and CSV
  • combine a number of different operators to get a result from MongoDB

    • Course Number:
    it_dsmgswdj_01_enus

    Expertise Level
    Intermediate