Certificate Authentication

MongoDB For Administrators

MongoDB Architectural Overview

• Origin, design goals, key features
• Process structure (mongos, mongod, config servers)
• Directory / file structure

Working with the MongoDB Shell

• Documents and data types
• CRUD (Inserts, queries, updates, deletes)
• System commands

Single-server Configuration and Deployment

• Configuration files
• Data files and allocation
• Log files
• Hardware and file-system recommendations

Security

• Built-in authentication
• Recommendations for secure deployment

Monitoring MongoDB

• mongostat
• Analyzing memory and IO performance
• Integration with monitoring tools: Munin / Cacti / Nagios
• MongoDB's web console

Indexing and Query Optimization

• Managing indexes and MongoDB indexing internals
• Single / Compound / Geo indexes
• Identifying sub-optimal queries. Using the query profiler.

Introduction to drivers (Java/Python/Ruby/PHP/Perl)

• How the drivers and shell communicate with MongoDB
• BSON and the MongoDB Wire Protocol
• Troubleshooting application connections

Intro to Read and Write scalability

Replication and Durability

• Master-slave replication
• Replica sets
• Using write concern for durability
• Handling replication failures

Auto-Sharding

• How sharding works
• Setting up a MongoDB shard cluster

Choosing a shard key

Sharding and indexes

• Sharding and Replica Set Topologies
• Administering a sharded cluster

Shard / Chunk Migration

Backup and Restore Plans

• Filesystem-based strategies
• mongodump / mongorestore
• rsync
• mongoimport / mongoexport

MongoDB for Analysts

MongoDB Introduction

• Introduction into NoSQL databases
• NoSQL vs. RDBMS (relational databases)
• What are documents and JSON format
• Creating MongoDB sandbox (local or cloud)
• CRUD operations (Create, Read, Update and Delete)
• MongoDB Shell as a basic client tool
• MongoDB Compass and other clients

Aggregation functions

• Single purpose aggregation functions
• Aggregation pipelines
• Creating views
• Overview of map-reduce

Business Intelligence connector and data migration

• How to use MongoDB data in Excel
• BI connector installation and configuration 
• Loading data from existing SQL databases
• Built-in Mongo import/export tools

Performance tuning

• Analysing performance using explain function
• Profiler
• Indexes and special collections overview
• Optimising replica-set nodes for reporting