Home Campus Directory | A-Z Index

Who Should Attend

This program is for those who gather data from different databases or data sources and blend the data into a single repository to generate reports, including developers, managers, designers, data system modelers, database administrators, data architects, and business analysts.

Certificate Requirement -four courses

A Penn State Great Valley certificate is awarded upon completion of the four required courses. Participants not wishing to take the entire sequence are welcome to take any course that interests them, pending prerequisite knowledge.

Continuing Education Units

Continuing Education Units (CEUs), based on a standard of one unit per 10 hours of classroom contact, are awarded.

For additional program information, call 610-648-3281 or email gvskills@psu.edu. 

This is a PDO (Professional Development Opportunity)  eligible program.

Please check back for Fall 2016 dates.  Find out more about registration options and the withdrawal/refund policy. 


Program Objectives

Upon completion of the Penn State Great Valley Data Warehouse Certificate program, students will be able to design and build a data warehouse; extract, transform and load algorithms using SSIS;  design and build data reports using SSRS; and, design and build data cubes using SSAS.


                                                                                                        

Required Courses

Course #

Course Title
(click course # for description)

Sessions

Times

Fall I

Fall II

CSE 6601

Building the Data Warehouse
Prerequisite: Knowledgeable in database structure and SQL

7

6:00 - 9:00 p.m.

TBA

SWENG 5137

 

Extract, Transform and Load Concepts (ETL)
Prerequisite: Building the Data Warehouse

 

7

6:00 - 9:00 p.m.


TBA

Course #

Course Title
(click course # for description)

Sessions

Times

Spring I

Spring II

SWENG 5138 Data Warehouse Reporting
Prerequisite: Extract Transform and Load Concepts
7
6:00 - 9:00 p.m. TBA

SWENG 5171 SQL Analysis Services
Prerequisite: Data Warehouse Reporting

7

6:00 - 9:00 p.m.




TBA




Note:
The University reserves the right to cancel courses owing to insufficient enrollment or other unforeseen circumstances.

On-site Programs: Develop a stronger workforce for the future

Companies and organizations can have programs conducted on site or at another location. Program content can be customized to meet the needs of the company.  Call 610-648-3281 for information.