The Ultimate Guide For Mongodb 2023

Master MongoDB with Version 6.0. Replication, Sharding, Security, CRUD, Aggregation, Indexes, Utilities, Administration!

What you'll learn

Perform Full-fledged MongoDB Design, Architecture and Administration with most recent MongoDB version 6.0

Understand in-depth MongoDB Replication for High Availability and Replica Set management

Understand in-depth MongoDB Sharding for Horizontal Scaling and related concepts

Understand and Work on MongoDB Security with Role based Access Control

Learn in-depth CRUD (Create, Read, Update, Delete) operations and write efficient queries with various Query Operators

Understanding in-depth Aggregation Pipeline and perform various aggregation queries with variety of Expression Operators

Understand and Create MongoDB supported Indexes and related properties including special MongoDB Indexes - Multikey Index, Text Index, Geospatial Indexes

Understand and perform MongoDB Query Performance Tuning using Profiling and Explain Methodology

Understand and Use MongoDB Database tools - mongodump, mongorestore, mongoexport, mongoimport, mongotop, mongostat, bsondump, mongofiles

Understand the concept of Data Modeling, Schema Validations and Storage Engines in MongoDB

Perform MongoDB Administration and Maintenance Operations

Build strong basics around MongoDB key concepts with easy to understand format

Requirements

No prior knowledge on any Databases is required

Basic Computer Knowledge is good to have

PC or Laptop or Mac is a Must

Description

Join this MongoDB course to learn all about this extremely popular database and query language from the ground up, in great detail and with many practical examples!MongoDB is one of the most important NoSQL databases you can work with these days. MongoDB is able to handle large volumes of data while maximizing performance and adopt a flexible schema approach, giving you ultimate flexibility when modelling data.In this course, you'll learn all about MongoDB from scratch. No prior MongoDB or database experience is required!The curriculum is comprehensive and is designed to take you from beginner to advance level.In detail, you'll learn:• … how to architect, design and administrate the MongoDB database system with most recent version 6.0• … how to install and use MongoDB locally on Windows and Linux OS• … how to implement High Availability in MongoDB using replica set and work with it• … how to implement High Scalability in MongoDB using Sharding feature and work with it• … how to perform Data Modeling efficiently• … how to enforce data Security on database instances and work with it• … how to work with various Database Tools available for backup/restore and statistics purposes• … how to perform CRUD (Create, Read, Update, Delete) operations on MongoDB databases• … how to filter data efficiently• … how to work with the Mongo Shell• … how to work with various types of Indexes in MongoDB• … how to increase query performance by using indexes (and how to use the right indexes!)• … how to use the amazing "Aggregation Framework" that's built into MongoDB• … and much more!This course is a hands-on course - you'll learn by working alongside with me. We'll work on a wide variety of example data and use-cases and by the end of the course, you'll have all the knowledge you need to work with MongoDB in your next project!

Overview

Section 1: Welcome

Lecture 1 Welcome to the Course!

Section 2: Introduction to NoSQL

Lecture 2 Introduction to NoSQL

Lecture 3 Types of NoSQL Databases

Lecture 4 SLIDES - Introduction to NoSQL

Section 3: Introduction to MongoDB

Lecture 5 Introduction to MongoDB

Lecture 6 Difference between MongoDB and RDBMS

Lecture 7 Introduction to CAP Theorem

Lecture 8 Introduction to JSON

Lecture 9 Introduction to BSON and Types

Lecture 10 Introduction to MongoDB Document

Lecture 11 SLIDES and PRACTICE - Introduction to MongoDB

Section 4: MongoDB Installation

Lecture 12 MongoDB Installation Options

Lecture 13 MongoDB Installation on Windows

Lecture 14 MongoDB Installation on Linux (Ubuntu)

Lecture 15 MongoDB Installation on Linux (Tarball)

Lecture 16 Databases and Collections

Lecture 17 Views and Capped Collections

