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
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
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
Thank you guys so much for coming to Denver. That was the best DBA class I have taken. I really hope you're coming back next year to talk 2014!

- Michael Husler, NOAA Federal

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

Pragmatic SSIS 2005/2008/2008R2 (Online)

Duration: 4 Half Days
Location: Online
  • SSIS Features In-depth
  • Making your Package Dynamic
  • Data Warehousing
  • Administration and Migration to SSIS
NEW IN 2013: Now includes Virtual Mentor time!

Training Course Sections

Instructor Date/Time Cost Registration Link

Training Course Overview

A four (half day) class designed to help you understand the core concepts of SQL Server 2005 and 2008 Integration Services (SSIS), the ETL tool of choice for SQL Server DBAs. We will use a variety of lab exercises and small projects to ensure you gain familiarity in how the design and execution environments work and be prepared to build your own real world applications using this SQL Server subsystem. Students will learn how to use SSIS in the real-world. With the hands-on labs, you will learn how to create a SSIS package to load an OLTP or warehouse environment. You’ll also learn how to make the package dynamic to where it will work and self- heal in the event of a failure. This course gives detailed and extensive demos on how to use SSIS in your enterprise environment and how to extend SSIS with scripting. The labs are written in SQL Server 2008 but only a few screens are different in SQL Server 2005. IMPORTANT: Only take this class if you will be developing in the SSIS 2005/2008/2008R2 environments. There is a different class for the SSIS 2012 environment.

IMPORTANT: When you purchase a seat in this class you also receive 2 hours of our BI Virtual Mentor service for assistance with YOUR project work. This remote service lets you work ONE on ONE with our BI mentors to accelerate YOUR project and further improve YOUR skills. Your Virtual Mentor hours can be used during business hours anytime during the 12 months following your class. To set up a session, download this simple questionaire, fill it out, and send it as an attachment to mentor@pragmaticworks.com. This unique Pragmatic Works offering insures that your training will translate into real world success for YOUR projects.

Training Course Prerequisites

The target audience of this class includes developers, architects or IT professionals who have basic SQL skills already. This class assumes that you have no previous knowledge of DTS or SSIS. In some of the scripting chapters, it is helpful(but not mandatory) for the student to have some basic VB experience. You will need to know how to run a query inside of SQL Server 2005 or 2008.

System Requirements

  • Microsoft Windows XP, Microsoft Windows Server 2003, 2008, 2012, Microsoft Windows Vista, Windows 7, 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 Edition, Standard Edition or Enterprise Edition with the client tools, SSIS and SSRS.
  • AdventureWorks2008 and AdventureWorksDW2008 databases installed on the instance.

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.

Training Course Outline

Day 1 - SSIS Features In-depth

  1. Introduction to the SSIS environment
    • Give a demonstration of Business Intelligence Development Studio (BIDS)
    • How to create a shared connection
  2. 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, source and destinations
    • Hands-on Lab: Creating your first data flow
  4. Troubleshooting SSIS
    • How to diagnose a problem in SSIS
    • How to view data in flight
    • How to create a breakpoint in SSIS

Day 2 - Making your Package Dynamic

  1. Expressions and Variables
    • The expression language in SSIS
    • The scoping of variables
    • 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
  2. Containers
    • Using the various containers
    • Looping through tasks
    • Hands-on Lab: Looping through a series of tasks
  3. The Script Task and Transform
    • Writing common SSIS scripts
    • Replacing ActiveX Script Tasks in DTS with the Script Task
    • Hands-on Lab: Cleansing Data with the Script Transform
  4. Configuring SSIS Packages with Configuration Files
    • Using configuration files to externalize configurations
    • Using tables to externalize configurations
    • Hands-on Lab: Configuration packages

Day 3 - Data Warehousing

  1. Loading the 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 SSISEvent Handlers
    • How to use the new SSIS 2008 features to synchronize systems like Change Data Capture and the Merge statement
    • Measuring performance in SSIS

Day 4 - Administration and Migration to SSIS

  1. Deploying and Administering SSIS
    • The command-line utilities
    • Deploying a package
    • Scheduling SSIS packages
    • Security in SSIS
    • Hands-on lab: deploying and scheduling a series of packages
  2. Migration from DTS
    • Process of migrating a package to SQL Server 2005 SSIS
    • Issues that you will encounter
    • Migrating ActiveX Scripts
    • Hands-on Lab: Migrating a series of packages.
  3. Advanced Transforms
    • Fuzzy Grouping transform
    • Fuzzy Lookup transform
    • Term Extraction transform
    • Term Lookup transform
    • Import and Export Column transforms
    • Hands-On Lab: Term Extractions, Term Lookups, Export Column and More

Common Questions

  • Will I be able to ask the instructor a question? Of course! You are encouraged to participate in the class by asking questions and sharing your own case studies.
  • How large is each class? Each class has a maximum capacity of 20-24 seats each month, they do fill up quickly.
  • How would I receive individual attention? During the class, the conference line opens 30 minutes prior to the class to answer individual questions. If you still need more help, individual sessions can be scheduled during the week of the class for class-related questions.
  • How much time is required of me to take this class? Each class is 4 hours a day so you’ll still have time to answer your emails or go to a meeting or two. To get the most out of the class, it’s extremely important to do the class labs so you can ask questions if you have problems.
  • What if I miss a class? Each class is recorded and posted 24 hours after the class. The recording can be downloaded for up to 30 days after the class.
  • Is the number a toll free number? GoToMeeting supports Voice of IP (VOIP) or a toll number. It is recommended that you have a speaker phone if you dial in, or use a head set for your comfort if you use VOIP. It is also recommended that if you can, have a second monitor so you can participate in a lab on one screen while the web meeting is happening on another.
Copyright 2014 by Pragmatic Works