MongoDB Full Real-World Project Practice (Complete Challenge)

---

🧩 MongoDB Practice Series – Full Real-World Project Challenge (Part 8)

← Go to Previous

Welcome to Part 8 of the MongoDB Practice Series.

This is a real-world project practice where you will combine everything you learned:

• CRUD operations
• Filtering
• Sorting
• Aggregation
• Schema design
• Indexing

This challenge simulates building a real application database.

---

🚀 Project: Online Learning Platform Database

You are designing a database for an online learning website.

The system must manage:

• Users (students)
• Courses
• Enrollments
• Payments

🟢 Step 1: Design the Schema

Problem:
Design collections for the system.

Solution Example:

// Users Collection
{
  _id: 1,
  name: "Amit",
  email: "amit@example.com",
  country: "India"
}

// Courses Collection
{
  _id: 101,
  title: "MongoDB Basics",
  price: 1500,
  category: "Database"
}

// Enrollments Collection
{
  _id: 5001,
  user_id: 1,
  course_id: 101,
  enrollmentDate: new Date()
}

// Payments Collection
{
  _id: 9001,
  user_id: 1,
  amount: 1500,
  paymentStatus: "Completed"
}

Learning Goal: Understand when to use referencing for scalability.

---

🟡 Step 2: Basic Operations

Task:

• Insert 5 users
• Insert 5 courses
• Create enrollments

Practice: Use insertMany() for efficiency.

---

🔵 Step 3: Real-World Queries

✔ Find all courses in a category

db.courses.find({ category: "Database" })

✔ Find users from India

db.users.find({ country: "India" })

✔ Show latest enrollments

db.enrollments.find()
  .sort({ enrollmentDate: -1 })
  .limit(5)

---

🟣 Step 4: Aggregation Practice

✔ Count total enrollments per course

db.enrollments.aggregate([
  {
    $group: {
      _id: "$course_id",
      totalEnrollments: { $sum: 1 }
    }
  }
])

✔ Calculate total revenue

db.payments.aggregate([
  {
    $match: { paymentStatus: "Completed" }
  },
  {
    $group: {
      _id: null,
      totalRevenue: { $sum: "$amount" }
    }
  }
])

---

🔴 Step 5: Performance Optimization

Create indexes for better performance:

// Faster user search
db.users.createIndex({ email: 1 })

// Faster enrollment lookup
db.enrollments.createIndex({ user_id: 1 })

// Faster course filtering
db.courses.createIndex({ category: 1 })

Learning Goal: Improve query performance in large systems.

---

🎯 Final Challenge (Capstone Task)

Design a reporting query that:

• Finds total revenue per course
• Sorts courses by highest revenue
• Returns only top 3 courses

Try solving it by combining:

• $group
• $sort
• $limit

This is a real interview-level challenge.

---

🏆 Congratulations!

If you completed all 8 parts of this MongoDB Practice Series, you now understand:

• CRUD
• Filtering
• Sorting
• Pagination
• Aggregation
• Schema Design
• Indexing
• Real-world database design

You are now ready to build real MongoDB applications.

← Previous Next →

MongoDB Indexing and Performance Optimization Practice

---

🧩 MongoDB Practice Series – Indexing & Performance Challenges (Part 7)

← Previous Next →

Welcome to Part 7 of the MongoDB Practice Series.

In this lesson, you will learn how to improve query performance using indexes.

Indexes help MongoDB find data faster, especially in large collections.

---

🟢 Exercise 1: Create a Simple Index

Problem:
Create an index on the email field in the users collection.

Solution:

db.users.createIndex({ email: 1 })

Learning Goal: Improve search performance on email queries.

---

🟡 Exercise 2: Find All Indexes

Problem:
Check which indexes exist in the products collection.

Solution:

db.products.getIndexes()

Learning Goal: Understand existing indexing structure.

---

🟡 Exercise 3: Remove an Index

Problem:
Remove the index on the price field.

Solution:

db.products.dropIndex({ price: 1 })

Learning Goal: Learn how to manage indexes properly.

---

🔵 Exercise 4: Create a Compound Index

Problem:
Create an index on both category and price fields.

Solution:

db.products.createIndex({ category: 1, price: -1 })

Learning Goal: Understand compound indexes for multi-field queries.

---

🔵 Exercise 5: Optimize a Slow Query

Problem:
The following query is slow:

db.orders.find({ customerName: "Amit" })

Task:
Improve its performance.

Solution:

db.orders.createIndex({ customerName: 1 })

Learning Goal: Use indexing to speed up frequently searched fields.

---

🔴 Exercise 6: Use Explain Plan

Problem:
Check how MongoDB executes a query.

Solution:

db.products.find({ price: { $gt: 1000 } }).explain("executionStats")

Learning Goal: Analyze query performance using explain.

---

🚀 Mini Challenge

You have a large users collection with millions of records.

Design indexes for the following queries:

• Search users by email
• Filter users by country
• Sort users by registration date

Think carefully:

• Should you use single-field or compound indexes?
• Which field is searched most frequently?

Try designing the indexing strategy before checking any solution.

---

🎯 What’s Next?

In Part 8 of the MongoDB Practice Series, we will practice:

• Real-world mini project challenges
• Complete database design scenarios
• Combining CRUD + Aggregation + Indexing

Stay tuned for the final advanced practice level!

← Previous Next →