Lecture 18 SLIDES and PRACTICE - MongoDB Installation

Section 5: Introduction to MongoDB Shell

Lecture 19 What is MongoDB Shell

Lecture 20 Configuring MongoDB Shell

Lecture 21 Accessing the MongoDB Shell Help

Lecture 22 Understanding Data Types in MongoDB Shell

Lecture 23 SLIDES and PRACTICE - Introduction to MongoDB Shell

Section 6: Basics of CRUD Operations

Lecture 24 Introduction to CRUD Operations

Lecture 25 Creating Database and Collections

Lecture 26 Insert Operation

Lecture 27 Read (Query) Operation

Lecture 28 Update Operation

Lecture 29 Delete (Remove) Operation

Lecture 30 SLIDES and PRACTICE - Basics of CRUD Operations

Section 7: In-depth Insert Operations

Lecture 31 Overview of Insert Methods

Lecture 32 insert() Method

Lecture 33 insertOne() Method

Lecture 34 InsertMany() Method

Lecture 35 _id Field

Lecture 36 Inserting Complex Documents

Lecture 37 SLIDES and PRACTICE - In-depth Insert Operations

Section 8: In-depth Read Operations

Lecture 38 Overview of Read Methods

Lecture 39 findOne() Method

Lecture 40 find() Method

Lecture 41 Query Nested or Embedded Documents

Lecture 42 Query an Array Field in Documents

Lecture 43 Query an Array of Embedded Documents

Lecture 44 Project Fields to Return from Query

Lecture 45 Iterate the Cursor

Lecture 46 Query and Projection Operators

Lecture 47 Comparison Operators - $eq, $in, $ne, $nin

Lecture 48 Comparison Operators - $gt, $gte, $lt, $lte

Lecture 49 Logical operators - $and, $or

Lecture 50 Logical operators - $not, $nor

Lecture 51 Element Operators - $exists, $type

Lecture 52 Evaluation Operators - $expr, $regex

Lecture 53 Array Operators - $all, $elemMatch, $size

Lecture 54 Projection Operators - $, $elemMatch

Lecture 55 SLIDES and PRACTICE - In-depth Read Operations

Section 9: In-depth Update Operations

Lecture 56 Overview of Update Methods

Lecture 57 update() Method with $set Operator

Lecture 58 update() Method with $unset Operator

Lecture 59 updateOne() Method

Lecture 60 updateMany() Method

Lecture 61 replaceOne() Method

Lecture 62 Update with Upsert Operations

Lecture 63 Field Update Operators

Lecture 64 $currentDate Operator

Lecture 65 $rename Operator

Lecture 66 $inc, $min, $max, $mul Operators

Lecture 67 Array Update Operators

Lecture 68 Placeholder Operator - $

Lecture 69 $addToSet Operator

Lecture 70 $pop Operator

Lecture 71 $pull, $pullAll Operators

Lecture 72 $push Operator

Lecture 73 $each Operator with $push and $addToSet Operators

Lecture 74 Sort Array Elements using $sort+ $push Operators

Lecture 75 SLIDES and PRACTICE - In-depth Update Operations

Section 10: In-depth Delete Operations

Lecture 76 Overview of Delete Methods

Lecture 77 deleteOne() Method

Lecture 78 deleteMany() Method

Lecture 79 remove() Method

Lecture 80 Dropping MongoDB Collections

Lecture 81 Dropping MongoDB Databases

Lecture 82 SLIDES and PRACTICE - In-depth Delete Operations

Section 11: Additional CRUD Related Methods

Lecture 83 Overview of Additional CRUD Methods

Lecture 84 findOneAndDelete() Method

Lecture 85 findOneAndReplace() Method

Lecture 86 findOneAndUpdate() Method

Lecture 87 findAndModify() Method

Lecture 88 bulkWrite() Method

Lecture 89 SLIDES and PRACTICE - Additional CRUD Related Methods

Section 12: MongoDB Aggregation

