fbpx

NEED HELP? TALK TO AN EXPERT (904) 638-5743

Advanced SSIS

WHAT YOU'LL LEARN

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

Course 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.

 

Click here for a downloadable PDF

Outline

 

Module 00 | Class Introduction
04m 03s total

 

Module 00A | Class Introduction
04m 03s

 

Module 01 | Loading a Data Warehouse
124m 46s total

 

Module 01A | Why a Data Warehouse
18m 27s

 

Module 01B | Loading a Dimension Table
27m 19s

 

Module 01C | Loading a Type 1 Dimension
24m 38s

 

Module 01D | Loading a Type 2 Dimension
18m 21s

 

Module 01E | Upsert Pattern
21m 08s

 

Module 01F | Scaling Out Dimension Loads
15m 33s

 

Module 02 | Loading a Fact Table
20m 13s total

 

Module 02A | Loading a Fact Table
20m 13s

 

Module 03 | Incremental Load Pattern
51m 09s total

 

Module 03A | Using a Control Table
25m 56s

 

Module 03B | Change Data Capture
25m 53s

 

Module 04 | Performance Tuning
55m 58s total

 

Module 04A | Source Optimization
30m 06s

 

Module 04B | Transform Optimization
15m 40s

 

Module 04C | Destination Optimization
10m 12s

 

Module 05 | Scaling out SSIS
40m 66s total

 

Module 05A | Process Task
25m 43s

 

Module 05B | Process Tasks with T-SQL
15m 23s

 

Module 06 | Restartability Patterns in SSIS
25m 74s total

 

Module 06A | Checkpoints
10m 40s

 

Module 06B | Transactionss
15m 34s

 

Module 07 | SSIS Scripting
38m 06s total

 

Module 07A | Basics
18m 02s

 

Module 07B | Common Examples
20m 04s

 

Module 08 | Data De-Duplication
31m 69s total

 

Module 08A | Fuzzy Grouping
19m 40s

 

Module 08B | Fuzzy Lookup
12m 29s

 

Module 09 | Advanced Design Patterns
25m 74s total

 

Module 09A | Term Extraction
07m 09s

 

Module 09B | Unpivot Transform
08m 38s

 

Module 09C | Data Mining
10m 27s

 

Module 10 | SSIS Administration
41m 49s total

 

Module 10A | Deployment
29m 01s

 

Module 10B | Environments
12m 48s

 

Module 11 | Data Quality
33m 87s total

 

Module 11A | Data Profiling Task
12m 33s

 

Module 11B | Data Quality Services
21m 54s

 

Module 12 | Master Child Design Pattern
12m 37s total

 

Module 12A | Master Child Design Pattern
12m 37s

Instructor

MITCHELL PEARSON

Training Content Manager
Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.

 

Click Here To Learn More About Mitchell And See Certifications And Reviews

System Requirements

  • Windows, 7, 8 or 10
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 5 GB of free hard drive space
  • Microsoft Excel 2010 but Excel 2013 is preferred

What to Know Before 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.

REVIEWS
Despite having several years of experience using SSIS, by doing this Advanced SSIS course I certainly learned new ideas, especially in terms of performance and scalability.

Jayasurya P.

Just wanted to say thank you to Mitchell, I have taken several courses regarding Power BI and MS SQL server technologies and I really enjoy how he explains all the content, there is clarity and structure, I feel engaged with the course.

Jordi A.

I really like the fact that there were overviews of other features like MDM. I really learned a lot from this course!!! THANKS!

Robert K.

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.

 

Bonus:

• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!