Introduction to MongoDB for DBAs

Part 1.  Introduction to MongoDB Basic Architecture and InstallationDifferentiate database categories

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

Part 2.  MongoDB administrationTake database backup and restore MongoDB®

1. Export and import data from/ to a MongoDB® instance
2. Check server status and DB status
3. Monitor various resource utilization of a mongod instance
4. Understand various optimization strategies
5. Administration concepts in MongoDB
6. Monitoring issues related to Database
7. Monitoring at Server, Database, Collection level, and various Monitoring tools related to MongoDB
8. Database Profiling, Locks, Memory Usage, No of connections, page fault etc.,
9. Backup and Recovery Methods for MongoDB
10. Export and Import of Data to and from MongoDB
11. Run time configuration of MongoDB
12. Production notes/ best practices
13. Data Managements in MongoDB (Capped Collections/ Expired data from TTL),
14. TTL Collection Features
15. GridFS
16. Memory-Mapped Files
17. Journaling Mechanics
18. Storage Engines
19. Power of 2-Sized Allocations
20. No Padding Allocation Strategy
21. Diagnosing Performance Issues
22. Optimization Strategies for MongoDB
23. Configure Tag Sets for Replica Set. Optimize Query Performance
24. Monitoring Strategies for MongoDB. MongoDB Utilities
25. MongoDB Commands
26. MongoDB Management Service (MMS)
27. Data Backup Strategies in MongoDB
28. Copying Underlying Data Files
29. Backup with MongoDump
30. Fsync and Lock
31. MongoDB Ops Manager Backup Software
32. Security Strategies in MongoDB
33. Authentication Implementation in MongoDB. Authentication in a Replica set
34. Authentication on Sharded Clusters
35. Authorization
36. End-to-End Auditing for Compliance

Part 3.  User ManagementCreate a User Administrator.

1. Add a User to a Database.
2. Create/Assign User a Role.
3. Verify/Modify a User Access/Privileges.
4. Change a User’s Password

Part 4.  MongoDB securityKnowing security concepts in MongoDB

1. Understand how Authentication and Authorisation works
2. Security Introduction
3. Security Concepts

Part 5.  IndexesIndex Introduction,

1. Index Concepts,
2. Index Types
3. Index Properties
4. Index Creation and Indexing Reference
5. Introduction to Aggregation
6. Aggregation Approach to Aggregation sort Order
7. Pipeline Operators and Indexes
8. Text Indexes
9. Aggregate Pipeline Stages
10. Text Search
11. MapReduce
12. Index Creation
13. Aggregation Operations
14. Index Creation on Replica Set
15. Remove, Modify, and Rebuild Indexes
16. Listing Indexes
17. Measure Index Use
18. Control Index Use
19. Index Use Reporting
20. Geospatial Indexes
21. MongoDB’s Geospatial Query Operators
22. GeoWith Operator

Part 6.  Backup & RecoveryImport and Export MongoDB Data

1. Restore and recovery of MongoDB (Including point in time Recovery)
2. Restore a Replica Set from MongoDB Backups
3. Recover Data after an Unexpected Shutdown
4. Backup and Restore with Filesystem Snapshots
5. Back Up and Restore with MongoDB Tools
6. Backup and Restore Sharded Clusters

Part 7.  High Availability (Replication)

1.  Understand the concept of Replication in MongoDB® • Create a production like Replica Set
2.  Introduction to Replication (High Availability), Concepts around Replication
3. What is Replica Set and Master Slave Replication?
4. Type of Replication in MongoDB
5. How to setup a replicated cluster & managing replica sets etc.
6. Master-Slave Replication
7. Replica Set in MongoDB
8. Automatic Failover
9. Replica Set Members
10. Write Concern
11. Write Concern Levels
12. Write Concern for a Replica Set
13. Modify Default Write Concern
14. Read Preference
15. Read Preference Modes
16. Blocking for Replication
17. Tag Set
18. Configure Tag Sets for Replica set. Replica Set Deployment Strategies. Replica Set Deployment Patterns
19. Oplog File
20. Replication State and Local Database, Replication Administration    

Part 8.  Diagnostics & Troubleshooting

1. Troubleshoot slow queries
2. Diagnose connectivity problems
3. Understand diagnostic tools
4. Learn common production issues
5. Learn fixes and solutions

• Experienced DBAs who will be working with MongoDB.
• DBAs who are familiar with the concepts and tasks of working with a Relational database
• DBAs who are not responsible for a NoSQL MongoDB database. 
• All students should have prior practical experience in Database Administration and working with Linux and basic JavaScript.

Working in a hands-on learning environment attendees will explore:

• The MongoDB Basic Architecture and Installation
• MongoDB administration
• User Management
• MongoDB security
• Indexes
• Backup & Recovery
• High Availability / Replication
• Diagnostics & Troubleshooting