Why querying is essential in MongoDB - See It in Action

Why Querying is Essential in MongoDB

📖 Scenario: You work at a small bookstore that keeps its inventory in a MongoDB database. The store manager wants to find specific books quickly, like all books by a certain author or books priced below a certain amount.

🎯 Goal: Build a simple MongoDB query to find books by a specific author and then filter books by price. This will show why querying is essential to get useful information from the database.

📋 What You'll Learn

Create a collection called books with sample book documents

Add a variable authorName to specify the author to search for

Write a query to find all books by authorName

Write a query to find all books priced less than a given amount

💡 Why This Matters

🌍 Real World

Bookstores, libraries, and many businesses use databases to store items. Querying helps find the right items quickly.

💼 Career

Database querying is a fundamental skill for data analysts, backend developers, and anyone working with data storage.

1

DATA SETUP: Create the books collection with sample data

Create a MongoDB collection called books and insert these exact documents: { title: 'The Great Gatsby', author: 'F. Scott Fitzgerald', price: 10 }, { title: '1984', author: 'George Orwell', price: 15 }, { title: 'To Kill a Mockingbird', author: 'Harper Lee', price: 12 }

MongoDB

// Insert the sample book documents into the books collection
// Your code here

Hint

Use db.books.insertMany([...]) to add multiple documents at once.

2

CONFIGURATION: Define the authorName variable

Create a variable called authorName and set it to the string 'George Orwell' to specify the author you want to find.

MongoDB

db.books.insertMany([
  { title: 'The Great Gatsby', author: 'F. Scott Fitzgerald', price: 10 },
  { title: '1984', author: 'George Orwell', price: 15 },
  { title: 'To Kill a Mockingbird', author: 'Harper Lee', price: 12 }
])

// Define the authorName variable
// Your code here

Hint

Use const authorName = 'George Orwell'; to create the variable.

3

CORE LOGIC: Query books by the author stored in authorName

Write a MongoDB query using db.books.find() to find all books where the author field matches the variable authorName.

MongoDB

db.books.insertMany([
  { title: 'The Great Gatsby', author: 'F. Scott Fitzgerald', price: 10 },
  { title: '1984', author: 'George Orwell', price: 15 },
  { title: 'To Kill a Mockingbird', author: 'Harper Lee', price: 12 }
])

const authorName = 'George Orwell';

// Query books by authorName
// Your code here

Hint

Use db.books.find({ author: authorName }) to get books by that author.

4

COMPLETION: Query books priced less than 13

Write a MongoDB query using db.books.find() to find all books where the price field is less than 13. Store the result in a variable called affordableBooks.

MongoDB

db.books.insertMany([
  { title: 'The Great Gatsby', author: 'F. Scott Fitzgerald', price: 10 },
  { title: '1984', author: 'George Orwell', price: 15 },
  { title: 'To Kill a Mockingbird', author: 'Harper Lee', price: 12 }
])

const authorName = 'George Orwell';

const booksByAuthor = db.books.find({ author: authorName });

// Query books priced less than 13
// Your code here

Hint

Use { price: { $lt: 13 } } inside find() to filter by price less than 13.

Practice

1. Why is querying essential when working with a MongoDB database?

easy

A. It automatically fixes errors in the database.

B. It deletes all data from the database.

C. It helps find specific data quickly and efficiently.

D. It creates new databases without user input.

Solution

1. Step 1: Understand the purpose of querying

   Querying is used to search and retrieve specific data from a database.

2. Step 2: Identify the correct benefit of querying

   Querying helps users find data quickly and efficiently, not to delete or fix data automatically.

3. Final Answer:

   It helps find specific data quickly and efficiently. -> Option C

4. Quick Check:

   Querying = Find data fast [OK]

Hint: Queries help you get only the data you want fast [OK]

Common Mistakes:

• Thinking querying fixes database errors automatically
• Confusing querying with deleting data
• Believing querying creates databases

2. Which of the following is the correct MongoDB query syntax to find all documents in a collection named users?

easy

A. db.users.find()

B. db.users.get()

C. db.users.search()

D. db.users.select()

Solution

1. Step 1: Recall MongoDB query syntax for fetching documents

   The correct method to retrieve documents is find().

2. Step 2: Check each option's method name

   Only find() is valid; others like get(), search(), and select() are invalid in MongoDB.

3. Final Answer:

   db.users.find() -> Option A

4. Quick Check:

   Find method = db.collection.find() [OK]

Hint: Use .find() to get documents from a collection [OK]

Common Mistakes:

• Using .get() or .search() instead of .find()
• Forgetting parentheses after find
• Confusing SQL syntax with MongoDB

3. Given the collection products with documents:

{"name": "Pen", "price": 5}

{"name": "Notebook", "price": 15}

{"name": "Eraser", "price": 3}

What will the query db.products.find({ price: { $gt: 4 } }) return?

medium

A. []

B. [{"name": "Eraser", "price": 3}]

C. [{"name": "Notebook", "price": 15}]

D. [{"name": "Pen", "price": 5}, {"name": "Notebook", "price": 15}]

Solution

1. Step 1: Understand the query filter

   The query filters documents where price is greater than 4.

2. Step 2: Check each document's price

   Pen (5) and Notebook (15) have prices > 4; Eraser (3) does not.

3. Final Answer:

   [{"name": "Pen", "price": 5}, {"name": "Notebook", "price": 15}] -> Option D

4. Quick Check:

   Price > 4 returns Pen and Notebook [OK]

Hint: Look for documents matching the filter condition carefully [OK]

Common Mistakes:

• Including documents with price equal to 4
• Selecting documents with price less than 4
• Misunderstanding $gt operator

4. What is wrong with this MongoDB query to find users older than 25?
db.users.find({ age: > 25 })

medium

A. The query is missing a closing parenthesis.

B. The comparison operator > is used incorrectly inside the query object.

C. The find() method cannot filter by age.

D. The collection name should be in quotes.

Solution

1. Step 1: Analyze the query syntax

   The query uses age: > 25, which is invalid syntax in MongoDB.

2. Step 2: Identify correct operator usage

   MongoDB requires operators like $gt inside an object: { age: { $gt: 25 } }.

3. Final Answer:

   The comparison operator > is used incorrectly inside the query object. -> Option B

4. Quick Check:

   Use $gt for greater than in queries [OK]

Hint: Use $gt, not >, inside query objects [OK]

Common Mistakes:

• Using > directly instead of $gt
• Putting collection name in quotes unnecessarily
• Assuming find() can't filter by fields

5. You have a collection orders with documents containing status and total. How would you write a query to find all orders with status "shipped" and total greater than 100?

hard

A. db.orders.find({ status: "shipped", total: { $gt: 100 } })

B. db.orders.find({ status: { $eq: "shipped" }, total: > 100 })

C. db.orders.find({ status == "shipped" && total > 100 })

D. db.orders.find({ status: "shipped" || total: { $gt: 100 } })

Solution

1. Step 1: Understand the query conditions

   We want orders where status equals "shipped" AND total is greater than 100.

2. Step 2: Check correct MongoDB syntax for AND conditions

   MongoDB treats multiple fields in the query object as AND conditions. Use { status: "shipped", total: { $gt: 100 } }.

3. Final Answer:

   db.orders.find({ status: "shipped", total: { $gt: 100 } }) -> Option A

4. Quick Check:

   Multiple fields = AND in MongoDB queries [OK]

Hint: Use multiple fields in find() for AND conditions [OK]

Common Mistakes:

• Using > instead of $gt inside query
• Using == or && which are invalid in MongoDB queries
• Using || which means OR, not AND