MongoDB read skills — find filters, projection, sort, and aggregation including $lookup on a shared practice database.
- Duration
- 12 weeks
- Certificates
- 3
- CO threshold
- 75–80%
- Price
- ₹5,000 (one-time access)
Tagline: MongoDB read skills — find filters, projection, sort, and aggregation including $lookup on a shared practice database.
| Field |
Value |
| Course code |
MG-QUERY-A |
| Duration |
12 weeks |
| Credits |
3 |
| Compliance |
NBA-aligned OBE |
| Publication |
published |
| Price |
INR 5000 |
| DB snapshot |
2026-10-08T15:04:28.516Z |
Course objective
Build reliable MongoDB read skills—find filters, projection, sort, and aggregation pipelines including $lookup—on the shared practice_db sandbox, with indexes/explain taught for read-path judgment and writes taught for safety awareness only (no graded mutations in v1).
Course outcomes (CO1–CO6)
| CO |
Bloom |
Weight |
Statement |
| CO1 |
understand |
12% |
Explain documents, collections, BSON types, and when document stores fit vs relational tables. |
| CO2 |
apply |
20% |
Write correct find queries with equality, comparison, logical operators, and projection. |
| CO3 |
apply |
18% |
Sort, limit/skip, and shape results; use array and embedded-document operators ($in, $elemMatch, dot notation, etc.). |
| CO4 |
apply |
20% |
Build aggregation pipelines using $match, $project/$addFields, $group, $sort, $limit/$skip, and $count. |
| CO5 |
analyze |
20% |
Combine collections with $lookup, unwind arrays, and build multi-stage reporting pipelines ($facet, conditional/date patterns as needed). |
| CO6 |
analyze |
10% |
Choose sensible indexes for common read patterns; read explain output; recognize common read-path anti-patterns. |
Activity totals (live from platform)
| Metric |
Count |
| Units / chapters |
14 |
| Topics |
58 |
| Topic quiz activities |
351 |
| MCQ questions |
351 |
| MongoDB practice queries |
0 |
| Evaluated MongoDB query labs |
346 |
Certificates & earning criteria
| Certificate |
CO scope |
Evaluated lab quota |
CO attainment |
Gate |
| MongoDB Query Foundations |
CO1–CO3 |
≥ 85% |
≥ 75% |
Foundations summative quiz |
| MongoDB Query Professional |
CO1–CO6 |
≥ 90% |
≥ 75% |
Professional EOC |
| MongoDB Query Mastery |
CO1–CO6 |
≥ 95% |
≥ 80% |
Professional EOC (Mastery) |
Unit syllabus (unit → topics → activities)
Unit 1 — Foundations — documents & the practice DB
Unit totals: 7 topics · 42 MCQ questions · 0 practice · 0 evaluated labs
| # |
Topic |
MCQs |
Practice |
Evaluated |
Preview |
| 1 |
Documents vs rows — collections vs tables |
6 |
0 |
0 |
Yes |
| 2 |
BSON types in practice_db |
6 |
0 |
0 |
— |
| 3 |
When document stores fit (and when SQL wins) |
6 |
0 |
0 |
— |
| 4 |
Why MongoDB — and how this course works |
6 |
0 |
0 |
— |
| 5 |
practice_db tour |
6 |
0 |
0 |
— |
| 6 |
Execution rules — read-only student_user |
6 |
0 |
0 |
— |
| 7 |
Autograder JSON shape (find / aggregate) |
6 |
0 |
0 |
— |
Unit 2 — find basics — equality, projection, sort
Unit totals: 4 topics · 24 MCQ questions · 0 practice · 48 evaluated labs
| # |
Topic |
MCQs |
Practice |
Evaluated |
Preview |
| 1 |
Equality filters |
6 |
0 |
12 |
— |
| 2 |
Projection — include and exclude |
6 |
0 |
12 |
— |
| 3 |
Sort, limit, and skip |
6 |
0 |
12 |
— |
| 4 |
Combining equality, projection, and sort |
6 |
0 |
12 |
— |
Unit 3 — Comparison & logical filters
Unit totals: 4 topics · 24 MCQ questions · 0 practice · 48 evaluated labs
| # |
Topic |
MCQs |
Practice |
Evaluated |
Preview |
| 1 |
Comparison operators |
6 |
0 |
12 |
— |
| 2 |
Logical operators |
6 |
0 |
11 |
— |
| 3 |
Combining comparison and logical filters |
6 |
0 |
13 |
— |
| 4 |
Common filter mistakes |
6 |
0 |
12 |
— |
Unit 4 — Existence, null, and type-aware queries
Unit totals: 4 topics · 24 MCQ questions · 0 practice · 48 evaluated labs
| # |
Topic |
MCQs |
Practice |
Evaluated |
Preview |
| 1 |
Missing fields vs null |
6 |
0 |
12 |
— |
| 2 |
$exists |
6 |
0 |
12 |
— |
| 3 |
Querying by BSON type with $type |
6 |
0 |
12 |
— |
| 4 |
Safe patterns for sparse documents |
6 |
0 |
12 |
— |
Unit 5 — Arrays & embedded documents
Unit totals: 4 topics · 24 MCQ questions · 0 practice · 48 evaluated labs
| # |
Topic |
MCQs |
Practice |
Evaluated |
Preview |
| 1 |
Dot notation into embedded documents |
6 |
0 |
12 |
— |
| 2 |
$elemMatch |
6 |
0 |
12 |
— |
| 3 |
Matching array values and sizes |
6 |
0 |
12 |
— |
| 4 |
Projecting fields from embedded documents |
6 |
0 |
12 |
— |
Unit 6 — Foundations checkpoint + summative
Unit totals: 3 topics · 20 MCQ questions · 0 practice · 30 evaluated labs
| # |
Topic |
MCQs |
Practice |
Evaluated |
Preview |
| 1 |
Mixed find review |
0 |
0 |
15 |
— |
| 2 |
Stretch find patterns |
0 |
0 |
15 |
— |
| 3 |
Foundations summative quiz |
20 |
0 |
0 |
— |
Unit 7 — Aggregation intro — match, project, sort, limit
Unit totals: 4 topics · 24 MCQ questions · 0 practice · 19 evaluated labs
| # |
Topic |
MCQs |
Practice |
Evaluated |
Preview |
| 1 |
Pipeline mental model |
6 |
0 |
4 |
— |
| 2 |
$match |
6 |
0 |
5 |
— |
| 3 |
$project and $addFields |
6 |
0 |
5 |
— |
| 4 |
$sort and $limit in pipelines |
6 |
0 |
5 |
— |
Unit 8 — Grouping & metrics
Unit totals: 4 topics · 24 MCQ questions · 0 practice · 20 evaluated labs
| # |
Topic |
MCQs |
Practice |
Evaluated |
Preview |
| 1 |
$group and _id shapes |
6 |
0 |
5 |
— |
| 2 |
Accumulators — $sum, $avg, $min, $max |
6 |
0 |
6 |
— |
| 3 |
$push and $addToSet (intro) |
6 |
0 |
5 |
— |
| 4 |
$count |
6 |
0 |
4 |
— |
Unit 9 — Array pipelines & unwind
Unit totals: 4 topics · 24 MCQ questions · 0 practice · 19 evaluated labs
| # |
Topic |
MCQs |
Practice |
Evaluated |
Preview |
| 1 |
$unwind |
6 |
0 |
5 |
— |
| 2 |
$filter and $map (intro) |
6 |
0 |
5 |
— |
| 3 |
Reporting from array fields |
6 |
0 |
5 |
— |
| 4 |
Document explosion pitfalls |
6 |
0 |
4 |
— |
Unit 10 — Multi-collection reads — $lookup
Unit totals: 4 topics · 24 MCQ questions · 0 practice · 21 evaluated labs
| # |
Topic |
MCQs |
Practice |
Evaluated |
Preview |
| 1 |
Equi-join style $lookup |
6 |
0 |
6 |
— |
| 2 |
Pipeline form of $lookup |
6 |
0 |
5 |
— |
| 3 |
When not to $lookup |
6 |
0 |
4 |
— |
| 4 |
Multi-collection reporting |
6 |
0 |
6 |
— |
Unit 11 — Advanced reporting patterns
Unit totals: 4 topics · 24 MCQ questions · 0 practice · 21 evaluated labs
| # |
Topic |
MCQs |
Practice |
Evaluated |
Preview |
| 1 |
$facet |
6 |
0 |
5 |
— |
| 2 |
$cond and $switch |
6 |
0 |
5 |
— |
| 3 |
Date grouping (intro) |
6 |
0 |
5 |
— |
| 4 |
Integrative reporting set |
6 |
0 |
6 |
— |
Unit 12 — Indexes & explain (read path)
Unit totals: 4 topics · 24 MCQ questions · 0 practice · 6 evaluated labs
| # |
Topic |
MCQs |
Practice |
Evaluated |
Preview |
| 1 |
Single-field indexes for filters |
6 |
0 |
0 |
— |
| 2 |
Compound indexes for filter + sort |
6 |
0 |
0 |
— |
| 3 |
Reading explain output |
6 |
0 |
4 |
— |
| 4 |
Read-path anti-patterns |
6 |
0 |
2 |
— |
Unit 13 — Writes & safety (instructional)
Unit totals: 4 topics · 24 MCQ questions · 0 practice · 0 evaluated labs
| # |
Topic |
MCQs |
Practice |
Evaluated |
Preview |
| 1 |
insertOne semantics |
6 |
0 |
0 |
— |
| 2 |
updateOne — $set vs replace |
6 |
0 |
0 |
— |
| 3 |
deleteOne and safety |
6 |
0 |
0 |
— |
| 4 |
Upsert concepts |
6 |
0 |
0 |
— |
Unit 14 — Capstone + Professional EOC
Unit totals: 4 topics · 25 MCQ questions · 0 practice · 18 evaluated labs
| # |
Topic |
MCQs |
Practice |
Evaluated |
Preview |
| 1 |
Integrative find labs |
0 |
0 |
6 |
— |
| 2 |
Integrative aggregate labs |
0 |
0 |
6 |
— |
| 3 |
Mixed reporting capstone |
0 |
0 |
6 |
— |
| 4 |
Professional EOC |
25 |
0 |
0 |
— |
Counts are from the live course catalog. MCQs = questions in topic checkpoint quizzes. Practice = formative run-only or SQL practice lane. Evaluated = submit-graded labs that count toward progress and certificates.
← All paid courses · LLM site guide