Querying and Modifying Data in MongoDB

Paths

Querying and Modifying Data in MongoDB

Authors: Pinal Dave, Dan Geabunea, Axel Sirota, Esteban Herrera , Douglas Starnes, Buddhini Samarakkody

With MongoDB you will obtain a document-based data model which makes even the most complex tasks simple. This database system is extremely flexible with a wide range of features... Read more

Related topics

Relational databases (SQL Server MariaDB OracleDB) Other document databases Database administration Database development map-reduce

What You Will Learn

  • The rich query functionality of MongoDB
  • Application of MongoDB indexes
  • Understanding what security rules can be applied to different types of data
  • What are the operations supported on data when using MongoDB

Pre-requisites

  • JSON
  • Javascript

Beginner

Learn the core query and search semantics of MongoDB, and how they map into the document database structure used by MongoDB.

Foundations of Document Databases with MongoDB

by Pinal Dave

May 6, 2020 / 2h 28m

2h 28m

Start Course
Description

Every single day we come across lots of data and every a bit of data needs a place to be stored. In this course, Foundations of Document Databases with MongoDB, you'll learn foundational knowledge in MongoDB, a general-purpose, document-based, distributed database built for modern application developers and for the cloud era. First, You'll explore what a document database is and how it differs from relational SQL. Next, You'll discover why we should use MongoDB. Finally, You'll get an idea of how to get started with MongoDB, efficiently. By the end of this course, you will be confident to get started with your very first MongoDB setup. I will provide all the necessary information and code samples so you can get started immediately.

Table of contents
  1. Course Overview
  2. Introduction to MongoDB
  3. CRUD Operations: Creating Objects
  4. CRUD Operations: Retrieving Objects
  5. CRUD Operations: Updating and Deleting Objects
  6. Relating Common SQL Concepts and Semantics to MongoDB

Querying Data from MongoDB

by Dan Geabunea

Jun 11, 2020 / 1h 45m

1h 45m

Start Course
Description

MongoDB occupies the 5th position in database usage, making it a popular and trending technology. In this course, Querying Data from MongoDB, you will learn how to efficiently create Mongo DB queries. First, you will explore using the Mongo shell to connect to Mongo servers and write database queries. Next, you will discover how to filter data by using the most common query operators. Then, you will move on to implementing sorting, paging and field selection. Beyond this, you will learn how to write complex queries such as nested documents or geospatial data. Finally, you will gain an understanding on handling edge cases caused by the schema-less nature of MongoDB, such as null values, missing fields or queries by data type, as well as querying array fields. By the end of this course, you should feel confident tackling a wide range of queries in real MongoDB databases. In fact, you will be able to use these skills in real projects right away.

Table of contents
  1. Course Overview
  2. Writing Your First Mongo Query
  3. Understanding Query Filters and Query Operators
  4. Creating Complex Queries
  5. Working with Arrays

Searching for Text in MongoDB

by Axel Sirota

Jun 23, 2020 / 1h 39m

1h 39m

Start Course
Description

MongoDB is amazing! It is fast, reliable, highly scalable, and flexible; it is so flexible that since its beginnings it allows for full text search. In this course, Searching for Text in MongoDB, you will learn everything you need to know about text searches and indices. First, you will learn about text queries in MongoDB. Next, you will discover how to refine and order your results by relevance. Finally, you will explore how to handle corner cases with multiples languages, case-sensitiveness, and diacritic sensitiveness in your collections. When you have finished this course, you will have a foundational knowledge of full text search in MongoDB that will enable you to create pretty amazing and complex queries to search for text patterns!

Table of contents
  1. Course Overview
  2. Creating a Simple Text Query
  3. Refining Text Queries
  4. Creating a Weighted Text Index
  5. Creating a Non-default Text Index

Intermediate

Execute geospatial queries, and learn how to modify documents stored in MongoDB.

Querying Geospatial Data from MongoDB

by Esteban Herrera

Jul 17, 2020 / 1h 31m

1h 31m

Start Course
Description

Analyzing spatial data doesn't have to be a difficult task. In this course, Querying Geospatial Data from MongoDB, you’ll learn to execute geospatial queries in MongoDB. First, you’ll explore the concepts needed to understand the geospatial features of MongoDB. Next, you’ll discover how to store geospatial data in GeoJSON format. Finally, you’ll learn how to find places within a certain area and close to a point. When you’re finished with this course, you’ll have the skills and knowledge of MongoDB and geospatial data needed to execute geospatial queries efficiently.

