Object and Data Labs
  Certificates   Free Newsletter   What's New   Contact
              Sitemap
Main Areas
Onsite Training
Courses
Class Schedule
Registration
Tuition Discounts
Technology Library
Our Instructors
Our Customers
Why Object & Data Labs?

Hot New Courses:
XML: A Comprehensive Introduction
Disaster Recovery Planning

How students rate us

Free Newsletter
Visit our technology library and sign up to receive the latest word in technology from industry specialist.

Certification Available
Visit our certification page to see how you can be on the fast track to certification in advanced technologies.
  Home > Courses > Course Descriptions Print Page
Course Description

ETL Solutions Using Microsoft SQL Server 2005 Integration Services

Course Objective


In-House Training for as few as 3 Attendees >>

Or Call Toll Free
1-888-230-9052

With SQL Server 2005 release of SQL Server Integration Services (SSIS), developers will need to throw existing knowledge out of the window and be prepared to start a new. This is because the SSIS environment has progressed from existing as a side-note feature of SQL Server to becoming a new enterprise-strength Extract Transform and Load (ETL) tool.

The ability to design and develop efficient and manageable ETL processes with SSIS can lead to tremendous savings in time and effort.

This Four-day instructor-led course provides students with the knowledge and skills necessary to successfully design, develop and deploy ETL solutions using SSIS.

Note: This course is not intended to teach students how to design data warehouses. Rather, it focuses on the population and maintenance of data warehouse structures with SSIS.

What you will learn

  • Ways to quickly move and transform data
  • How to configure every aspect of SSIS
  • How to interface SSIS with web services and XML
  • Techniques to scale the SSIS and make it more reliable
  • How to migrate DTS packages to SSIS
  • How to create your own custom Tasks and user interfaces
  • How to create an application that interfaces with SSIS to manage the environment
  • A detailed usable case study for a complete ETL Solution

Who should attend

  • This course is intended for developers, DBA’s and users who hope to use SSIS for transforming data, creating workflow, or maintaining their SQL Server

Prerequisites

  • Be familiar with SQL Query
  • Have rudimentary programming skills
  • Dimensional modeling understanding
  • Data warehouse fundamentals
  • Have basic knowledge of the Windows operating system and platform

 

Onsite Training  Class Schedule  Registration

 

  Home | Courses | Class Schedule | Registration | About Us | Contact Call us TOLL FREE at 1-888-230-9052
Copyright 2003-2013, Object & Data Labs All Object & Data Labs Courses are certified courses with UC Berkeley & UCSC extension 

Website by Howard Pugh Web Design
Website maintained by Ann T. Comey