Course Description for Data Warehousing
Prerequisites:COP 4720 Database Systems, CIS 4327 Info System Senior Project I
This course provides an introduction to data warehousing concepts, requirements gathering, design, and implementation. Students learn about operational database integration, extraction, transformation, and loading of operational data to historical database systems such as operational data store and data warehouse. Students are provided with techniques for the analysis, design, denormalization, implementation, utilization, and documentation in the development of data warehouse systems. Structure query language for database and data warehouse will be studied and used to retrieve data and manipulate the information from the implemented databases. Students are required to complete and present a project to class in the data warehousing area.