
A birds eye view of what is MongoDB and how it is different from the traditional RDBMS - Lesson just useful to connect viewer to the subject of MongoDB
Downloading of the MongoDB from official site - Installation of MongoDB on Windows - Identifying daemon and shell files - Configuring the MongoDB as service for automatic start - Configuration of PATH system variable
Download Studio 3T (MongoChef) - Installation procedure of Studio 3T - Creating connection object to connect to the local MongoDB database system
Basics of creating database - creating the database - listing the newly created database - creating a collection - listing newly created collection - inserting a document - showing the document - dropping a database
Create the collections explicitly by using createCollection() built-in function of MongoDB - Setting options for behavior of the collections - Drop a collection.
MongoDB Insert document operation - INSERT() function - Inserting one document - Inserting multiple document - JSON document structure - Array of JSON documents - insertOne() function - insertMany() function
Explore simple read operations in MongoDB using PyMongo, retrieving documents from the company.employee collection with find and queries using operators like $in, $gt, $lt, and $not.
Pattern based search of data - Pattern search operator $regex - Regular expression operator - Different ways of pattern matching
What is nested document - Query based on attributes of nested documents -Query based on attributes of nested documents combined with embedding document - Use of operators $in, $or, and distinct() - limitation on query based on complete nested document
What is Array Field in MongoDB Document - Exact match queries with elements of array - Use of $all operator to relax exact matching - Positional enforcement of conditions through array element index - Querying data based on number of elements in array - Why we need to have arrays in a MongoDB document
What is Array of Embedded Documents - Why MongoDB need array of embedded documents - Equality match for nested array of documents - Match with equal values but different order of fields $elemMatch operator - Comparison between RDBMS and Array of Embedded Documents
What is meant by projection - How to specify the fields to be visible or not visible - How to display or hide fields from nested documents - Listing a nested document with using $elemMatch in projection document
Update operation in MongoDB documents - Update on nested array of documents - Adding and deleting a nested document - Deleting an element from an array field - Adding one or more elements to an array field - Increment a value - Deleting a field - Adding a new field
What is save function - Differences and similarities between save and update functions - Nature of save function as upsert - Role of _id field in save function - Operation examples
Learn various different ways of deleting / removing documents from the collection - Examples include use of methods remove(), deleteOne() and deleteMany()
What is cursor - Defining Cursor - Ordering the data - Syntax of sort() method - Working examples of sort() method
skip(), limit() and count() cursor methods - Explained each method with examples - Problems and solutions using combination of these methods
What is size() method - Difference between count() and size() method - Why use size method - Example
What is meant by aggregation pipeline - Basic aggregation pipeline example - Explanation of example with data - Intro to some top level pipeline stage operators
Why use $match operator - How to use $match operator - Advantage of the use of $match operator - Case example of $match
Purpose of $group accumulator operator - How the $group accumulator operator works - Step-by-step explanation with an example
Study of common but very important MongoDB Aggregation Accumulator Operators like $sum, $avg, $max, $min, $sort, $limit and $skip - Use of each operator with examples
Explanation of $project operator - Purpose of $project operator - Use of $project operator for transformation, display of fields, and order of fields with examples
Understanding the $unwind operator used to deconstruct the arrays in the collections - Step-by-step explanation about how the array can be used for a practical case - Example code
Explanation of map & reduce processes - Utility of mapReduce function - Definition of mapReduce - mapReduce() built in function - Example code
Installation of Python - Installation of pymongo driver for Python - Possible bottlenecks in installation - Remedies
Use of IDLE client to access MongoDB - Connecting to the database - Functions find_one() and find() - Providing query filter - Referring to the nested document field in the query - Displaying the result in pretty form - use of pprint module
Perform basic operations through pymongo client - Query examples - Projection - Sort - Skip - Limit
MongoDB Aggregation Pipeline using pymongo - operators $unwind - $group - $sum - $avg - $max - $min - $sort - function count_documents() - function distinct()
MongoDB Python Conditional or Logical Operators - $lte $lt $gte $gt $in $nin $all $or - Query based on exact match on array elements
Search queries based on pattern matching - Regular Expression module provided by Python RE - Use of the pattern matching with various case examples - Relaxation of case sensitivity in regular expression based searches
MongoDB Python Pymongo functions insert_one() and insert_many() - Python datatype dictionary - Testing success of insert operation
MongoDB Python Delete Operation - Deleting single document function delete_one() - Deleting multiple documents function delete_many()
MongoDB Python Update Operation - Updating single document using update_one() function - Operators $set $inc $push $pull $addToSet $each etc. - Updating multiple documents using update_many() function.
Launched just about 10 years ago as on date of launching this course, the MongoDB as NoSQL database has gained such a popularity that no one seeking job in the IT field can ignore it. The developers in MongoDB can claim high salary as there is a big gap between demand of MongoDB developers and their availability.
Optimization of the databases and complexities in accessing various forms of data have always been the challenges, the MongoDB has met them very easily with its simple to handle JSON document type model. The students of this course will just not be introduced to all the features of this incredibly complete database system but also learn all the techniques to make their applications developed with MongoDB to perform efficiently.
This course is for those who may not have worked with any database system here before, but if you have then that would certainly be an advantage. This course has been conceptualized to give you a quick start, with examples, you can directly apply to the industry scenarios. The explanation is concise yet crisp, by totally avoiding technical jargon, and hence you can master this skill if you are just a beginner in entire IT field.
A Primer on Integration of MongoDB and Python with PyMongo :
The course includes a separate section for a primer on integration of MongoDB with the most upcoming language Python with PyMongo. Thus this course might serve as an all round quick start in the world of NoSQL MongoDB even for absolute beginners.