MongoDB Syllabus - Notes

 

Database Management System & MongoDB

 Syllabus

Unit 1: Overview of Database Management System

Introduction to data, information, database, and DBMS, File-based system and its drawbacks, Database approach and advantages, Classification of Database Management Systems, Various Data Models and Components of DBMS, Three-schema architecture of database, Costs and risks of database approach.

---

Unit 2: Entity-Relationship Model and Relational Model

Introduction to ER Model:

Entities, attributes, relationships, Classification of entity sets and attributes, Relationship degree and classification, Reducing ER diagram to tables.

Enhanced ER Model:

Generalization, specialization, IS-A relationships.

Relational Model:

CODD Rules, concepts of keys, relational integrity, Relational algebra operations, Functional dependencies and normal forms.

---

Unit 3: Structured Query Language and PL/SQL

Introduction to SQL and data types, Data Definition Language (DDL) and Data Manipulation Language (DML), Selection, projection, join, set operations, Aggregate functions, views, subqueries, Table modification commands.

Introduction to PL/SQL:

Language elements, procedures, functions, triggers.

---

Unit 4: Introduction to NoSQL and MongoDB Basics

What is NoSQL?, Features and types of NoSQL databases, CAP theorem and BASE properties, Difference between RDBMS and NoSQL, MongoDB Architecture: database, collection, BSON format, MongoDB Datatypes (String, Number, Date, Boolean, Array, Embedded Docs), Installation and Setup: Mongo shell and GUI, Database and collection management.

---

Unit 5: MongoDB Operations, Data Modeling, and Optimization

CRUD operations: insertOne, find, updateOne, deleteOne, bulk operations, Query operators and working with arrays, Data modeling in MongoDB: embedded vs referenced documents.

Aggregation Framework:

Pipelines, stages, operators.

Indexing:

Single, compound, multikey, text indexes.

Replication Concepts:

Replica sets, failover, consistency.