Introduction to NoSQL and MongoDB
RDBMS, types of relational databases, challenges of RDBMS, NoSQL database, its significance, how NoSQL suits Big Data needs, Introduction to MongoDB and its advantages, MongoDB installation, JSON features, data types and examples.
Installing MongoDB, basic MongoDB commands and operations, MongoChef (MongoGUI) Installation, MongoDB Data types.
Hands-on Exercise – Install MongoDB, Install MongoChef (MongoGUI)
Importance of NoSQL
The need for NoSQL, types of NoSQL databases, OLTP, OLAP, limitations of RDBMS, ACID properties, CAP Theorem, Base property, learning about JSON/BSON, database collection & document, MongoDB uses, MongoDB Write Concern – Acknowledged, Replica Acknowledged, Unacknowledged, Journaled, Fsync.
Hands-on Exercise – Write a JSON document
Understanding CRUD and its functionality, CRUD concepts, MongoDB Query & Syntax, read and write queries and query optimization.
Hands-on Exercise – Use Insert query to Create a data entry, Use find query to Read data, Use update and replace queris to Update, Use delete query operations on a DB file
Data Modeling & Schema Design
Concepts of data modeling, difference between MongoDB and RDBMS modeling, Model tree structure, operational strategies, monitoring and backup.
Hands-on Exercise – Write a data model tree structure for a family hierarchy
Data Management & Administration
In this module you will learn MongoDB® Administration activities such as Health Check, Backup, Recovery, database sharding and profiling, Data Import/Export, Performance tuning etc.
Hands-on Exercise – Use shard key and hashed shard keys, Perform backup and recovery of a dummy dataset, Import data from a csv file, Export data to a csv file
Data Indexing and Aggregation
Concepts of data aggregation and types, data indexing concepts, properties and variations.
Hands-on Exercise – Do aggregation using pipeline, sort, skip and limit, Create index on data using single key, using multikey
Understanding database security risks, MongoDB security concept and security approach, MongoDB integration with Java and Robomongo.
Hands-on Exercise – MongoDB integration with Java and Robomongo.
Working with Unstructured Data
Implementing techniques to work with variety of unstructured data like images, videos, log data, and others, understanding GridFS MongoDB file system for storing data.
Hands-on Exercise – Work with variety of unstructured data like images, videos, log data, and others
Project : To be definded
Industry : General