ACTS, Pune
Suggested Teaching Guidelines for
Data Collection and DBMS (Principles, Tools &
Platforms) PG-DBDA August 2024
Session 2:
Lecture
Database Storage Structure
o Table Space
o Control File
o Data file
Structured and Unstructured Data
Introduction to Data Collection like what is data collection.
The tools and how data can be gathered in a systematic fashion
Lab Assignment:
Read and understand the related chapters.
Session 3:
Lecture
Introduction to SQL
DDL Commands
DML & DCL Commands
Lab Assignment:
DDL Commands: Create/Alter/Drop/Grant/Revoke
DML Commands: Select/Insert/Update/Delete/Truncate
DCL Commands: RollBack Commit
Create new User named ‘dbda’ ,Grant all the privileges and Perform
followingQueries.
Create Table ‘Books’ using proper data types which contain
columns(name, author,price, writer)
Session 4:
Lecture
Grouping Things Together (Group by, Having)
Sorting Data (Order By)
Advance Subqueries (Correlated Sub query, Outer Joins)
Lab Assignment:
Queries containing Group By, Having Clause,
Order by
Correlated Queries, SubQueries, Outer Joins
Find out number of employees in each department using employee table
anddepartment table
Print the employee names who have ‘A’ as first letter and ‘N’ as last letter
in theirname.
using customers and product table, write sql query to find the salespersons
andcustomers he handles, print customer name, city, salesman, commission.
PG-DBDA Page 2 of 6
ACTS, Pune
Suggested Teaching Guidelines for
Data Collection and DBMS (Principles, Tools &
Platforms) PG-DBDA August 2024
Session 5 & 6:
Lecture
Constructs in SQL
Data collection
Designing Database Schema
Normal Forms and ER Diagram
Relational DB modelling
Stored Procedures
Gathering Data in Systematic fashion
Session 7:
Lecture
Views
Triggers
Window Function
Case statement
Lab Assignment:
Read and understand the related chapters.
Create View to find employee Who have highest salary, Print name,
salary,department number and department name.
Create View to fine salesperson who handles a customers who make highest
number oforders, return order date, salesperson ID, name.
Session 8 & 9:
Lecture
Data Ware Housing Concepts and Introduction to Tools
Tools related to Data Warehousing
Different algorithms related to Data Warehouse
Importance and its Applications
Lab Assignment:
Read and understand the related chapters.
Session 10:
Lecture
NOSQL
o Introduction to NoSQL
o Difference between a RDBMS and a NoSQL database
o Understanding the Storage Architecture
o Working with Column‐Oriented Databases
o Document Store Internals
Lab Assignment:
o Read and understand the related chapters.
PG-DBDA Page 3 of 6
ACTS, Pune
Suggested Teaching Guidelines for
Data Collection and DBMS (Principles, Tools &
Platforms) PG-DBDA August 2024
Session 11:
Lecture
Practical Design of NoSQL
NOSQL
o Schema structure for Oracle NoSQL database
o Changing Document Databases
o Schema Evolution in Column‐Oriented Databases
o Data Evolution in Key/Value Stores
Lab Assignment:
º Practice Questions including Column‐Oriented Databases
Session 12:
Lecture
Introduction to MongoDB (NoSQL)
o Performing CRUD Operations
o Creating Records
o Accessing Data
o Updating and Deleting Data
o Working with Language Bindings
o Querying NoSQL Stores
o Similarities Between SQL and MongoDB Query Features
o Accessing Data from Column‐Oriented Databases Like HBase
o Querying Redis Data Stores
Lab Assignment:
Read and apply CRUD Operations.
Session 13 & 14:
Lecture
Introduction to MongoDB
o What are MongoDB Internals
o Essential Concepts behind a Database Index
o Indexing and Ordering in MongoDB
o Creating and Using Indexes in MongoDB
Lab Assignment:
º Practice to create and using Indexes in MongoDB
Session 15:
Lecture
MongoDB Queries
o Create Operations
o Read Operations
o Data Aggregation Operations
o Update Operations
PG-DBDA Page 4 of 6
ACTS, Pune
Suggested Teaching Guidelines for
Data Collection and DBMS (Principles, Tools &
Platforms) PG-DBDA August 2024
Lab Assignment:
Insert, Find, FindOne, logical Operators, Distinct, Group, Upsert, Update,
Remove.
Create database using MongoDB query.
Create table books using MongoDB query.
Write a MongoDB query to find the restaurants who achieved a score more
than 90 using Restaurants collection.
Write a MongoDB query to find the restaurants which do not prepare any
cuisine of 'American' and achieved a score more than 70 and located in the
longitude less than - 65.754168 using Restaurants collection.
Write a MongoDB query to find the restaurants which do not prepare any
cuisine of 'American ' and achieved a grade point 'A' not belongs to the
borough Brooklyn. The document must be displayed according to the cuisine
in descending order
Session 16 & 17:
Lecture
Data Model XML
Querying and transformation
Tools - OLTP and OLAP
Lab Assignment:
Read and understand the related chapters
Session 18:
Lecture
Introduction to Cassendra
Comparison between Cassendra and MongoDB
Architecture
Cqlsh
Shell Commands
Lab Assignment:
Read and understand the related chapter
Session 19:
Lecture
Table Operation (Create, Alter, Drop, Truncate, Index creation, Index deletion,
Batch)
Lab Assignment:
Read and understand the related chapters
PG-DBDA Page 5 of 6
ACTS, Pune
Suggested Teaching Guidelines for
Data Collection and DBMS (Principles, Tools &
Platforms) PG-DBDA August 2024
Session 20 & 21:
Lecture
CRUD Operation
o Create
o Update
o Read
o Delete
CQL Types
o CQL Datatypes
o CQL Collections
o User Defined Datatypes
Lab Assignment:
Read and understand the related chapters
Create Table employees using CQL commands.
Update employee’s total salary to 20000 whose commission is ‘0’
Create following tables using collections in Cassandra.
1. Teachers and subjects.
2. Books and Authors.
Insert a value in employee table, update salary of employee whose id is 03
and change the names of employees into upper case whose name start with
‘N’.(Perform alloperations in single Query using Batch)
Print all values present in Books table.
Session 22:
Lecture
Data Driven Decisions
Enterprise Data Management
o Data Preparation
o Data Cleaning
Lab Assignment:
Read and understand the related chapter
PG-DBDA Page 6 of 6
ACTS, Pune
Suggested Teaching Guidelines for
Big Data Technologies PG-DBDA August
2024
Duration: 66 Classroom hours + 84 Lab hours
Objective: To reinforce knowledge of BigData Technologies such as Hadoop, Map
reduce, HBase, PIG, Spark (PySpark)
Prerequisites: Knowledge of Linux command, SQL and Core Java
Evaluation method: Theory exam– 40% weightage
Lab exam – 40% weightage
Internal exam– 20% weightage
List of Books / Other training material
Textbook:
1. Big Data, Black Book: Covers Hadoop 2, MapReduce, Hive, YARN, Pig, R
and Data Visualization, DT Editorial Services , Wiley India,Latest.
Reference:
1. Big Data, Black Book by DreamTech
2. Programming Hive by O’Rellay (Author:- Edward Capriolo, Dean
Wampler, and Jason RutherglenEdward Capriolo, Dean Wampler, and
Jason Rutherglen)
3. Hadoop The Definitive Guide 4thEdition by O’Rellay (Author: - Tom White)
4. Hadoop with python
5. Hadoop Real-World Solutions Cookbook by Packet publication (Author:
Jonathan R. Owens, Jon Lentz,Brian Femiano)
6. Data Architecture: A Primer for the Data Scientist: Big Data, Data Warehouse
and Data Vault
7. Big Data Analytics with Spark: A Practitioner's Guide to Using Spark for Large-
Scale Data Processing, Machine Learning, and Graph Analytics, and High-
Velocity Data Stream Processing
Session: 1, 2 & 3
Introduction to Big Data
o Big Data - Beyond the Hype
o Big Data Skills and Sources of Big Data
o Big Data Adoption
o Research and Changing Nature of Data Repositories
o Data Sharing and Reuse Practices and Their Implications for
Repository Data Curation
o Overlooked and Overrated Data Sharing
o Data Curation Services in Action
o Open Exit: Reaching the End of The Data Life Cycle
o The Current State of Meta-Repositories for Data
o Curation of Scientific Data at Risk of Loss: Data Rescue And Dissemination
PG-DBDA Page 1 of 7
