Top Navigation:

FacebookTwitterLinkedInYouTubeSocial Media Options

Primary Navigation:

Main Content:

Breadcrumb Navigation:

Home>Australia>Students>Course Catalog >Course Detail

Course Details

Course Number: 95-797

Data Warehousing

Units: 6

This course will introduce you to the major activities involved in a data warehousing project. The class will begin with an in-depth review of baseline data warehouse principles and concepts. Once the basic principles have been established, the remainder of the class will be built around a group data warehouse project. The project will begin with your group gathering requirements and developing a data warehouse design. Once the design is complete you will build a prototype data warehouse containing the necessary structures within your database and populating them with source data. This will require you to develop the table definitions, extract/transformation/load (ETL) logic, and example report definitions. I intend this class to be a hands-on example of a simple data warehouse implementation.

Prerequisite Note: To take this course, you must have completed either Introduction to Database Management (90-728) OR Database Management (95-703).

Syllabus

Prerequisites:
90-728 Introduction to Database Management 6 Credits
95-703 Database Management 12 Credits

Faculty:
John Shantz