Nov 21, 2024  
PUBLISHED 2023-2024 Credit Catalog 
    
Catalog Navigation
  Catalogue Home
  Programs
  Programs by School
  Courses by School
  Programs in Academic Services
  Courses in Academic Services
  Programs in the MacPhail School of Energy
  Courses in the MacPhail School of Energy
  Programs in the School for Advanced Digital Technology
  Courses in the School for Advanced Digital Technology
  Programs in the School of Business
  Courses in the School of Business
  Programs/Categories in Construction
  Courses in the School of Construction
  Programs in the School of Health and Public Safety
  Courses in the School of Health and Public Safety
  Programs in the School of Hospitality and Tourism
  Courses in the School of Hospitality and Tourism
  Programs in the School of Manufacturing and Automation
  Courses in the School of Manufacturing and Automation
  Programs in the School of Transportation
  Courses in the School of Transportation
HELP
PUBLISHED 2023-2024 Credit Catalog [ARCHIVED CATALOG]

CPSY 205 - Data Discovery and Ingestion

Course 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