Lecture 90 Introduction to MongoDB Aggregation

Lecture 91 Introduction to Aggregation Pipeline

Lecture 92 Aggregation Pipeline Stages

Lecture 93 $match Stage

Lecture 94 $group Stage

Lecture 95 $project Stage

Lecture 96 $count Stage

Lecture 97 $collStats Stage

Lecture 98 $indexStats Stage

Lecture 99 $set Stage

Lecture 100 $unset Stage

Lecture 101 $unwind Stage

Lecture 102 $lookup Stage

Lecture 103 $unionWith Stage

Lecture 104 $limit Stage

Lecture 105 $skip Stage

Lecture 106 $sort Stage

Lecture 107 $out Stage

Lecture 108 Aggregation Pipeline Operators

Lecture 109 Arithmetic Expression Operators

Lecture 110 Array Expression Operators

Lecture 111 Boolean Expression Operators

Lecture 112 Comparison Expression Operators

Lecture 113 String Expression Operators

Lecture 114 Type Expression Operators

Lecture 115 Aggregation Pipeline Optimization

Lecture 116 Aggregation Pipeline Limits

Lecture 117 SQL Terms vs MongoDB Aggregation Operators

Lecture 118 SLIDES and PRACTICE - MongoDB Aggregation

Section 13: MongoDB Data Modeling

Lecture 119 Introduction to MongoDB Data Modeling

Lecture 120 Embedded Data Model

Lecture 121 References Data Model

Lecture 122 Perform Schema Validations

Lecture 123 SLIDES and PRACTICE - MongoDB Data modeling

Section 14: MongoDB Indexes

Lecture 124 Introduction to MongoDB Indexes

Lecture 125 Different Types of Indexes

Lecture 126 Index Creation in MongoDB

Lecture 127 Specify the Name to the Index

Lecture 128 Listing the Indexes

Lecture 129 Default _id Index

Lecture 130 Drop an Index

Lecture 131 Single Field Index

Lecture 132 Compound Index

Lecture 133 Prefixes in Compound Index

Lecture 134 Multikey Index

Lecture 135 Covered Query

Lecture 136 Text Index

Lecture 137 2d Index

Lecture 138 2dsphere Index

Lecture 139 Hashed Index

Lecture 140 Wildcard Indexes

Lecture 141 Overview of Index Properties

Lecture 142 TTL Index

Lecture 143 Unique Index

Lecture 144 Partial Index

Lecture 145 Case Insensitive Index

Lecture 146 Hidden Index

Lecture 147 Sparse Index

Lecture 148 dropIndexes() Method

Lecture 149 totalIndexSize() Method

Lecture 150 SLIDES and PRACTICE - MongoDB Indexes

Section 15: Performance Tuning in MongoDB

Lecture 151 Overview of Performance Tuning in MongoDB

Lecture 152 Database Profiler

Lecture 153 Setup Database Profiling

Lecture 154 Database Profiling Commands

Lecture 155 system.profile Collection

Lecture 156 Index Strategies

Lecture 157 cursor.explain() Method

Lecture 158 queryPlanner Explain Mode

Lecture 159 executionStats Explain Mode

Lecture 160 allPlansExecution Explain Mode

Lecture 161 Explain Result without an Index

Lecture 162 Explain Result with an Index

Lecture 163 SLIDES and PRACTICE - Performance Tuning in MongoDB

Section 16: MongoDB Replication

Lecture 164 Introduction to MongoDB Replication

Lecture 165 Primary, Secondary and Arbiter

Lecture 166 Automatic Failover

Lecture 167 Oplog

Lecture 168 Initiate a Replica Set - rs.initiate() Method

Lecture 169 rs.status() Method

Lecture 170 Build 3 Node Replica Set

Lecture 171 Primary Election Process

Lecture 172 Journaling

Lecture 173 Write Concern

Lecture 174 Write Concern Specification

Lecture 175 Read Preference

Lecture 176 Read Preference Modes

