Why advanced updates matter in MongoDB - See It in Action

Why Advanced Updates Matter in MongoDB

📖 Scenario: You are managing a small online bookstore database using MongoDB. You want to update book records efficiently without replacing entire documents. This helps keep your data accurate and your database fast.

🎯 Goal: Build a MongoDB update operation that changes specific fields in book documents using advanced update operators.

📋 What You'll Learn

Create a collection called books with three book documents having fields title, author, and copies_sold.

Add a variable minCopiesSold set to 1000 to use as a threshold.

Use the $inc operator to increase copies_sold by 500 for books with copies_sold greater than or equal to minCopiesSold.

Use the $set operator to add a new field bestseller set to true for those updated books.

💡 Why This Matters

🌍 Real World

Online stores and content platforms often need to update parts of their data quickly without rewriting entire records. Advanced updates let them do this efficiently.

💼 Career

Database developers and administrators use advanced update operators daily to maintain data accuracy and optimize performance in real applications.

1

Create the books collection with initial data

Create a MongoDB collection called books and insert these three documents exactly: { title: 'Learn MongoDB', author: 'Alice', copies_sold: 1200 }, { title: 'Node.js Basics', author: 'Bob', copies_sold: 800 }, and { title: 'Advanced MongoDB', author: 'Charlie', copies_sold: 1500 }.

MongoDB

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

Need a hint?

Use db.books.insertMany([...]) with the exact documents inside the array.

2

Add the minCopiesSold threshold variable

Create a variable called minCopiesSold and set it to 1000. This will be used to select books with enough sales.

MongoDB

db.books.insertMany([
  { title: 'Learn MongoDB', author: 'Alice', copies_sold: 1200 },
  { title: 'Node.js Basics', author: 'Bob', copies_sold: 800 },
  { title: 'Advanced MongoDB', author: 'Charlie', copies_sold: 1500 }
])

// Create minCopiesSold variable
// Your code here

Need a hint?

Use const minCopiesSold = 1000 to create the variable.

3

Use $inc to increase copies_sold for popular books

Write a MongoDB update command that uses $inc to add 500 to copies_sold for all books where copies_sold is greater than or equal to minCopiesSold.

MongoDB

db.books.insertMany([
  { title: 'Learn MongoDB', author: 'Alice', copies_sold: 1200 },
  { title: 'Node.js Basics', author: 'Bob', copies_sold: 800 },
  { title: 'Advanced MongoDB', author: 'Charlie', copies_sold: 1500 }
])

const minCopiesSold = 1000

// Update copies_sold by adding 500 for books with copies_sold >= minCopiesSold
// Your code here

Need a hint?

Use db.books.updateMany with a filter on copies_sold and the $inc operator.

4

Add bestseller field with $set for updated books

Extend the previous update command to also use $set to add a new field bestseller set to true for the same books where copies_sold was increased.

MongoDB

db.books.insertMany([
  { title: 'Learn MongoDB', author: 'Alice', copies_sold: 1200 },
  { title: 'Node.js Basics', author: 'Bob', copies_sold: 800 },
  { title: 'Advanced MongoDB', author: 'Charlie', copies_sold: 1500 }
])

const minCopiesSold = 1000

db.books.updateMany(
  { copies_sold: { $gte: minCopiesSold } },
  { $inc: { copies_sold: 500 }, $set: { bestseller: true } }
)

// Your code here

Need a hint?

Combine $inc and $set inside the same update document.