Table of contents
  1. Course Overview
  2. Getting Started with MongoDB’s Geospatial Features
  3. Storing Geospatial Data in GeoJSON Format
  4. Finding Places within a Certain Area
  5. Finding Places near a Point

Modifying Data in MongoDB

by Douglas Starnes

Jul 27, 2020 / 2h 4m

2h 4m

Start Course
Description

While querying data in a database of any kind is a big part of its purpose, more functionality is needed to manage that data. In this course, Modifying Data in MongoDB, you'll delve into the C, U, and D of CRUD, or create, update, and delete from the view of a MongoDB administrator or developer. First, you'll learn how to take advantage of operators and filters to control these operations. Next, you'll discover how to use the JavaScript API in the command line mongo shell to perform these operations. Finally, you'll explore a small web app to learn how to put these operations into practice. By the end of this course, you'll have the necessary knowledge of the write operations in MongoDB in order to effectively utilize them in your own projects.

Table of contents
  1. Course Overview
  2. Creating Documents in MongoDB
  3. Deleting Documents in MongoDB
  4. Updating Documents in MongoDB
  5. Upserting Documents in MongoDB
  6. Bulk Write Operations in MongoDB
  7. A CRUD App

Advanced

Aggregate data across multiple documents, and execute more advanced queries using map-reduce against MongoDB.

Aggregating Data across Documents in MongoDB

by Axel Sirota

Jun 23, 2020 / 1h 51m

1h 51m

Start Course
Description

MongoDB is amazing! It is fast, reliable, highly scalable and flexible; and at the core of its flexibility, there is the Aggregation Framework. In this course, Aggregating Data across Documents in MongoDB, you will learn all the ways in which one find data throughout many documents. First, you will learn the Aggregation Framework in MongoDB, comparing it to Map Reduce and understanding the $match and $project stages. Next, you will discover about grouping our results and how to handle arrays with $unwind. Finally, you will explore how to save advanced reports on multiple types of aggregations. When you've finished this course, you will have foundational knowledge of the aggregation pipelines in MongoDB that will help you make the most complex operation seem incredibly easy!

Table of contents
  1. Course Overview
  2. Meeting the MongoDB Aggregation Framework
  3. Adding Stages to a Collections Pipeline
  4. Handling Advanced Operations in Aggregation

Querying Data Using Map-reduce in MongoDB

by Buddhini Samarakkody

Aug 20, 2020 / 1h 40m

1h 40m

Start Course
Description

Working with large volumes of document data for analytics requires the power and flexibility of MongoDB’s Map-reduce feature. In this course, Querying Data Using Map-reduce in MongoDB, you’ll gain the ability to get yourself fully equipped to confidently apply the Map-reduce pattern to any data set no matter how large it could be. First, you’ll discover the requirement for Map-reduce among other aggregation capabilities of MongoDB. Next, you’ll explore how to create a custom JavaScript map function and a reduce function that are needed to perform map and reduce operations. Finally, you’ll learn how to use these custom functions to perform a Map-reduce operation on a MongoDB data set to aggregate results across documents. When you’re finished with this course, you’ll have the skills and knowledge of working with the Map-reduce function in MongoDB that will help you leverage the power of MongoDB’s aggregation feature for data crunching requirements in your next project.

Table of contents
  1. Course Overview
  2. Discovering the Need for Map-reduce in MongoDB
  3. Creating Custom JavaScript Functions for Map and Reduce
  4. Applying Custom JavaScript Functions to MongoDB Map-reduce
  5. Putting the Pieces Together: Build a Complete Map-reduce Solution in MongoDB
Offer Code *
Email * First name * Last name *
Company
Title
Phone
Country *

* Required field

Opt in for the latest promotions and events. You may unsubscribe at any time. Privacy Policy

By providing my phone number to Pluralsight and toggling this feature on, I agree and acknowledge that Pluralsight may use that number to contact me for marketing purposes, including using autodialed or pre-recorded calls and text messages. I understand that consent is not required as a condition of purchase from Pluralsight.

By activating this benefit, you agree to abide by Pluralsight's terms of use and privacy policy.

I agree, activate benefit