MNIT Jaipur Syllabus IT Advanced Topics in Data Bases

MNIT Jaipur Syllabus IT Advanced Topics in Data Bases 

 

Advanced Topics in Data Bases

Transaction Management – Transaction Processing, Concurrency Control, Recovery Management.

Advanced SQL – Complex queries, Nested Subqueries, Views, Materialized Views, Triggers, Referential

Integrity, Security and Authorization.

Query Processing and Query Optimizations.

Database  System  Architectures,  Distributed  Databases,  Distributed  Transactions,  Distributed  Query

Processing.

Text/References:

1. Silberschatz A, Korth HF, Sudarshan S, Database System Concepts, McGrall Hill.

2. Elmasri R and Navathe SB, Fundamentals of Database Systems, 3rd Edition, Addison

Wesley,2000. This book covers most of the material on the course.

3. Date CJ, An Introduction to Database Systems, 7th Edition, Addison Wesley.

Leave a Comment