MongoDB Querying
MongoDB
| Intermediate
- 15 videos | 1h 6m 51s
- Includes Assessment
- Earns a Badge
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
-
5mDuring this video, you will learn how to configure and test PyMongo in a Python program. FREE ACCESS
-
3. Document Structure8m 52sIn this video, you will work with the MongoDB document structure. FREE ACCESS
-
4. CRUD Operations8m 12sIn this video, you will learn how to perform create, read, update, and delete operations on a MongoDB document. FREE ACCESS
-
5. ObjectID and Timestamp3m 38sDuring this video, you will learn how to work with MongoDB document ObjectIDs and Timestamps. FREE ACCESS
-
6. Query Operations6m 31sIn this video, learn how to use the find operation to select documents from a collection. FREE ACCESS
-
7. Projection Queries3m 40sAfter completing this video, you will be able to specify which fields to return from the find operation. FREE ACCESS
-
8. Comparison Operators2m 50sFind out how to use the comparison query operators to match criteria. FREE ACCESS
-
9. Element Query Operators4m 26sFind out how to apply the $exists and $type elements to a query. FREE ACCESS
-
10. The Regex Operator4m 36sDuring this video, you will learn how to use the regex operator to query documents. FREE ACCESS
-
11. Using the Size and All Operators4m 1sIn this video, find out how to use the $size and $all operators to query array fields. FREE ACCESS
-
12. Text Search3m 31sIn this video, you will perform a text search query on string content. FREE ACCESS
-
13. Using mongoimport3m 24sLearn how to use the mongoimport tool to import from JSON and CSV files. FREE ACCESS
-
14. Using mongoexport4m 12sIn this video, find out how to use the mongoexport tool to export data from MongoDB to JSON and CSV. FREE ACCESS
-
15. Exercise: Performing a Query2m 39sDuring 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.