Lecture 177 Add Members to the Replica Set

Lecture 178 Add an Arbiter to the Replica Set

Lecture 179 Remove Member from the Replica Set

Lecture 180 Replica Set Configuration - rs.conf() Method

Lecture 181 rs.reconfig() Method

Lecture 182 Priority 0 Replica Set Member

Lecture 183 Prevent Secondary from becoming Primary

Lecture 184 Force a Member to become Primary

Lecture 185 Hidden Replica Set Member

Lecture 186 Configuring Hidden Member

Lecture 187 Votes

Lecture 188 Configuring non-Voting Member

Lecture 189 Delayed Replica Set Member

Lecture 190 Configure a Delayed Member

Lecture 191 Change an Oplog Size

Lecture 192 Chained Replication

Lecture 193 Configuring Secondary's Sync Target

Lecture 194 rs.printSecondaryReplicationInfo() Method

Lecture 195 rs.printReplicationInfo() Method

Lecture 196 rs.stepDown() Method

Lecture 197 rs.freeze() Method

Lecture 198 Replica Set Member States

Lecture 199 SLIDES and PRACTICE - MongoDB Replication

Section 17: MongoDB Security

Lecture 200 Introduction to MongoDB Security

Lecture 201 Authorization, Authentication and Encryption

Lecture 202 Understanding Roles and Users

Lecture 203 Localhost Exception

Lecture 204 User Creation – db.createUser() Method

Lecture 205 SCRAM Authentication Mechanism

Lecture 206 Enable Access Control (Authorization)

Lecture 207 Internal Authentication

Lecture 208 Enforce keyfile Authentication on Existing Replica Set (With Downtime)

Lecture 209 Enforce keyfile Authentication on Existing Replica Set (No Downtime)

Lecture 210 Built-in Roles

Lecture 211 User Defined Roles – db.createRole() Method

Lecture 212 db.getRole() and db.getRoles() Methods

Lecture 213 db.getUser() and db.getUsers() Methods

Lecture 214 db.grantRolesToUser() Method

Lecture 215 db.revokeRolesFromUser() Method

Lecture 216 db.grantPrivilegesToRole() Method

Lecture 217 db.revokePrivilegesFromRole() Method

Lecture 218 db.revokeRolesFromRole() Method

Lecture 219 db.grantRolesToRole() Method

Lecture 220 db.updateUser() Method

Lecture 221 db.updateRole() Method

Lecture 222 db.dropUser() and db.dropAllUsers() Methods

Lecture 223 db.dropRole() and db.dropAllRoles() Methods

Lecture 224 Change User Password

Lecture 225 Collection Level Access Control

Lecture 226 SLIDES and PRACTICE - MongoDB Security

Section 18: MongoDB Database Tools

Lecture 227 Introduction to MongoDB Database Tools

Lecture 228 Installation of MongoDB Database Tools

Lecture 229 mongodump

Lecture 230 mongodump Examples

Lecture 231 mongorestore

Lecture 232 mongorestore Examples

Lecture 233 bsondump

Lecture 234 bsondump Examples

Lecture 235 mongoexport

Lecture 236 mongoexport Examples

Lecture 237 mongoimport

Lecture 238 mongoimport Examples

Lecture 239 mongostat

Lecture 240 mongostat Examples

Lecture 241 mongotop

Lecture 242 mongotop Examples

Lecture 243 SLIDES and PRACTICE - MongoDB Database Tools

Section 19: MongoDB Storage

Lecture 244 Introduction to Storage and Storage Engine

Lecture 245 WiredTiger Storage Engine

Lecture 246 In-Memory Storage Engine

Lecture 247 GridFS

Lecture 248 GridFS – mongofiles

Lecture 249 SLIDES and PRACTICE - MongoDB Storage

Section 20: MongoDB Sharding

Lecture 250 Introduction to MongoDB Sharding

Lecture 251 Shards

Lecture 252 Config Server

Lecture 253 mongos (Router)

