Syllabus: Database Management
Segment 1- Introduction to Data and Database System
Introduction to Data: Introduction to Data and Information, Knowledge Discovery, Data
Sources, Data Collection.
Data Collection Techniques: Data Collection Techniques, Advantages and Challenges.
Introduction to Databases: Databases and Database Users, Database System Concepts and
Architecture.
Segment 2- Relational Data Model and Basics of Structured Query Language
Relational Data Model: Relational Model Concepts, Relational Model Constraints, Data
Modelling using the Entity -Relationship (ER) model, Conceptual Database Design, Database
Constraints.
Structured Query Language Basics: Introduction to Structured Query Language (SQL), Types
of Databases, Normalization and Applications, Data Definition Language- CREATE table,
Data Manipulation Language -INSERT, ALTER, and UPDATE Operations.
Data Query Language Basics: SQL Operations on SELECT using WHERE, GROUP BY, HAVING,
and ORDER BY, Preliminary Data Checks.
Segment 3 -Advanced Structured Query Language
Data Query Language Advanced:
• Joins: Horizontal Joins, Vertical Joins- LEFT JOIN, RIGHT JOIN, INNER JOIN, Adding
Indexes- Primary Key, Unique Key and Ordinary Key.
• Subqueries: Nested and Correlated Subqueries.
• Views and Functions: Data Treatment, Transformed Variables, Database
Administration.
Data Control Language: Data Control with GRANT and REVOKE.
Transaction Control Language: Transaction Control with COMMIT, ROLLBACK AND
SAVEPOINT.
Segment 4 -Transaction Processing and Query Optimization
Transaction Processing: Overview of Transaction Processing, Introduction to Transaction
Processing, Advantages and Disadvantages of Transaction Processing System (TPS), Online
Transaction Processing (OLTP), Serializability and Recordability, View Serializability,
Resolving Deadlocks, Distributed Locking, Transaction Management in Multi-Database
System, Long Duration Transaction, High-Performance Transaction Systems.
Query Optimization: Introduction to Query Optimization, Query Execution Algorithm,
Heuristics in Query Optimization, Semantic Query Optimization, Multi-Query Optimization
and Applications, Execution Strategies for SQL Sub Queries, Query Processing for SQL
Updates.
Segment 5- Concurrency Control
Concurrency Control: Introduction to Concurrency Control, Enforcing Serializability by
Locks, LS with Several Lock Modes, Architecture for a Locking Scheduler, Managing
Hierarchies of Database Elements, Concurrency Control by Timestamps, Concurrency
Control by Validation.
Database Recovery Management: Database Failures, Database Backups, Transaction-
based Recovery, Approaches to Transaction-based Recovery.
Segment 6- Data Warehousing and Introduction to Big Data Management
Data Warehousing: Introduction to Data Warehousing, Data Models, OLAP Operations,
Data Warehouse Schema, Data Warehouse Architecture, Data Processing in a Data
Warehouse.
Introduction to Big Data Management: Rise of Bytes, Explosion of Unstructured Data, Big
Data - The Buzzword, RDBMS and Big Data, Introduction to Parallel Computing, Challenges
of Parallel Computing, Introduction to NoSQL databases.