MongoDB Querying

MongoDB    |    Intermediate
  • 15 videos | 1h 6m 51s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 76 users Rating 4.4 of 76 users (76)
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).

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 1m 20s
  • 5m
    During this video, you will learn how to configure and test PyMongo in a Python program. FREE ACCESS
  • Locked
    3.  Document Structure
    8m 52s
    In this video, you will work with the MongoDB document structure. FREE ACCESS
  • Locked
    4.  CRUD Operations
    8m 12s
    In this video, you will learn how to perform create, read, update, and delete operations on a MongoDB document. FREE ACCESS
  • Locked
    5.  ObjectID and Timestamp
    3m 38s
    During this video, you will learn how to work with MongoDB document ObjectIDs and Timestamps. FREE ACCESS
  • Locked
    6.  Query Operations
    6m 31s
    In this video, learn how to use the find operation to select documents from a collection. FREE ACCESS
  • Locked
    7.  Projection Queries
    3m 40s
    After completing this video, you will be able to specify which fields to return from the find operation. FREE ACCESS
  • Locked
    8.  Comparison Operators
    2m 50s
    Find out how to use the comparison query operators to match criteria. FREE ACCESS
  • Locked
    9.  Element Query Operators
    4m 26s
    Find out how to apply the $exists and $type elements to a query. FREE ACCESS
  • Locked
    10.  The Regex Operator
    4m 36s
    During this video, you will learn how to use the regex operator to query documents. FREE ACCESS
  • Locked
    11.  Using the Size and All Operators
    4m 1s
    In this video, find out how to use the $size and $all operators to query array fields. FREE ACCESS
  • Locked
    12.  Text Search
    3m 31s
    In this video, you will perform a text search query on string content. FREE ACCESS
  • Locked
    13.  Using mongoimport
    3m 24s
    Learn how to use the mongoimport tool to import from JSON and CSV files. FREE ACCESS
  • Locked
    14.  Using mongoexport
    4m 12s
    In this video, find out how to use the mongoexport tool to export data from MongoDB to JSON and CSV. FREE ACCESS
  • Locked
    15.  Exercise: Performing a Query
    2m 39s
    During this video, you will learn how to use a number of different operators to get a result from MongoDB. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.7 of 7 users Rating 4.7 of 7 users (7)
Rating 4.5 of 29 users Rating 4.5 of 29 users (29)
Rating 4.5 of 67 users Rating 4.5 of 67 users (67)