Lecture 254 Shard Key

Lecture 255 Sharding Architecture

Lecture 256 Choosing a Shard Key

Lecture 257 Hashed Sharding

Lecture 258 Ranged Sharding

Lecture 259 Overview of Sharding Setup

Lecture 260 Setup 2 Shard Replica Sets

Lecture 261 Setup Config Server Replica Set

Lecture 262 Setup mongos Router

Lecture 263 Add Shard 1 to the Sharded Cluster (Converting Replica Set to Sharded Cluster)

Lecture 264 Shard a Collection

Lecture 265 Check the Status of Sharded Cluster – sh.status() Method

Lecture 266 Balancer Process

Lecture 267 Add Shard 2 to the Sharded Cluster

Lecture 268 Balancer State – sh.getBalancerState() Method

Lecture 269 sh.setBalancerState() Method

Lecture 270 sh.isBalancerRunning() Method

Lecture 271 sh.stopBalancer() Method

Lecture 272 sh.startBalancer() Method

Lecture 273 Chunks and Jumbo Chunk

Lecture 274 Overview of Split Chunks

Lecture 275 sh.splitAt() Method

Lecture 276 sh.splitFind() Method

Lecture 277 Merge Chunks with mergeChunks Command

Lecture 278 Migrating a Chunk using moveChunk Command (or sh.moveChunk() Method)

Lecture 279 Modify Chunk Size

Lecture 280 Primary Shard and movePrimary Command

Lecture 281 sh.balancerCollectionStatus() Method

Lecture 282 sh.disableBalancing() and sh.enableBalancing() Methods

Lecture 283 sh.disableAutoSplit() and sh.enableAutoSplit() Methods

Lecture 284 Changing a Shard Key

Lecture 285 Refining a Shard Key

Lecture 286 Reshard a Collection

Lecture 287 Back Up Sharded Cluster Metadata

Lecture 288 Remove Shards from an Existing Sharded Cluster

Lecture 289 Config Database

Lecture 290 What If – mongos become unavailable

Lecture 291 What If – Single member of Shard becomes unavailable

Lecture 292 What If – All members of Shard become unavailable

Lecture 293 What If – Single member of Config Replica Set become unavailable

Lecture 294 SLIDES and PRACTICE - MongoDB Sharding

Section 21: MongoDB Administration

Lecture 295 Overview of MongoDB Administration

Lecture 296 MongoDB Version Upgrade

Lecture 297 DEMO: Upgrade a Replica Set v4.4.17 to v5.0.13

Lecture 298 DEMO: Upgrade a Replica Set v5.0.13 to v6.0.2

Lecture 299 MongoDB Version Upgrade Approach for Sharded Cluster

Lecture 300 db.currentOp() and db.killOp() and cursor.maxTimeMS() Methods

Lecture 301 Recover a Standalone using – repair

Lecture 302 Compact Operation

Lecture 303 MongoDB Log Rotation

Lecture 304 db.setLogLevel() Method

Lecture 305 Statistics and Informative Methods

Lecture 306 Rename a Collection

Lecture 307 allowDiskUse() Method

Lecture 308 db.fsyncLock() and db.fsyncUnlock() Methods

Lecture 309 db.shutdownServer() Method

Lecture 310 Convert Command-Line Options to YAML

Lecture 311 System Collections

Lecture 312 Operations Checklist for Production MongoDB Deployment

Lecture 313 MongoDB Limits and Thresholds

Lecture 314 Help() Methods

Lecture 315 SLIDES and PRACTICE - MongoDB Administration

Section 22: Conclusion

Lecture 316 Congratulations and Thank you!

Data Scientists, Data Architects, Database Designer, Database Administrators, or Developers, who plan on (or are already) working with MongoDB,All Beginners or Advanced users who wants to explore all MongoDB features,Any professional or student who is looking for new add-ons to their skill sets,Anyone who is managing NoSQL projects or wants to learn NoSQL databases