Advanced Diploma in Computer Application

The Guru Nanak Dev University's Faculty of Engineering and Technology offers Advanced Diploma in Computer Application to its students. The course structure for it is as follows:

1. Transaction Management : States, Properties of transaction, Importance of Transaction Control Language, Set Transaction, Commit, RollBack, Savepoint,Concurrent Transactions, Need of Concurrency Control, Serializability, Locking Methods, Two phase Locking Protocol, Timestamping, Optimistic technique, Locks in Oracle, Deadlock

2. Database Recovery : Need of Recovery, Recovery facilities (backup, logging, checkpoint, recovery manager), Backup and recovery in oracle, Logical Backup, Export utility, export modes, import utility, Managing users, privileges and roles

3. Current and Emerging Trends : Concepts of Distributed DBMS, Object
Oriented DBMS, Data Warehousing, OLAP and Data Mining, Object Oriented
features of Oracle