Advanced Integration Services
Offered By: Pluralsight
Course Description
Overview
This advanced course teaches how to work with SSIS in the context of a data warehouse development project to perform extract, transform, and load operations.
This course explains how to apply Integration Services features to build packages that support the extract, transform, and load operations of a data warehouse. It covers design patterns for staging data and for loading data into fact and dimension tables. In addition, this course describes how to enhance ETL packages with data cleansing techniques and offers insight into the buffer architecture of the data flow engine to hep package developers get the best performance from packages. This course was written for SQL Server 2012 Integration Services, but most principles apply to SQL Server 2005 and later.
This course explains how to apply Integration Services features to build packages that support the extract, transform, and load operations of a data warehouse. It covers design patterns for staging data and for loading data into fact and dimension tables. In addition, this course describes how to enhance ETL packages with data cleansing techniques and offers insight into the buffer architecture of the data flow engine to hep package developers get the best performance from packages. This course was written for SQL Server 2012 Integration Services, but most principles apply to SQL Server 2005 and later.
Syllabus
- Data Warehousing Packages, Part I 57mins
- Data Warehousing Packages, Part II 49mins
- Data Cleansing 73mins
- Package Performance 38mins
Taught by
Stacia Misner Varga
Related Courses
Problem Solving with ExcelPwC via Coursera Data Cleansing with Data Quality Services (DQS)
Microsoft via edX Data Analytics for Decision Making
Queen Mary University of London via FutureLearn Creating Dashboards in Google Spreadsheets
Coursera Project Network via Coursera Excel 2013 Tips and Tricks
LinkedIn Learning