MET CS 779 Advanced Database Management
Description: This course covers advanced aspects of database management systems including advanced normalization and denormalization, query optimization, object-oriented and object-relational databases, data warehousing, data mining, distributed databases, XML, XSL, and databases for web applications. There is extensive coverage of SQL and database instance tuning. Students learn about the advanced object-relational features in DBMS such as Oracle, including navigational query, BLOBs, abstract data types, and methods. Students learn about database programming in Oracle’s PL/SQL language, including triggers, stored procedures, and methods. By the end of the course, students should understand the basic concepts in all of these advanced database topics. Students define independent advanced database term projects, which may be related to their work or other interests. The students prepare reports and audio-video presentations for their classmates using PowerPoint and Impatica. 4 credits.