Nov 24, 2024  
PUBLISHED 2020-2021 Credit Catalog 
    
Catalog Navigation
  Catalogue Home
  Programs/Categories
  Programs/Categories by School
  Courses by School
  Programs/Categories in Business
  Courses in Business
  Programs/Categories in CALS
  Courses in CALS
  Programs/Categories in Construction
  Courses in Construction
  Programs/Categories in HPS
  Courses in HPS
  Programs/Categories in H&T
  Courses in H&T
  Programs/Categories in ICT
  Courses in ICT
  Programs/Categories in M&A
  Courses in M&A
  Programs/Categories in MSE
  Courses in MSE
  Programs/Categories in Transportation
  Courses in Transportation
  Campus Recreation
HELP
PUBLISHED 2020-2021 Credit Catalog [ARCHIVED CATALOG]

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 - 2020, Southern Alberta Institute of Technology (SAIT). All Rights Reserved.