The Ultimate MongoDB Aggregation Guide: Make Your Queries Soar in One Video

🟡 Get 1 to 1 coaching with me: topmate.io/eng...
🟡 Donate: paypal.me/engi...
🟡 Perks: www.youtube.co...
🔴 Discord: / discord
🔴 Twitch: / engineeringdigest
🔴 Personal KZbin Channel: / @thevipulvats
🔴 Instagram: / thevipulvats
🔴 Twitter: / thevipulvats
🔴 LinkedIn: / thevipulvats
🔴 Website: engineeringdig...
🔴 Video summary
This video is a comprehensive guide to MongoDB aggregation, where you'll learn how to use various aggregation operators to process data stored in MongoDB collections. You'll see how to use these operators to perform various data processing tasks such as filtering, transforming, grouping and summarizing data. The video aims to help you make the most out of your MongoDB queries, allowing you to extract insights and aggregate data more effectively. By the end of the video, you'll be equipped with the skills to confidently perform complex data processing tasks in MongoDB.
🔴 Timestamps
Intro 0:00

[@EngineeringDigest]

Use this as sample data, it is not the same. But will do the work db.teachers.insertMany([ { "_id": 1, "name": "John Doe", "age": 35, "gender": "male" }, { "_id": 2, "name": "Jane Smith", "age": 40, "gender": "female" }, { "_id": 3, "name": "Michael Johnson", "age": 45, "gender": "male" }, { "_id": 4, "name": "Emily Williams", "age": 30, "gender": "female" }, { "_id": 5, "name": "Robert Brown", "age": 38, "gender": "male" }, { "_id": 6, "name": "Emma Jones", "age": 33, "gender": "female" }, { "_id": 7, "name": "William Davis", "age": 37, "gender": "male" }, { "_id": 8, "name": "Olivia Miller", "age": 41, "gender": "female" }, { "_id": 9, "name": "David Wilson", "age": 36, "gender": "male" }, { "_id": 10, "name": "Sophia Moore", "age": 32, "gender": "female" }, { "_id": 11, "name": "Richard Taylor", "age": 39, "gender": "male" }, { "_id": 12, "name": "Isabella Anderson", "age": 43, "gender": "female" }, { "_id": 13, "name": "Joseph Thomas", "age": 34, "gender": "male" }, { "_id": 14, "name": "Mia Jackson", "age": 42, "gender": "female" }, { "_id": 15, "name": "Charles White", "age": 36, "gender": "male" }, { "_id": 16, "name": "Abigail Harris", "age": 31, "gender": "female" }, { "_id": 17, "name": "Daniel Martin", "age": 44, "gender": "male" }, { "_id": 18, "name": "Evelyn Thompson", "age": 38, "gender": "female" }, { "_id": 19, "name": "Matthew Garcia", "age": 37, "gender": "male" }, { "_id": 20, "name": "Sofia Martinez", "age": 35, "gender": "female" }, { "_id": 21, "name": "Andrew Robinson", "age": 40, "gender": "male" }, { "_id": 22, "name": "Grace Clark", "age": 33, "gender": "female" }, { "_id": 23, "name": "Joshua Rodriguez", "age": 39, "gender": "male" }, { "_id": 24, "name": "Avery Lewis", "age": 42, "gender": "female" }, { "_id": 25, "name": "Christopher Lee", "age": 37, "gender": "male" }, { "_id": 26, "name": "Chloe Walker", "age": 31, "gender": "female" }, { "_id": 27, "name": "Kevin Hall", "age": 44, "gender": "male" }, { "_id": 28, "name": "Zoey Allen", "age": 38, "gender": "female" }, { "_id": 29, "name": "Brian Young", "age": 36, "gender": "male" }, { "_id": 30, "name": "Harper King", "age": 34, "gender": "female" } ])

[@swapnilw.]

thank you for this document.

[@datastructuresandalgorithm9370]

Thank you for it.

