Introduction to MongoDB for DBAs (TTDB4680)

Lesson: Introduction to MongoDB Basic Architecture and Installation

• Differentiate database categories
• Learn MongoDB design goals
• List MongoDB tools 
• Describe JSON and BSON
• Understanding the basic concepts of a Database
• Database categories: What is NoSQL? Why NoSQL? Benefit over RDBMS
• Types of NoSQL Database, and NoSQL vs. SQL Comparison, ACID & Base Property
• CAP Theorem, implementing NoSQL and what is MongoDB?
• Graph Database
• Overview of MongoDB, Design Goals for MongoDB Server and Database, MongoDB tools
• Understanding the following: Collection, Documents and Key/ Values, etc.,
• Introduction to JSON and BSON documents
• Environment setup (live Hands-on) and using various MongoDB tools available in the MongoDB Package

Lesson: MongoDB administration

• Take database backup and restore MongoDB®
• Export and import data from/ to a MongoDB® instance
• Check server status and DB status
• Monitor various resource utilization of a mongod instance
• Understand various optimization strategies
• Administration concepts in MongoDB
• Monitoring issues related to Database
• Monitoring at Server, Database, Collection level, and various Monitoring tools related to MongoDB
• Database Profiling, Locks, Memory Usage, No of connections, page fault etc.,
• Backup and Recovery Methods for MongoDB
• Export and Import of Data to and from MongoDB
• Run time configuration of MongoDB
• Production notes/ best practices
• Data Managements in MongoDB (Capped Collections/ Expired data from TTL), 
• TTL Collection Features
• GridFS
• Memory-Mapped Files
• Journaling Mechanics
• Storage Engines
• Power of 2-Sized Allocations
• No Padding Allocation Strategy
• Diagnosing Performance Issues
• Optimization Strategies for MongoDB 
• Configure Tag Sets for Replica Set . Optimize Query Performance
• Monitoring Strategies for MongoDB . MongoDB Utilities 
• MongoDB Commands
• MongoDB Management Service (MMS)
• Data Backup Strategies in MongoDB
• Copying Underlying Data Files
• Backup with MongoDump
• Fsync and Lock
• MongoDB Ops Manager Backup Software
• Security Strategies in MongoDB
• Authentication Implementation in MongoDB . Authentication in a Replica set
• Authentication on Sharded Clusters
• Authorization
• End-to-End Auditing for Compliance

Lesson: User Management

• Create a User Administrator.
• Add a User to a Database.
• Create/Assign User a Role.
• Verify/Modify a User Access/Privileges.
• Change a User’s Password

Lesson: MongoDB security

• Knowing security concepts in MongoDB
• Understand how Authentication and Authorisation works
• Security Introduction
• Security Concepts

Lesson: Indexes

• Index Introduction,
• Index Concepts,
• Index Types
• Index Properties 
• Index Creation and Indexing Reference
• Introduction to Aggregation
• Aggregation Approach to Aggregation sort Order
• Pipeline Operators and Indexes
• Text Indexes
• Aggregate Pipeline Stages
• Text Search
• MapReduce
• Index Creation
• Aggregation Operations
• Index Creation on Replica Set
• Remove, Modify, and Rebuild Indexes
• Listing Indexes
• Measure Index Use
• Control Index Use
• Index Use Reporting
• Geospatial Indexes
• MongoDB’s Geospatial Query Operators 
• GeoWith Operator

Lesson: Backup & Recovery

• Import and Export MongoDB Data 
• Restore and recovery of MongoDB(Including point in time Recovery) 
• Restore a Replica Set from MongoDB Backups 
• Recover Data after an Unexpected Shutdown 
• Backup and Restore with Filesystem Snapshots 
• Back Up and Restore with MongoDB Tools 
• Backup and Restore Sharded Clusters

Lesson: High Availability (Replication)

• Understand the concept of Replication in MongoDB® • Create a production like Replica Set
• Introduction to Replication (High Availability), Concepts around Replication 
• What is Replica Set and Master Slave Replication?
• Type of Replication in MongoDB
• How to setup a replicated cluster & managing replica sets etc.,
• Master-Slave Replication
• Replica Set in MongoDB
• Automatic Failover
• Replica Set Members
• Write Concern
• Write Concern Levels
• Write Concern for a Replica Set
• Modify Default Write Concern
• Read Preference
• Read Preference Modes
• Blocking for Replication
• Tag Set
• Configure Tag Sets for Replica set . Replica Set Deployment Strategies . Replica Set Deployment Patterns
• Oplog File 
• Replication State and Local Database, Replication Administration       

Lesson: Diagnostics & Troubleshooting

• Troubleshoot slow queries
• Diagnose connectivity problems
• Understand diagnostic tools
• Learn common production issues
• Learn fixes and solutions.