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
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