dbm298 | undergraduate

Implementing A Data Warehouse

Explore by:

or call us at

About:

About:

This course will cover the design and implementation of a Data Warehouse. Emphasis will be placed on extraction and transformation of data, design of the data control flow, load options, SSIS Script options, and the  establishment, implementation and maintenance of Data Quality solutions.



This undergraduate-level course is 5 weeks This course is available as part of a degree or certificate program. To enroll, speak with an Enrollment Representative.

Course details:

Credits: 3
Continuing education units: XX
Professional development units: XX
Duration: 5 weeks

topic title goes here

    Load Data

    • Design control flow

    • Implement package logic

    • Implement data load options

    • Implement script components in SSIS

    Configure and Deploy SSIS Solutions

    • Implement auditing, logging, and event handling

    • Install SSIS Components

    • Validate data integrity

    • Troubleshoot data integration issues

    Design and Implement a Data Warehouse

    • Design and Implementation of Fact Tables

    • Design and Implementation of Dimension Tables

    “Build Data Quality” Solutions

    • Measurement of Data Quality

    • Definition of Data Quality

    Extract and Transform Data

    • Design procedures and scripts to extract data

    • Design and implement data flow

    Tuition for individual courses varies. For more information, please call or chat live with an Enrollment Representative.

    Please ask about these special rates:

    Teacher Rate: For some courses, special tuition rates are available for current, certified P-12 teachers and administrators. Please speak with an Enrollment Representative today for more details.

    Military Rate: For some courses, special tuition rates are available for active duty military members and their spouses. Please speak with an Enrollment Representative today for more details.

    The University of Phoenix reserves the right to modify courses.

    While widely available, not all programs are available in all locations or in both online and on-campus formats. Please check with a University Enrollment Representative.

    Transferability of credit is at the discretion of the receiving institution. It is the student’s responsibility to confirm whether or not credits earned at University of Phoenix will be accepted by another institution of the student’s choice.