[@sushilingole8448]

Thank youu...

[@poojagarva]

Your MongoDB playlist is absolutely fantastic! Your tutorials and explanations make it so easy to understand and follow. I've been searching for a reliable resource to learn MongoDB, and your playlist makes it easier for me to apply what I've learned to my own projects.

[@EngineeringDigest]

Thanks, this comment made my day :)

[@anshulsharma9424]

Sir all of you content is a gold mine for developers.

[@maullikakbari8200]

one of the best aggregation tutorial available on youtube till now thank you sir.

[@fatimaiqra2169]

thanks a lot for such a deeper explanation!

[@manojmohapatra986]

Working as a developer from last 4 yrs but i didnt know some operators even exists.. thank you for your support . Watching your videos is like bliss af🎉

[@EngineeringDigest]

Welcome aboard! 😀

[@Rajugupta-gp2eg]

Awaiting next video !!

[@EngineeringDigest]

Thanks bro, Please support us by sharing the channel with your colleagues 🤝

[@nobitaa32]

Op sir first time aaya hu kya hi technique he aapki padhaneki

[@tanmaychavan743]

Just please never stop making such amazing videos ❤❤

[@DilipBoidya-bb3be]

I like your accent, your explanations and so i subscribed you. Keep posting more vids.

[@naimhasan5346]

Bhai you are the best! Your teaching style is so unique and interesting. I love it ❤

[@EngineeringDigest]

Thank you so much 😀

[@mohdshahnawaz5047]

very good sir.

[@DevilDoer9224]

Great video no doubt but at 31:50 I am getting output as [ { _id: null, avgS: null } ] and my query is db.students.aggregate([{$group:{_id:null, avgS:{ $avg:{ $filter:{ input:"$scores",as:"score",cond:{ $gt: ["$score",12]}}}}}}]). What could be wrong? And this is what Chatgpt says "The problem with your query is that the $filter operator is being used in a way that doesn't make sense for calculating the average of the scores for students older than 12. Specifically: Incorrect Use of $filter: The $filter operator is intended to filter elements within an array, but you are using it to compare age, which is not an array element. Invalid Condition: The condition {$gt:["$age",12]} inside $filter is intended to filter array elements based on a property of the array elements themselves, but age is a top-level document field, not a property within the scores array."

[@farukkhan6324]

hey man awesome video loved they way you explain waiting for more videos. keep it up

[@EngineeringDigest]

Thanks a ton!

[@abuzubaer3083]

nice explanation

[@rahulmk8698]

Hello Sir, Can you share your docs with us?

[@foodistan9311]

Please do a video on $lookup as well. BTW a great explanation.

[@EngineeringDigest]

Will do soon, Please support us by joining on Instagram or Discord 🙂

[@foodistan9311]

@@EngineeringDigest Please. waiting for so long

[@manojmohapatra986]

Dont know on the area you expertise on. But if you create some playlist on devops (as not much good resourse available) , gcp , aws etc. trust me uh ll be unbeatable. Mark my words

[@explorewithsatish1208]

You doing awesome job do it continue 👌🎉❤️

[@EngineeringDigest]

Thank you so much 😁

[@jyotshnamanjari2372]

You are wonderful. Can you please explain $reduce? Also can you please include datetime in your examples.

[@cruzcreez65]

Unique way of teaching.. no boringness ❤❤🎉🎉

[@shashankjain4024]

Informational video. Thanks. However should work on your tone and extra modulation. It breaks the learning rhythm for the audience.

[@EngineeringDigest]

That's why it is free

[@raiyanabdurrehman1411]

Awesome Video..BTW any idea why the last problem's solution showing avgScores as null??

[@OCEMTechZone]

Great🎉

[@InzamamMalik]

Love you bro, being technical matters but you have got god gifted teaching skill along with technical competency. always spare some of your time for teaching. found your video very helpful and will recommend to others for sure. no click bate no gimmicks pure knowledge with nicely organised flow.

