PG-DAC February 2025

Duration: 72 hours (36 theory hours + 36 lab hours)

Objective: To introduce students to RDBMS and NoSQL Databases and facilitate hands-on experience on SQL (using MySQL) and MongoDB.

Prerequisites: Working knowledge of Windows and Linux, familiarity with programming.

Evaluation: 100 Marks

Weightage: CCEE – 40%, Lab exam – 40%, internals – 20%

Text Book:

• Murach's MySQL by Joel Murach / Shroff Publisher

References:

• Database System Concepts by Abraham Silberschatz, Henry Korth, and S. Sudarshan / McGraw Hill
• Database Design and Relational Theory: Normal Forms and All That Jazz by C. J. Date / O'Reilly
• Fundamentals of Database System by Shamkant B. Navathe, Ramez Elmasri / Pearson
• MySQL: The Complete Reference by Vikram Vaswani / McGraw Hill
• SQL & NoSQL Databases: Models, Languages, Consistency Options and Architectures for Big Data Management by Andreas Meier and Michael Kaufmann / Springer
• MongoDB: The Definitive Guide by Shannon Bradshaw, Eoin Brazil, and Kristina Chodorow / O'Reilly
• http://bigdata.stratebi.com/?language=en

(Note: Each Lecture and Lab Session is of 2 hours)

Session 1:

Lecture

• Introduction to DBMS, Basic Database Terminology