M101N MongoDB for .NET

I just finished the online course M101N MongoDB for .NET and I really enjoyed it. They combine short videos and a quiz after them checking you understood the explanation. There is also homework every week and a final exam. I recommend it to every developer who wants to get to know this famous NoSQL database.

There are also another possible courses such as:

  • MongoDB for Java developers
  • MongoDB for Node.js developers
  • MongoDB for DBAs

Querying in MongoDB is with JavaScript and it takes some time to set your mind to use it instead of SQL. I’ll leave your with some SQL statements and the equivalent in MongoDB:

Simple query

SELECT *
FROM users
db.users.find()

Filter

SELECT *
FROM users
WHERE age > 25
AND   age <= 50
db.users.find(
   { age: { $gt: 25, $lte: 50 } }
)

Filter and order

SELECT *
FROM users
WHERE status = "A"
ORDER BY user_id DESC
db.users.find( { status: "A" } ).sort( { user_id: -1 } )