[@EngineeringDigest]

Thanks a ton bro

[@Itsfayss]

thanks man : )

[@mithilesh8349]

Problem statement : In a Json file or Mongo there is an Object contains Company name and Gender, You Have to find the count of female and male in a seperate column for each company. ex: Company Male female A 22 10 B 20 18 C 10 30

[@mithilesh8349]

Help me to write the aggregation for better understanding

[@mikeplai4189]

const employees = await Employee.aggregate([ { $group: { _id: { companyName: "$companyName", gender: "$gender" }, count: { $sum: 1 }, }, }, { $project: { _id: 0, companyName: "$_id.companyName", gender: "$_id.gender", count: 1, }, }, ]);

[@kishankumar-ze5pf]

most underrated channel

[@lifeusa2168]

Your videos are really awesome. I have one question How can we use two ids while grouping? Is it possible if yes then how. Can you please explain?

[@abhishekbisht3264]

Bhaiya meine mongo db abhi start kara hai kuch tips dedo jisse mein issey achhe se seekh jaaun

[@shashanksingh4708]

can you do a video on these complex queries implemented using spring data mongoDB ?

[@vampirekabir]

cant get it why 44 psychos disliked this such legendary video,absolutely fabulous, amazing

[@vinitph]

sir can you share your notes with us i would be very grateful

[@AdarshSingh-mo1kc]

his voice🔥🔥🔥🔥

[@memekannada2901]

benifitted so much from this playlist..appreciate you sir!!

[@EngineeringDigest]

Most welcome!

[@SparkYourMindConnections]

Best Video on internet❤‍🔥 Maza agya

[@EngineeringDigest]

Thanks 🙏 Consider joining our discord or Instagram.

[@rajd2990]

Amazing 👍👍

[@EngineeringDigest]

Thanks! 😊 Join my Insta fam if u haven’t already: @thevipulvats

[@harsh__dev]

Sir please provide the pdf/cheat sheet as well. By the way love your lectures

[@mikeplai4189]

great explaination but need more videos on aggregation with join collections

[@EngineeringDigest]

Will upload soon

[@mikeplai4189]

@@EngineeringDigest Thanks

[@parmaryash4406]

Finally found great video for mongodb aggregation queries, really thank you so much

[@SachinGupta-iy3sz]

Hey, Is there any platform available where we can practice mongodb queries.

[@EngineeringDigest]

Check last video of the playlist

[@MohammedHasmi577]

Bhai tum reels me dikhte ho vohi hona? Love your videos ❤🎉

[@varunjaiswar5062]

sir data dal te dal te , fatt gai mere , please provide data in description.

[@kunal_Jangra]

Plz provide this data you are using we can practice by using it

[@EngineeringDigest]

done, check pinned comment

[@UsamaArif-c4l]

if two student have same age and same hobbies then what will be output?

[@EngineeringDigest]

friendship

[@Mehuldeveloper]

Bro, can you help me? I'm working with a MongoDB database with 5 million records. When I fetch the total count based on sum or query, the query execution is becoming very slow.

[@EngineeringDigest]

Watch indexing video in this playlist

[@Mehuldeveloper]

i've watched your video on indexing and have applied the techniques but due to large data collection giving same result is there any other techniques ? @@EngineeringDigest

[@khawajamuhammadmushood5455]

can someone explain me the use of dollar sign in aggregate quries

[@EngineeringDigest]

it means you are going to use reserved keyword ( operator )

[@ashwinchaudhary5730]

Awesome explaination with multiple examples, thanks

[@JonayedAhamad-m5n]

Subscribed, Your teaching style is something unique😊😊

[@vivekkumaryadav9862]

thanks bhaiya ji...ek video or aggregation completed ...:))

[@EngineeringDigest]

Please consider sharing feedback on LinkedIn. 🙏🏻

[@ShubhiK-ro8cl]

