Advanced database systems is the second course in the program dealing with database management. This course covers: data modeling with enhanced E-R model, database design theory, relational model, object-oriented model, physical database design and performance, advanced SQL, query optimization, transaction processing, concurrency, recovery, web and semi-structured data management, distributed databases, data warehousing, data quality and integration, and database administration.
Prerequisite: IT 510
TITLE: Modern database management, 12 ed, 2016
AUTHOR: Hoffer, J. A., Ramesh, V., & H. Topi
ISBN: ISBN-10: 0133544613 ISBN-13: 9780133544619