Introduction to MongoDB for DBAs (TTDB4680)

Course Objectives

This skills-focused course is about 50% hands-on lab to lecture ratio, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises.  Working in a hands-on learning environment led by our expert instructor, you’ll explore:

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

Need different skills or topics?  If your team requires different topics or tools, additional skills or custom approach, this course may be further adjusted to accommodate.  We offer database, full stack, development, security and other related topics that may be blended with this course for a track that best suits your needs. Our team will collaborate with you to understand your needs and will target the course to focus on your specific learning objectives and goals.

Course Prerequisites

This introductory-level course is for experienced DBAs who will be working with MongoDB.  In order to gain the most from this course you should have:
•    Prior practical experience in Database Administration
•    Experience working with Linux and be comfortable working with command line

Course Agenda

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

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

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

4. MongoDB Security

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

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

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

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

8. Diagnostics & Troubleshooting

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

Course Materials

Student Materials: Each participant will receive a digital Student Guide and/or Course Notes, code samples, software tutorials, step-by-step written lab instructions (as applicable), diagrams and related reference materials and resource links. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.

Hands-On Setup Made Simple! Our dedicated tech team will work with you to ensure our ‘easy-access’ cloud-based course environment, or local installation, is accessible, fully-tested and verified as ready to go well in advance of the course start date, ensuring a smooth start to class and effective learning experience for all participants. In some cases we can also help you install this course locally if preferred. Please inquire for details and options.

Every-Course Extras = High-Value & Long-Term Learning Support! All Public Schedule courses include our unique EveryCourse Extras package (Course Recordings, Live Instructor Follow-on Support, Free *Live* Course Refresh Re-Takes, early access to Special Offers, Free Courses & more). Please inquire for details.