Advanced SSIS

£395.00

What Will You Learn?

  • Performance tuning for SSIS
  • How to extend SSIS using script tasks and components
  • SSIS integration with SSAS and DQS
  • Data warehouse loading patterns

Category:

DESCRIPTION

For the advanced ETL developer and the SSIS user looking to become more effective, our Advanced SSIS course teaches how to use SSIS in your enterprise to solve common extract, transform and load (ETL) challenges. Much of this course focuses on implementing common real-world SSIS patterns taught from the experts of SSIS. Be prepared for in-depth SSIS training with advanced discussion in many areas.

INSTRUCTOR

BRIAN KNIGHT

CEO
Brian Knight is the owner and founder of Pragmatic Works and is a serial entrepreneur, starting up other companies throughout his prolific career. Brian is a contributing columnist at several technical magazines and also does regular webcasts. He is the author of more than 15 technical books.

 

WHAT TO KNOW BEFORE THE CLASS

This class assumes you know the basics of SSIS and takes you from the novice level to a more effective, advanced ETL developer level. We recommend our Introduction to SSIS for those new to SSIS. Having an understanding of Visual Basic is helpful, but not required, for this course.


Duration: 8:30:11
For the advanced ETL developer and the SSIS user looking to become more effective, our Advanced SSIS course teaches how to use SSIS in your enterprise to solve common extract, transform and load (ETL) challenges. Much of this course focuses on implementing common real-world SSIS patterns taught from the experts of SSIS. Be prepared for in-depth SSIS training with advanced discussion in many areas.
Advanced SSIS - What you need to get started
Module 0 - Class Introduction
04:03
Module 01A - Loading a Data Warehouse (Why a Data Warehouse)
18:27
Module 01B - Loading a Data Warehouse (Loading a Dimension Table)
27:19
Module 01C - Loading a Data Warehouse (Loading a Type 1 Dimension)
24:38
Module 01D - Loading a Data Warehouse (Loading a Type 2 Dimension)
18:21
Module 01E - Loading a Data Warehouse (Upsert Pattern)
21:08
Module 01F - Loading a Data Warehouse (Scaling Out Dimension Loads)
15:33
Module 02 - Loading a Fact Table
20:13
Module 03A - Incremental Load Pattern (Using a Control Table)
25:56
Module 03B - Incremental Load Pattern (Change Data Capture)
25:53
Module 04A - Performance Tuning (Source Optimization)
30:06
Module 04B - Performance Tuning (Transform Optimization)
15:40
Module 04C - Performance Tuning (Destination Optimization)
10:12
Module 05A - Scaling out SSIS (Process Task)
25:43
Module 05B - Scaling out SSIS (Process Tasks with T-SQL)
15:23
Module 06A - Restartability Patterns in SSIS (Checkpoints)
10:40
Module 06B - Restartability Patterns in SSIS (Transactions)
15:34
Module 07A - SSIS Scripting (Basics)
18:02
Module 07B - SSIS Scripting (Common Examples)
20:04
Module 08A - Data De-Duplication (Fuzzy Grouping)
19:40
Module 08B - Data De-Duplication (Fuzzy Lookup)
12:29
Module 09A - Advanced Design Patterns (Term Extraction)
07:09
Module 09B - Advanced Design Patterns (Unpivot Transform)
08:38
Module 09C - Advanced Design Patterns (Data Mining)
10:27
Module 10A - SSIS Administration (Deployment)
29:01
Module 10B - SSIS Administration (Environments)
12:48
Module 11A - Data Quality (Data Profiling Task)
12:33
Module 11B - Data Quality (Data Quality Services)
21:54
Module 12 - Master Child Design Pattern
12:37
Class Survey

SYSTEM REQUIREMENTS

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014 (Many features discussed are Enterprise/Developer edition only)
    • SQL Server Database Engine
    • SQL Server Integration Services
    • SQL Server Analysis Services (Optional)
    • SQL Server Data Tools (SQL 2012/2014) or Business Intelligence Development Studio (SQL 2008/2008R2)
    • SQL Server Management Studio
    • Data Quality Services (SQL 2012/2014 only)
    • Data Quality Client (SQL 2012/2014 only)
    • Follow this installation guide: (https://file.ac/CtasreVWQEA/Pragmatic%20SSIS%20Master%20Installation%20Guide.docx)
  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance
  • HigherEd and HigherEdDW databases should be restored on the instance. The HigherEd database backup files can be found in the class download in C:\SSISMaster\databases