To support our site, Class Central may be compensated by some course providers.

Implementing ETL with SQL Server Integration Services

Microsoft via edX

students interested
  • Provider edX
  • Subject Databases
  • $ Cost Free Online Course
  • Session Self Paced
  • Language English
  • Certificate $99 Certificate Available
  • Effort 2-4 hours a week
  • Start Date
  • Duration 6 weeks long

Taken this course? Share your experience with other students. Write review

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

Help Center

Most commonly asked questions about EdX EdX

Review for edX's Implementing ETL with SQL Server Integration Services
2.0 Based on 1 reviews

  • 5 star 0%
  • 4 star 0%
  • 3 star 0%
  • 2 star 100%
  • 1 star 0%

Did you take this course? Share your experience with other students.

Write a review
  • 1
Anonymous
2.0 2 years ago
Anonymous completed this course.
The course is very premature and quite disappointing from an experienced data scientist at Microsoft. The contents are neither introductory nor advances. It is not clear where is the level of this course. It starts with fairly complex ETL design using scripting. The lecturer only shows what he is doing without detail description of how things are made and why they are made this way.

In the second part of the content, it goes to Microsoft SSIS and then it becomes quite introductory course for someone who has absoloutly 0 knowledge and experience on SSIS.

At the end, yo…
1 person found
this review helpful
Was this review helpful to you? Yes
  • 1

Class Central

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.