Mongo DB

Overview

What will you Learn?

• Introduction to NoSQL (1 hour)
• What Is NoSQL?
• Why NoSQL databases are required.

• Types of NoSQL Database
• NoSQL vs SQL Comparison
• ACID & BASE Property
• CAP Theorem
• Benefits of NoSQL databases

• Installation
• Start and Stop the MongoDB process

Curriculum

Architecture

• Document, Collection, Databases

• JSON and BSON

• Storage Engines (WiredTiger and MMAP)

• Read Path

• Journaling

• Write Path

• Working Set

• Capped Collection

• Oplog collection

• TTL Index

• GridFS

CRUD Operations (1 hour)

• Mongodb Data Types

• Inserting, Update, and Deleting the documents

• Querying the documents

• Bulk insert operation

• Updating multiple documents

• Limiting documents

• Filtering documents

Schema Design and Data modeling (1 hour)

• Dynamic Schema

• What is Data modeling?

• RDBMS and MongoDB Data modeling difference

• Embedding Document

• Reference Document

Indexes

• Index concepts in MongoDB

• Types of indexes

• Indexes and their use cases

• Creating Indexes and Managing Indexes

• Index strategies

Database Administration (1.5 hour)

• Database status

• Troubleshooting issues

• Current Operations

• Rotating log files

• Users and Roles

• Copy and Clone database

• DB and Collection Stats

• Explain plan

• Profiling

• Changing configuration files

• Upgrading the database

Backup and Security (1hour)

• Concept of backups

• mongoexport/mongoimport

• mongodump/mongorestore

• Oplog backups

• LVM Backups

• Backups using MMS/Ops Manager

• Purpose of security

• Authentication and authorization

• Role-based access control

Replication (1.5 Hour)

• Concept of replication

• ReplicaSet member roles

• Voting and Electing primary

• Role of Oplog in replication

• Read and Write Concern

• Arbiter, Hidden and Delayed replica node

• Priority settings

• Replicaset nodes health check

• Concept of resyncing the nodes

• Rollbacks during failover

• Keyfile authentication

Scalability (1 hour)

• Concept of Scalability and Sharding

• Shardkey and Chunks

• Choosing shardkey

• Sharding components

• Types of Sharding

• Balanced data distribution

• Sharded and Non-sharded collection

• Sharded Replicaset

• Tag aware sharding

Monitoring and Other Tools (30Mins)

• MMS Manager

• Ops Manager

• Mongo utility commands

• Mongo developer tools

• MongoDB Atlas

• MongoDB client drivers

Upgrading MongoDB to Latest Stable Version (30 mins)

• Upgrading MongoDB to Latest Stable Version

• Upgrade Process

• Post Upgrade Checks

MongoDB Performance Tuning (30 mins)

• Monitoring of Performance

• Logging database operations

• Capturing queries – Database Profiler

• Checking operating system parameters

• Explain plan-MongoDB provides an explain facility

• Measuring replication lag performance