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. 

Hone Your SQL Expertise

Remote SQL Server, SharePoint and Performance Tuning training classes saving you time and money.  We offer morning and afternoon sessions providing less time away from work at a fraction of the cost.   

 

Increase BI Knowledge in 1 Week

The Pragmatic Works BI Quick Start provides hands on labs teaching you how to build a fully functional prototype data warehouse using SQL Server. We train you on the complete Microsoft BI Platform: SSIS, SSAS, SSRS, and SharePoint BI in 5 days. Our  Business Intelligence courses are taught in major cities throughout the United States.

 

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
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
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
Virtual Training

"I'm impressed by the number of examples involved in the training, the affordability of the class, and more than anything, the fact that I can keep a video recording of the training after it's over. Pragmatic Works is the first place I look to and recommend for SQL training. "

Jason Hurley

Virtual Training

"The best providers of high quality Microsoft BI related virtual and on-site classes. Their assistance during class, hands-on approach as well as post-class help made for a great experience"

Cosmin Ioan
Sr. Data Architect at Acquinity Interactive

Virtual Training

"This is the class that got me going on SSRS. The format: a unique combination of an online class where you still could interact personally with the instructor. The class content: Starting from scratch so everyone can keep up. The instructor: I have also taken other Pragmatics webcasts and these people are specialized in BI"

-Philip Leduc

Virtual Training
If you have become or expect to become responsible for SQL Server Analysis Services in your shop you owe it to yourself to take this course.

Bryant Byrd,
Sr. BI Systems Analyst
Eastman Chemical Company

Chicago SSIS Workshop

Duration: 2 Days
Location: 200 East Randolph Drive, Suite 200
Chicago, IL 60601

SSIS Training

  • Introduction to SSIS
  • Data warehouse loads
  • Performance tuning SSIS
  • Advanced data cleansing
  • Scripting in SSIS
  • Deploying and administering SSIS

Training Course Sections

Instructor Date/Time Cost Registration Link

Training Course Overview

During this 2 day course, you will learn how to use SSIS 2005 or 2008 in your enterprise. This class takes you from the ground-up, teaching you the fundamental skills you need to develop and deploy SSIS solutions and present this new data to your end users. This class is presented in SQL Server 2008 but is appropriate for those using SQL 2005 as well. Some of the topics covered in this class are: How to make your SSIS packages dynamic, how to create a package for looping, how to load a Data Warehouse, performance tuning, deploying and administration, and migrating from DTS. If you would like to use a computer to follow along with the demos, please bring your own laptop, we do not provide them.

Training Course Prerequisites

Hardware and Software requirements:

  • Microsoft Windows 2000 Professional, or Microsoft Windows XP Professional, Microsoft Windows, Windows 7
  • Server 2003/2008, Microsoft Vista operating system
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer Edition, Standard Edition or Enterprise Edition with the client tools, SSIS and SSRS.
  • AdventureWorks2008 and AdventureWorksDW2008 databases installed on the instance found at www.codeplex.com
  • Download the class files (email will be sent to you with this link).
  • This file contains the labs for the class that can be worked on post class.
  • For 2005 users the SSIS.zip file should be unzipped to C:\SSIS.
  • For 2008 users the SSIS2008Class.zip file should be unzipped to C:\SSIS2008Class

Please Note:Every Workshop has a vegetarian lunch option

Terms & Conditions

A full refund will be provided with seven days advanced written notice prior to the event. Cancellations less than seven days prior to the event will receive Pragmatic Works credit towards another Workshop, Advanced Online Training or Software purchase.

Training Course Outline

Day 1 – Introduction to the SSIS Features In-Depth

  1. Introduction to the SSIS environment
    • Give a demonstration of Business Intelligence Development Studio (BIDS) and SQL Server Development Tools (SSDT)
    • How to create a shared connection
  2. Control Flow Tasks
    • Overview of the commonly used tasks
    • Hands-on Lab: Create your first package
  3. Drilling into the Data Flow
    • Overview of the commonly used transforms, sources and destinations
    • Hands-on Lab: Creating your first data flow.
  4. Expressions and Variables
    • The scoping of variables
    • The expression language in SSIS
    • Debugging SSIS with the watch window
    • How to use variables and expressions to make a package dynamic
    • Hands-on Lab: Creating a dynamic package using variables
  5. Containers
    • Using the various containers
    • Looping through tasks
    • Hands-on Lab: Looping through a series of tasks
  6. Data Cleansing and Quality in SSIS
    • Writing common SSIS scripts
    • Using the Data Quality Client and DQS Cleansing Task in SQL Server 2012
    • Hands-on Lab: Cleansing Data with the Script Transform
  7. Configuring SSIS Packages with Configuration Files
    • Using configuration files to externalize configurations
    • Using tables to externalize configurations
    • Hands-on Lab: Configuration packages

Day 2 – Data Warehousing and Administration

  1. Loading a Data Warehouse
    • Designing a basic data warehouse
    • Loading a fact table
    • Loading a dimension with the SCD Wizard
    • Change data capture (CDC)
    • Hands-On Lab: Loading a Dimension
  2. Loading a Fact Table
    • Tactics for quickly loading a fact table
    • Hands-On Lab: Loading a fact table
  3. Event Handling and Logging in SSIS
    • Event Handlers
    • Logging Providers
    • Hands-on Lab: Creating a basic event handler
  4. 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
  5. Deploying and Administering SSIS
    • Using the command-line utilities (dtexec)
    • Deploying a package
    • Running a package in TSQL
    • Configuring a package in SQL Server 2012
    • Scheduling SSIS packages
    • Security in SSIS
    • Hands-on Lab: Deploying and scheduling a series of packages
  6. Migration to SQL Server 2012
    • Process of migrating a package to SQL Server 2012
    • Issues that you will encounter
    • Converting to Project Deployment Model
  7. Advanced Transforms
    • Fuzzy Grouping transform
    • Fuzzy Lookup transform
    • Term Extraction transform
    • Term Lookup transform
    • Import and Export Column transform
    • Hands-on Lab: Term Extractions, Term Lookups, Export Column and More
Copyright 2014 by Pragmatic Works