Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
Microsoft SQL Server 2008 Integration Services
with Don Kiely


View the Course Outline

This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques.

Course includes 36+ hours of total training time...

  • 12 modules of training
  • Over 12 hours of media run time
  • Over 675 pages of printable courseware
  • Step-by-step hands-on-labs
  • Sample code
Format Modules Retail Price
SQL Server 2008 Integration Services
CD-ROM

 12 CD-ROMs

$695.00  
CD-ROM & Books

 12 CD-ROMs + Printed Books

$839.00  
DVD-ROM

 1 DVD-ROMs

$695.00  
DVD-ROM & Books

  1 DVD-ROMs + Printed Books

$839.00  
Read about Don Kiely. .
Course Outline (Outlines are subject to change.)
Microsoft SQL Server 2008 Integration Services

Modules Run Time Pages
12 15 hours 675

This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques.

In this course you will learn...
  • How to use BIDS to create well-designed packages.
  • About Control Flows, how to build them using many of the built-in tasks, including the various containers.
  • How to use the Data Flow task to perform primary ETL operations.
  • About variable and configurations to make your packages dynamic and resilient to changes in environments.
  • About the features in BIDS and Integration Services that help you troubleshoot a package.
  • How to deploy and manage packages effectively.
  • How to write script so that you can go beyond the built-in tasks, data sources and destinations, and transformations, as well as building and using custom components.
  • Best practices that will make it easier to develop and maintain a package over its entire life cycle.
  • About using Integration Services for tasks other than traditional ETL operations.
Prerequisites:

This course assumes no prior knowledge of SQL Server Integration Services. This course does assume prior knowledge of SQL Server 2008 and the use of SQL Server Management Studio for development and administrative tasks. You should be able to create CRUD (create, retrieve, update, and delete) queries using T-SQL, understand basic relational databases design, run script files and diagnose problems that occur, and have experience building applications that access data stored in SQL Server. You must also know how to connect to an instance of SQL Server 2008 using the various connection dialog boxes in Management Studio and development tools.

Other tools used in this course include Notepad, Microsoft Excel, and basic features of Windows.

A Guided Tour of Integration Services

  • Understanding Integration Services
  • Exploring and Executing an Integration Services Package in BIDS
  • Exploring and Executing a Package Outside of BIDS
Control Flow
  • Overview of Control Flow in Integration Services
  • Working with Workflow Tasks
  • Precedence Constraints
Data Flows
  • The Data Flow Task
  • Data Viewers
  • Data Flow Transformations
Variables and Configurations
  • Understanding Variables
  • Using Variables in Control Flow
  • Using Variables in Data Flow
  • Configurations
  • Using Variables and Configurations between Packages
Advanced Control Flow
  • Advanced Control Flow Overview
  • Using Containers
  • Transactions Support in Integration Services
Error Handling and Logging
  • When Things Go Wrong
  • Checkpoints
  • Handling Errors and Debugging
  • Packaging Logging
  • Event Handling
Advanced Data Flow
  • Synchronous and Asynchronous Transformations
  • Using Advanced Transformations
  • Handling Slowly Changing Dimensions
Package Deployment
  • Deploying Packages
  • Create a Package Deployment Utility
  • Installing a Package
  • Redeploying Updated Packages
Package Management
  • Overview of Package Management
  • Managing Integration Services Packages
  • Executing Packages
  • Integration Services Security
Scripting and Custom Components
  • Extending Integration Services Capabilities through Code
  • Scripting in Control Flows with the Script Task
  • Scripting in Data Flows with the Script Component
  • Custom Integration Services Components
Best Practices
  • Best Practices for Using Integration Services
  • Best Practices for Package Development and Design
  • Data Flow Best Practices
  • Deployment and Management Best Practices
Going Beyond ETL
  • Using Integration Services Beyond ETL
  • Migrating and Maintaining SQL Servers with Integration Services
  • Working with Analysis Services
  • Working with Windows Management Instrumentation

back to top


Your Instructor


Don Kiely has been using and programming computers since the mid-1970s, when he first punched IBM punch cards for batch processing to solve engineering problems. Now Don is a nationally recognized author, instructor and consultant who travels the country sharing his expertise in SQL Server and security. He has written business software using assembly, C/C++, dBASE, Nantucket Clipper, RPG II, C#, and Visual Basic for a variety of industries, and has taught software and business administration courses at community colleges. Now Don is an author and presenter for AppDev, and a consultant for a variety of companies that develop distributed applications for public and private organizations. Don is also the author or coauthor of several programming books, and a featured speaker at SQL Server conferences

back to top


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy