ITEC 541 - Advanced Database Management Systems

Credits: (3)

Instructional Method: Lecture and Discussion
Prerequisites: ITEC 340, admission into the Data and Information Management program, or permission of instructor.

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.