May 30, 2024  
PUBLISHED 2024-2025 Credit Catalog 
    
PUBLISHED 2024-2025 Credit Catalog

CPSY 205 - Data Discovery and Ingestion


Description
This course will introduce students to Designing and Developing the Extract, Transform 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. Students will explore data ingestion, preparation, and quality management, while building solutions that use a variety of data discovery control methods. Students will also build skills in the implementation of an Azure Data Solution.

1.5 Credits