UNIT-I
Introduction
Database Introduction
File Systems versus Database Systems
Database Systems Applications, View of Data & Database Languages
Relational Databases
UNIT-II
SQL
MySQL Demonstration – Creating Database | SQL Commands – CREATE, INSERT and SELECT
SQL – CRUD Operations: Create (CREATE and INSERT) | Retrieve (SELECT) | UPDATE | DELETE
UNIT-III
Big Data
GLIMPSE of Big Data Analytics
Glimpse of MapReduce
Implement Word Count Application using MapReduce on Single Node Cluster
GLIMPSE of NoSQL databases
Review of Traditional Databases
NoSQL – Introduction
Need for NoSQL Databases
Columnar Databases
Failover and Reliability Principles
CAP Theorem
Differences between SQL and NoSQL databases
Types of NoSQL Databases
Advantages & Disadvantages of NoSQL
Impact of NoSQL on Data Science
Commonly used NoSQL Databases
Glimpse of MongoDB
MongoDB- Overview
MongoDB – Advantages | Environment
MongoDB – Installation on Windows
MongoDB – Create & Drop Database
MongoDB- Create & Drop Collection
MongoDB – Data Types
Database Design
UNIT-IV
Physical Design
UNIT-V
Query Processing and Optimization
Transaction Processing
Concurrency Control
Recovery System
Sources: