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

Categories: On-Demand Learning, SQL Server Business Intelligence Tag: Power BI Developer

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.

Module 0 – Class Introduction

Module 0
Class Introduction
Preview
4:03

Module 1 – Loading a Data Warehouse

Module 1A
Loading a Data Warehouse (Why a Data Warehouse)
Preview
18:26
Module 1B
Loading a Data Warehouse (Loading a Dimension Table)
Preview
27:18
Module 1C
Loading a Data Warehouse (Loading a Type 1 Dimension)
Preview
24:38
Module 1D
Loading a Data Warehouse (Loading a Type 2 Dimension)
Preview
18:21
Module 1E
Loading a Data Warehouse (Upsert Pattern)
Preview
21:07
Module 1F
Loading a Data Warehouse (Scaling Out Dimension Loads)
Preview
15:32

Module 2 – Loading a Fact Table

Module 2
Loading a Fact Table
Preview
20:13

Module 3 – Incremental Load Pattern

Module 3A
Incremental Load Pattern (Using a Control Table)
Preview
25:56
Module 3B
Incremental Load Pattern (Change Data Capture)
Preview
25:53

Module 4 – Performance Tuning

Module 4A
Performance Tuning (Source Optimization)
Preview
30:06
Module 4B
Performance Tuning (Transform Optimization)
Preview
15:39
Module 4C
Performance Tuning (Destination Optimization)
Preview
10:11

Module 5 – Scaling out SSIS

Module 5A
Scaling Out SSIS (Process Task)
Preview
25:42
Module 5B
Scaling Out SSIS (Process Tasks with T-SQL)
Preview
15:22

Module 6 – Restartability Patterns in SSIS

Module 6A
Restartability Patterns in SSIS (Checkpoints)
Preview
10:40
Module 6B
Restartability Patterns in SSIS (Transactions)
Preview
15:33

Module 7 – SSIS Scripting

Module 7A
SSIS Scripting (Basics)
Preview
18:01
Module 7B
SSIS Scripting (Common Examples)
Preview
20:03

Module 8 – Data De-Duplication

Module 8A
Data De-Duplication (Fuzzy Grouping)
Preview
19:40
Module 8B
Data De-Duplication (Fuzzy Lookup)
Preview
12:28

Module 9 – Advanced Design Patterns

Module 9A
Advanced Design Patterns (Term Extraction)
Preview
7:08
Module 9B
Advanced Design Patterns (Unpivot Transform)
Preview
8:38
Module 9C
Advanced Design Patterns (Data Mining)
Preview
10:27

Module 10 – SSIS Administration

Module 10A
SSIS Administration (Deployment)
Preview
29:01
Module 10B
SSIS Administration (Environments)
Preview
12:47

Module 11 – Data Quality

Module 11A
Data Quality (Data Profiling Task)
Preview
12:33
Module 11B
Data Quality (Data Quality Services)
Preview
21:54

Module 12 – Master Child Design Pattern

Module 12A
Master Child Design Pattern
Preview
12:36

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

On-Demand Learning Elite Subscription

~~$995.00~~ $895.00

Advanced SSIS

What Will You Learn?

Description

Instructor

BRIAN KNIGHT

What to Know Before the Class

Curriculum For This Course

Module 0 – Class Introduction

Module 1 – Loading a Data Warehouse

Module 2 – Loading a Fact Table

Module 3 – Incremental Load Pattern

Module 4 – Performance Tuning

Module 5 – Scaling out SSIS

Module 6 – Restartability Patterns in SSIS

Module 7 – SSIS Scripting

Module 8 – Data De-Duplication

Module 9 – Advanced Design Patterns

Module 10 – SSIS Administration

Module 11 – Data Quality

Module 12 – Master Child Design Pattern

System Requirements

You may also like…

On-Demand Learning Elite Subscription

Data Science with Azure ML

Power BI for Consumers

Advanced Power BI

Introduction to SSIS

Subscribe to Our Email List!

Advanced SSIS

What Will You Learn?

Description

Instructor

BRIAN KNIGHT

What to Know Before the Class

Curriculum For This Course

System Requirements

You may also like…

On-Demand Learning Elite Subscription

Related products

Data Science with Azure ML

Power BI for Consumers

Advanced Power BI

Introduction to SSIS