Advanced
Login or Register
Advanced

Course 6235A: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

  • Duration: 24 hours
  • Level: Professional
  • English
  • Type: Courses

What you'll learn?

  • Describe SQL Server Integration Services and its tools.
  • Create an Integration Services package.
  • Implement control flow in an Integration Services package.
  • Implement data flow in an Integration Services package.
  • Implement logging in an Integration Services package.
  • Debug and implement error handling in an Integration Services package.
  • Implement checkpoints and transactions in an Integration Services package.
  • Deploy an Integration Services package.
  • Manage and secure an Integration Services package.

Description

This course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

Audience :

This course is intended for information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2008 Integration Services.

Topics :

Introduction to SQL Server 2008 Integration Services

Overview of SQL Server Integration Services

Using Integration Services Tools

Developing Integration Services Solutions

Creating an Integration Services Solution

Using Variables

Building and Running a Solution

Implementing Control Flow

Control Flow Tasks

Control Flow Precedent Constraints

Control Flow Containers

Implementing Data Flow

Data Flow Sources and Destinations

Basic Data Flow Transformations

Advanced Data Flow Transformations

Data Flow Paths

Implementing Logging

Overview of Integration Services Logging

Enabling and Configuring Logging

Debugging and Error Handling

Debugging a Package

Implementing Error Handling

Implementing Checkpoints and Transactions

Implementing Checkpoints

Implementing Transactions

Configuring and Deploying Packages

Package Configurations

Deploying Packages

Managing and Securing Packages

Managing Packages

Securing Packages

Prerequisities :

Recommended Knowledge :

Before attending this course, students must have: Exposure to enterprise data import and export scenarios; Experience navigating the Microsoft Windows Server environment; Experience with Microsoft SQL Server, including: SQL Server Agent, SQL Server query language (SELECT, UPDATE, INSERT, and DELETE), SQL Server System tables, SQL Server accounts (users and permissions).

Recommended Course(s) :

Category :

  • Database

Training Materials :

Microsoft Official Courseware (MOC)

Labs :

This course includes several labs to ensure you will gain the targeted skills and experience.

Credential :

This course, along with other courses, qualifies for Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Course Features

  • Duration 24 hours
  • Language English
  • Level Professional
  • Type Courses
  • Delivery Method Classroom
  • Code MS03-6235A

Categories

Learning Categories

Learning Providers

Learning Solutions

Support

About YAT

All contents copyright 2020 YAT, Inc. All rights reserved    

         Terms & Conditions    Privacy Statement