CS 631 Data Warehousing
This course provides a comprehensive review of data warehousing technology. Areas of study include the evolution of the modern-day data warehouse; analysis and collection of business data requirements; dimensional modeling; the loading of data using extraction, transformation, and loading (ETL) processes; data quality issues; and reporting from the data warehouse using SQL and online analytical processing (OLAP) techniques. Several Oracle lab experiments are conducted to provide hands-on experience in the areas of data warehouse design, construction, data loading, and essential reporting techniques.
Prerequisite
CS 603 Database Design (Oracle)