IN 273. Implementing a Data Warehouse with SQL

Credits: 3
Prerequisite(s): IN 272 with a C or better.

This course will enable the student to design shared/conformed dimensions, design hierarchies, and determine attributes for Data Warehouse. The student will learn strategies on how to determine control flow, containers, tasks needed, and precedence constraints design of a SQL Server Integration Service (SSIS) package strategy with rollback, staging, and transaction control. The student will also learn how to manage, configure, and deploy SSIS packages.