The Complete Dummies Guide for MongoDB and NoSQL Databases

Hello, and welcome to my new course 'The Complete Dummies Guide to MongoDB Server'. 

You already know that in this information technology age 'data' is everything. A Database is the place where this information is stored in tables. There are two types of databases. A structured database and also there is un-structured or no-sql kind of database. We will learn about the No-SQL kind of database and the most popular No-SQL database the Mongo DB Server in this course.

Course Overview:

In the first session, we will have an introduction to databases. Then we will see the concepts of SQL or Structured Query Language which is used in RDBMS in comparison with the No-SQL or non-RDBMS. 

In the next session, we will move on to the basics of the MongoDB server. We will see how we can install the MongoDB Community Edition into your computer and then we will download the MongoDB compass, which is a tool and the user interface. Also, we will install the MongoDB shell which is a command line interface. And later we will connect Compass and Mongosh with our MongoDB Server that is running in the background. 

And then we will move on with MongoDB basic operations. We will see how we can select a database, create a collection and insert documents into that collection. These will be done both through the command line as well as the graphical user interface.

In the next session, we will see more details about the MongoDB collections. We will Create, Show and Drop collections with various options.

Then we will get ourselves familiarized with the JSON and BSON formats which are used in Mongo DB. Then in the coming set of sessions, we will see the CRUD operations. The Create Operation with Insert One, Insert Many and their options. We will try the create operation both graphically as well as using the command interface.

Then comes the Read operation with the Find method. We will explore different options for the find method.

After that, the update operation using the methods update one, update many, find and modify, find and replace and the various options that we can use along with these operations. We will try them both graphically and using the Mongosh command line.

And then finally the delete operations. Single delete using delete one and multiple delete using delete many. We will also try the bulk write operations in MongoDB.

Then we will proceed with the basic operators of Mongodb. Before we proceed we will create a nice collection by which we can demonstrate the operators. After that, we will see how we can use the Equal and Not Equal Operators, Less than and greater than operators, and nor operator, in and not in operation. We will also try examples for each operation.

Then we will proceed with more complex operations like projection operation in MongoDB which is similar to views in SQL where we can select only the data we want. Then the limiting query, Skipping query and Sorting query operations for manipulation of the result.

In the next session, we will see the index and how search is using this index to make search easier. We will see the default index mechanism of Mongodb and how we can override it and add new indexes, verify them and delete them and also about the text indexes.

Then we will proceed with the concept of document atomicity in which all the documents and their related subdocuments are kept in the same collection and how we can manipulate it during specific actions.

After that, we will try the search and find operation using Regular Expressions. We can precisely manipulate the search operation using Regular Expression pattern matching. 

Then we will have a detailed session on the cursors in Mongodb. Cursors return a pointer pointing to the documents in MongoDB. We will create cursors, retrieve them as an array and also we will iterate through the cursor using javascript looping statements.

Then we will have an elaborate session about the aggregation operation in Mongo DB. Just like joins in RDBMS, it will combine data from different collections, perform conditions and sorting and deliver the result. We will see the single-purpose aggregations like distinct, count, estimated document count etc and then we will see the aggression pipeline. The different stages in the aggregation pipeline. We will try a simple and also advanced example from the MongoDB official documentation. 

In the final session, I will also be providing you with the link to free learning material from the Mongodb official documentation if you want to dive more deeply into Mongodb aggregations and the different operators and conditions used in them.

And that's all about the topics which are currently included in this quick course. The sample database and the materials have been uploaded and shared in a folder. I will include the link to download them in the last session or the resource section of this course. You are free to use that with no questions asked.

Also, after completing this course, you will provided with a course completion certificate which will add value to your portfolio. 

So that's all for now. See you soon in my classroom. 

Happy Learning !!