Performance Tuning Workshop
Class was overflowing with value delivered by extremely competent professionals and instructors and I have walked away truly enriched by it.

- Zoran Cvijetic
Sr. SQL Server DBA /
Database Systems Architect
20th Century Fox
Master SSIS Workshop
I have taken probably 50 training classes in my career and this one was, by far, the best one I've taken. Perfect match for what I was looking for. Great job!

- Peter Tassmer, ConnectiCare

Performance Tuning Workshop
If you have the time and money, please take the workshop. You might even learn something like this old IT guy did.

-John F Miner III, Senior SQL Developer at Total Quality Management
Fine Tune Your SQL Skills in 2 Days

Join Pragmatic Works as we tour the country with our live two-day sessions on SSIS, SSRS & Performance Tuning.  We target major cities providing affordable SQL training courses sure to be near your local home base. 

Microsoft SQL industry experts delivering quality training. 

Master SSIS Workshop

Duration: 2 Days
  • How to load a data warehouse
  • How to performance tune SSIS
  • Advanced data cleansing patterns
  • Scripting in SSIS
  • De-duplicating data with fuzzy logic
  • Implementing an SSIS framework
  • Many, many SSIS patterns

Overview

During this 2 day advanced SSIS training course, you will learn how to use SSIS 2005, 2008 and 2012 in your enterprise to solve common extract, transform and load (ETL) challenges. This class assumes you know the basics of SSIS and takes you from the novice level to a more effective, advanced ETL developer. Much of this class focuses on implementing common real-world SSIS patterns taught from the experts of SSIS. You'll also learn how to performance tune SSIS. Be prepared for a very in-depth day of SSIS that gets advanced in many areas.

Scheduled Classes

Class Date/Time Location Cost Details Purchase
Orange County Master SSIS Workshop 5/20/2014 - 5/21/2014
8:30 AM - 5:00 PM
Microsoft Office
3 Park Plaza, Suite 1600
Irvine, CA 92614 
$399.00

Outline

Day 1

  1. Loading a Dimension Table
    • Designing a basic data warehouse
    • Loading a fact table
    • Loading a dimension with the SCD Wizard
    • Change data capture (CDC)
    • Upsert Patterns
  2. Loading a Fact Table
    • Tactics for quickly loading a fact table
    • When do you stage and when do you use in-memory processes?
  3.  
  4. Creating an Incremental Load Pattern
    • Effecectivily loading massive amounts of data incrementally
    • Using change data capture (CDC) in SSIS 2012 and 2008
  5. Performance Tuning SSIS
    • Overcoming common performance problems in SSIS
    • How to use the new SSIS 2008 and 2012 features to synchronize systems like Change Data Capture and the Merge statement
    • Measuring performance in SSIS
  6.  
  7. Scaling Out SSIS
    • Loading large amounts of data in parallel
    • Creating and using a queue system
  8. Restartability Patterns in SSIS
    • Using transactions in SSIS
    • Using checkpoints in SSIS

Day 2

  1. Scripting in SSIS
    • Common Script Task patterns
    • Integration into 3rd party DLL files
    • Common Script Component patterns in the SSIS data flow
  2. Data De-Duplication with Fuzzy Grouping and Lookup
    • Using the Fuzzy logic in SSIS to de-duplicate badly spelt names
  3. Term Extraction and Lookup Patterns
    • Using the Term Extraction transform to find the buzz about a given product
  4. Upgrading to SQL Server 2012 SSIS
    • What's new in SQL Server 2012 SSIS
    • Upgrading to the project deployment model
    • Deploying packages in project deployment model
    • Configuring and administering packages
  5. Integrating Data Quality Services (SQL 2012) into SSIS
    • Learn how to use DQS to cleanse data without SSIS
    • Learn how to integrate the same pattern into SSIS
  6. Creating a Master Package Pattern
    • Creating a framework to simplify your package execution
    • Creating a logging framework
  7. SSIS Integration into SSAS
    • Loading a cube in SSIS
    • Repartitioning a cube
  8. End of Day Smackdown
    • Don't miss our end of day smackdown to recap the training

Prerequisites

The target audience of this class are developers, architects or IT professionals who have basic SSIS skills. This class assumes you know the basics of SSIS and takes you from the novice level to a more effective, advanced ETL developer. We recommend our Pragmatic SSIS class for those new to SSIS. Having a basic understanding of VB will help but is not required for this course.

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 (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) or Business Intelligence Development Studio (SQL 2008/2008R2)
    • SQL Server Management Studio
    • Data Quality Services (SQL 2012 only)
    • Data Quality Client (SQL 2012 only)
    • Follow this installation guide to ensure all items are installed correctly
  • 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

Terms & Conditions

Class Recordings

A class recording will be available via the web for a limited time for students who missed a session. Recordings are copyright protected and may not be distributed to others.

One Student Per Seat

We limit the number of students in each class to maintain a proper student to instructor ratio. Each purchased seat in a Virtual Training class is for use by one student only.

Cancellation/Rescheduling Policy

Students must provide at least 14 days’ notice to reschedule or withdraw from a class. In the case of withdrawal a credit will be issued for another Virtual Training class of similar value. Cancellation/reschedule with less than 14 days’ notice is subject to a fee of 100% of the total price.

We reserve the right to cancel or reschedule a class up to 2 weeks prior to the start date. Any students in a cancelled or rescheduled class have the option of a refund or credit to be used for another Virtual Training class of similar value.

Copyright 2014 by Pragmatic Works