CSCI 4132 - Data Warehouse Design (3 Credit Hours)

Lecture Hours: 3 Lab Hours: 12-30
The course will cover data warehouse design principles and technical problems. Topics will include: data warehouse architectures, organizing data warehouse design projects, analyzing data and requirements. SQL aggregate and analytic functions, materialized views, star-joins and other DW related features, data vault modeling, dimensional modeling, physical design and implementation of integrated data warehouse using commercial ROLAP engines such as Oracle or SQL Server.

Prerequisite(s): A minimum grade of “C” in CSCI 3432.