Online Course: SQL Server Integration Services End to End

12 Sessions Brought to you by SSWUG.ORG

Open October 30th 2015 and Closes After November 29th, 2015

Course Overview

In SQL Server 2005 Microsoft introduced SQL Server Integration Services, SSIS, as the replacement to Data Transformation Services, DTS and the primary ETL tool for developers. Over the past 9 years SSIS has evolved and now includes tasks and transformations for Change Data Capture as well as Data Quality Services. This workshop is meant to serve as a tool to prepare for the Microsoft 70-463 exam, Implementing a Data Warehouse with Microsoft SQL Server 2012, as well as provide a comprehensive source of training for SSIS. As there have been changes in SSIS each session points out the differences between each version of SSIS beginning with 2005 through 2014. This workshop is broken into 12 different modules:

Module 1: Introduction to a Data Warehouse
Module 2: ETL
Module 3: Introduction to SSIS
Module 4: Introduction to Control Flow
Module 5: Connection Managers
Module 6: Introduction to Data Flow
Module 7: Advanced Control Flow
Module 8: Advanced Data Flow
Module 9: SSIS Script Tasks and Components
Module 10: Troubleshooting and Debugging
Module 11: Data Quality Services and Master Data Services
Module 12: Deployment Models

Each module covers specific topics relating to SSIS and data warehousing which are presented in the exam as well as in depth examples and real life demonstrations.

All demonstrations are done using the Adventureworks2012 and AdventureworksDW2012 sample databases available
here

To complete all demonstrations only requires SQL Server Enterprise, Enterprise Evaluation, or Developer Edition

Developer Edition is available here

Watch Video

Course Structure/Cost

Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the sessions, as well as a link that will remain active for the 30 day on-demand period.

The course cost is $169 for full SSWUG.ORG members, $199 for non-members and free for PRO members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, office hours and the ability to email questions to the instructor are included with course purchase only.

 

Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form

Other Events

  • Does your company have more than 1 person interested in this class? Take advantage of immediate savings by completing the group registration process. To start the group registration process downoad our form here.


Speakers

    David Dye

    David’s primary focus and expertise is with SQL Server, reporting services, integration services, and analysis services, and he was recognized f...