Transaction Management: ACID Properties, Transactions and Schedules, Concurrent Execution of Transactions, Lock-Based Concurrency Control, Performance of Locking,
Transaction Support in SQL, Introduction to Crash Recovery, 2PL, Serializability, and
Recoverability, Introduction to Lock Management, Dealing with Deadlocks.

Database Storage and Indexing: Data on External Storage, File Organizations and Indexing,
Index Data Structures, Comparison of File Organizations, Indexes and Performance Tuning,
Guidelines for Index Selection, Basic Examples of Index Selection. Database Security and
Advanced Topics: Introduction to Database Security, Access
Control, Discretionary Access Control.

NoSQL Databases and Big Data: Introduction to NoSQL, Data Models: Document, Key
value, Column family, Graph. Uses and Features of NO/SQL document databases. CAP
theorem, BASE vs ACID, CRUD operations, Overview of Big Data Technologies: Hadoop,
MongoDB, Cassandra. Installation of Implementation of MongoDB operators.

Introduction to Data Warehousing, OLAP, Data Mining. Types of data mining, data preprocessing, Attribute-Oriented Induction, Association rule mining, Frequent itemset mining,
The Apriori Algorithm, Overview of classification, Classification process, Decision tree,
Decision Tree Induction, Attribute Selection Measures.