Last query with filter is not working. Please add correct query here.

[@EngineeringDigest]

ok sir

[@ShubhiK-ro8cl]

No srsly.... it's returning null😶

[@farhanakhtar5229]

bhai ne news anchor ki job chod kar coder bana he

[@shubhamgupta-bl1tr]

nice video, transaction r bhi bha dijiye

[@EngineeringDigest]

Sure

[@nemotivity]

Loved the video. Waiting for the next one. Keep making such awesome tutorials. ♥

[@EngineeringDigest]

Thanks a lot 😊

[@03devrajtak7]

how to use indexing for aggregation pipeline?

[@noedition1968]

Such a beautiful information for mongodb pipeline. Thanks a lot for this valuable video ❤

[@SawanKumar-tr9xz]

Best mongodb playlist ❤

[@EngineeringDigest]

Thanks! 😊 Join my Insta fam: @thevipulvats

[@sohammehta6614]

Thank your very much for the great explanation!!

[@random2059]

👋👋🙏🙏 _id kaise age ho sakta hai id to id hai , ( _id:"$age") age acting like _id keya ho rah hai inha pe thora samjhaye , please clear this confusion ???👋👋🙏🙏 thora dhundne par pata chala isko accumulator object bolte hai .... thora ispe v batye .. please reply

[@EngineeringDigest]

05:19

[@random2059]

@@EngineeringDigest samjha to ye _id uo wala _id nahi nahi hai ye ac new _id banrahe ho age ke basis pea ? 🙏🙏🙏🙏 bata please do maine full video dekha hai note v bana raha hu .... mujhe 5:19 thora samaj nahi aya sir

[@preetilangayan6326]

Please make video on replication also.

[@moosegoose1282]

speak english

[@dhriteshkumar1786]

awesome explanation sir ❤

[@EngineeringDigest]

Thanks for liking

[@stiphenrobert4469]

Best mongodb tutorial on earth

[@sadotore]

vai, a big "THANK YOUUU" for u

[@KhushaliChauhan-o1b]

wow...its very first time ,I am watching your videos but really....its awesome your way to convey the concept is literally different from other ..

[@EngineeringDigest]

Thanks😀

[@VivekYadav-up7uu]

easy and effective way to explain.

[@ihtshamhaider6849]

wow method

[@EngineeringDigest]

Many many thanks

[@mahirjain5833]

Love your tutorials.Pls cover entire mongo db.

[@prathameshhiremath1379]

Bhai really apka voice bahut katarnak hai

[@EngineeringDigest]

Thanks :)

[@vaishalimandora8956]

Sir is your playlist is sufficient to learn mongodb ...as a node js developer

[@EngineeringDigest]

It will help you to query the database directly and basic understanding of mongodb. Then you have to learn mongoose which makes node js to connect and query the database.

[@taukirkhan3417]

Mza agya bro, enjoy and completely understand. Thanks

[@EngineeringDigest]

Thank you brother, it will be a huge help if you can share this course on LinkedIn.

[@shamimsarker839]

Best 🔥🔥🔥🔥🔥🔥🔥

[@arnavkaul7827]

Damn good lecture

[@mahirnasirbaghila9051]

Sir you are great

[@pritimodanwal06]

very nice explain bro, before it i have little bit confusion regarding pipeline now clear thank you bro

[@EngineeringDigest]

You are welcome

[@vampirekabir]

bro video on $facet and $bucket pls

[@EngineeringDigest]

just recorded, will upload next week

[@vampirekabir]

@@EngineeringDigest thanks, i always look for ur explanation teach in such clear and fun way

[@harshmehta1141]

Bro Engineering Digest very unique and attractive name

[@EngineeringDigest]

Thanks 🙏

[@code-with-me-2002]

bro college teacher ki taraha , line by line padhke hindi translate mat karo

[@EngineeringDigest]

karunga

[@ronakreddy8657]

@Music-ub2gc car racing krle tu.. galat jagah aa gya bodam

