Implementing ETL with SQL Server Integration Services

Offered By: Microsoft via edX

Course Description

Overview

Microsoft SQL Server Integration Services (SSIS) features graphical tools and wizards for:

building and debugging packages
tasks for performing workflow functions
executing SQL statements
data sources and destinations for extracting and loading data
transformations for cleaning, aggregating, merging, and copying data

In this computer science course, you'll extract data from a wide variety of data sources, such as files and relational data sources, perform data integration and transformation solutions, and load data into single or multiple destinations. You will solve complex business problems using best practices and troubleshooting techniques.

Syllabus

0 | Module 0 - Start Here

Welcome to DAT217x: Implementing ETL with SQL Server Integration Services (SSIS)
Setting Up Your Lab Environment in Azure

1 | Module 1 - ETL Processing

ETL Overview
ETL Tools
Data Sources and Destinations
Creating Example Databases
Module Assessment
Module Summary

2 | Module 2 - ETL with SQL Programming

ETL Scripts
Transformations
Implementing ETL with SQL Objects
Lab | Programming an ETL Process with SQL
Module Assessment
Module Summary

3 | Module 3 - ETL Processing with SSIS

Creating SSIS Projects
Programming SSIS Packages
Execute SQL Tasks
Implementing SSIS Packages
Lab | Creating an ETL Process with SSIS
Module Assessment
Module Summary

4 | Module 4 - SSIS Data Flows

Creating Data Flows
Data Flow Transformations
Performance Options
Lab | Creating an SSIS ETL Package Using Data Flow Tasks
Module Assessment
Module Summary

5 | Module 5 - Deployment and Troubleshooting

Error Handling
Deployment
Module Assessment
Module Summary

6 | Module 6 - Final

Final Assessment
Bonus Video
Post-Course Survey

Taught by

Randal Root and Cari Mason