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

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

"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

"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

Atlanta Master SSIS Workshop

Duration: 2 Days
Location: 1125 Sanctuary Pkwy., Suite 300
Alpharetta, GA 30009
  • 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

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

Training Course Prerequisites

Hardware and Software requirements:

  • Beginners Knowledge of SSIS
  • Microsoft Windows XP Professional, Windows 7 or Windows 8
  • 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 or AdventureWorks2012 and AdventureWorksDW2008 or AdventureWorksDW2012 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 and 2012 users the SSIS2008Class.zip file should be unzipped to C:\SSIS2008Class

Please Note:Every Workshop has a vegetarian lunch option

Terms & Conditions

Cancellation or rescheduling with less than 1 week email notice is subject to a cancellation/reschedule fee of 100% of the total price. Please contact Sales at sales@pragmaticworks.com or call at 904-638-5743 if you need to cancel or reschedule a class.

Training Course 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)
    • Hands-On Lab: Loading a Dimension
  2. Loading a Fact Table
    • Tactics for quickly loading a fact table
    • When do you stage and when do you use in-memory processes?
    • Hands-On Lab: Loading a fact table
     
  3. Creating an Incremental Load Pattern
    • Effecectivily loading massive amounts of data incrementally
    • Using change data capture (CDC) in SQL Sever and SSIS 2012 and 2008
  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. Scaling Out SSIS
    • Loading large amounts of data in parallel
    • Creating and using a queue system
  6. 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
Copyright 2014 by Pragmatic Works