Advanced Database Management Systems

Catalog description

Instructional Method: Lecture and Discussion Prerequisites: Graduate standing. Advanced topics and techniques in the modeling and manipulation of large data sets. Includes in-depth coverage of relational algebra and heavily nested SQL, physical database design and optimization, triggers and stored procedures, transaction control, assertions and other data integrity techniques, advanced modeling issues such as temporal design, and key topics in database administration. Students must implement one or more aspects of query execution and demonstrate an ability to implement scripts for common DBA (data base administrator) tasks. Students must have completed a database course including hands-on experience with the relational model, SQL, security, database design, and stored procedures.