[@ummeed4365]

Excellent content bhai highly appreciate your efforts.

[@EngineeringDigest]

Thanks! 😊 You can join our discord or Insta @thevipulvats.

[@cyrusthapa794]

bhaut hard XD : ) ❤‍🔥

[@zeeshankalyar7693]

Thanks bhai jaan bahut hi achi video bnae hai apne

[@rajverma5051]

Thank you sir ❤

[@ShekharTayde-j3k]

Bachpan me hum padhte the ..... 😆..Amazing videos bhai..helped alot.

[@EngineeringDigest]

Thanks 😀 *Instagram:* instagram.com/thevipulvats *Discord:* discord.gg/7e6WdBJ9dT

[@mikeplai4189]

kamal

[@IftekharAhmed-f3r]

Fantastic, I learned a lot today

[@AnilKumar-fw8bw]

Thank you for explaining in a simple way.

[@abhijeetkumarsingh2504]

You Got A Subscriber, loved the way you explain 😂 🔥

[@EngineeringDigest]

Welcome aboard!😀

[@SonuKumar-uq2rb]

kuch samaj ni aaya bekaar vedio.

[@EngineeringDigest]

video*

[@codecracker8856]

​@@EngineeringDigestsir can u please provide notes ?

[@anandatole6529]

explain in simple way. no complex. Thanks

[@EngineeringDigest]

Glad you liked it!

[@swapnilw.]

i think u r from delhi😎

[@EngineeringDigest]

Yess 🤓

[@aafibaloch654]

Deserve more views and subscribers ❤

[@EngineeringDigest]

Thanks! 😊 Join my Insta fam: @thevipulvats

[@JaiSreeRam466]

Super anna ❤

[@EngineeringDigest]

Thanks! 😊 Join my Insta fam if u haven’t already: @thevipulvats

[@mithleshkumar-ds9ex]

Sir Please database link

[@watchprakhar]

achcha samjhaya bhai apne

[@watchprakhar]

subscribed

[@EngineeringDigest]

Thanks! 😊 Join my Insta fam if u haven’t already: @thevipulvats

[@sksayrilamed4087]

aap ka smjhana acha hay but behavior thora accha kariya bate thora dhang say koriya bohot karush lagata hay ..lakin apnay best aggregation concept samjaya hay .-__-

[@EngineeringDigest]

bhai khadoos hi hu mai..real life me bhi😅

[@datastructuresandalgorithm9370]

For last filter [ { "name": "Vinay", "age": 34, "scores": [22, 33, 4, 44, 55] }, { "name": "Alice", "age": 28, "scores": [10, 20, 30, 40, 50] }, { "name": "Bob", "age": 42, "scores": [15, 25, 35, 45, 55] }, { "name": "Emma", "age": 31, "scores": [18, 28, 38, 48, 58] }, { "name": "Chris", "age": 37, "scores": [12, 22, 32, 42, 52] }, { "name": "Sophia", "age": 29, "scores": [25, 35, 45, 55, 65] }, { "name": "David", "age": 36, "scores": [30, 40, 50, 60, 70] }, { "name": "Linda", "age": 45, "scores": [8, 18, 28, 38, 48] }, { "name": "Michael", "age": 27, "scores": [16, 26, 36, 46, 56] }, { "name": "Emily", "age": 33, "scores": [5, 15, 25, 35, 45] } ]

[@shivamkatiyar2899]

Cool way of teaching.

[@datastructuresandalgorithm9370]

db.scoreDta.aggregate([{$group:{_id:null,avgScore:{$avg:{$filter:{input:"$scores" , as:"score",cond:{$gt:["$age",30]}}}}}}]);

[@ShubhiK-ro8cl]

Is it working for u?

[@manikanth.8507]

​@@ShubhiK-ro8clLast time it was working.

[@kaushikprajapati5540]

@@manikanth.8507 Last time it was working