CPSY 205 - ETL (Extract, Transform, Load)

Course Description
This course will introduce students to Designing and Developing the Extract, Tranform and Load processes. Students will implement control flow, data flow, and logging as they create and debug Integration Services packages to enable the ETL process. Students will then deploy these Integration Services packages. Working with SQL Server Integration Studio (SSIS), students will plan data transfer and staging solutions for ETL operations. These packages will require the student to implement error handling, optimization and reliability as they work towards deployment and operation of an SSIS solution.

1.5 Credits:

© 2015-2018, Southern Alberta Institute of Technology (SAIT). All Rights Reserved.