- Understand the requirement for No SQL database, Architecture and Installation for MongoDB :
Topics :- Understanding Base Concepts of 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, and Implementing NoSQL, What is MongoDB? Overview of MongoDB, Design Goals for MongoDB Server and Database, MongoDB Tools, Depth Understanding of Database, Collection, Documents and Key /Values etc., Introduction to JSON and BSON Documents, (Live Hands on), Usage of various MongoDB Tools available with MongoDB Package, Project: Problem Statement.
Hands-On :- Installation/Running MongoDB on various platforms Windows, Linux, MAC OS etc., Environment Setup. Installation and setup of free client like Robomongo for connecting to MongoDb.
- CRUD Operations :
Topics :- MongoDB Development Architecture, MongoDB Production Architecture, MongoDB CRUD Introduction, MongoDB CRUD Concepts, MongoDB CRUD Concerns (Read & Write Operations), Concern Levels, Journaling etc., Cursor, Query Optimizations, Query Behaviors in MongoDB, Distributed Read & Write Queries, MongoDB Datatypes, MongoDB CRUD Syntax & Queries.
Hands-On :- Live hands on all queries learnt during the session. These are common queries you will be using on day to day in the real world application development.
- Schema Design and Data Modelling :
Topics :- Data Modelling Concepts, Type of Data Modelling, Why Data Modelling? Data Modelling Approach, Analogy between RDBMS & MongoDB Data Model, MongoDB Data Model (Embedding & Linking), Challenges for Data Modelling in MongoDB, Data Model Examples and Patterns, Model Relationships between Documents: Model One-to-One Relationships with Embedded Documents, Model One-to-Many Relationships with Embedded Documents, Model One-to-Many Relationships with Document References, Model Tree Structures: Model Tree Structures with Parent References, Model Tree Structures with Child References, Model Tree Structures with an Array of Ancestors, Model Tree Structures with Materialized Paths, Model Tree Structures with Nested Sets, Model Specific Application Contexts: Model Data for Atomic Operations, Model Data to Support Keyword Search, Data Model References, Use Case of Data modelling.
Hands-On :- We will remodel a real world database for MongoDB that is currently using the Oracle database.
- Administration :
Topics :- Administration Concept in MongoDB, Health Check of MongoDB Database, Monitoring of Various issues related with 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/Bets Practices, Data Managements in MongoDB (Capped Collections/ Expired data from TTL), Hands on Administrative Tasks.
Hands-On :- We will look into common issues faced in production, identify the long running queries, locks and ways to clear them.
- Scalability and Availability :
Topics :- Introduction to Replication (High Availability), Concepts around Replication, What is ReplicaSet and Master Slave Replication? Type of Replication in MongoDB, How to setup a replicated cluster, Managing ReplicaSets etc., Introduction to Sharding (Horizontal Scaling), Concepts around Sharding, What is shards, Key, ConfigServer, Query Router etc.? How to setup a Sharding, Type of Sharding (Hash Based, Range Based etc.), and Managing Shards.
Hands-On :- We will create an actual real world Mongodb set up (3 replica set 3 shard cluster)
- Indexing and Aggregation Framework :
Topics:- Index Introduction, Index Concepts, Index Types, Index Properties, Index Creation, Index Tutorial, Indexing Reference, Aggregation to Introduction, Approach to Aggregation, Type of Aggregation (Pipeline, MapReduce & Single Purpose) and Performance Tuning.
Hands-On :- We will be creating all the indexes and see the impact on performance.
- Application Engineering and MongoDB Tools :
Topics :- MongoDB Package Components, Configuration File Options, MongoDB Limits and Thresholds, Connection String URI Format/ Integration of any compatible tool with MongoDB, API and Drivers for MongoDB, MMS (MongoDB Monitoring Service), HTTP and Rest Interface, Integration of MongoDB with Hadoop and Data Migration MongoDB with Hadoop (MongoDB to Hive).
Hands-On :- We will see java mongodb integration. We will build an simple application that will use MongoDB.
- Project, Additional Concepts and Case Studies :
Topics :- Security Introduction, Security Concepts, Security Tutorials, Integration of MongoDB with Jaspersoft, Integration of MongoDB with Talend, Integration of MongoDB with Hadoop/Hive, Integration of MongoDB with Java, Project on MongoDB and Java.