Training in MSSQL Server 2005: Implementing and Maintaining SQL Server 2005 Integration ServicesAhana Systems & Solutions (P) Ltd.
Price on request
In this program, students will study the below enumerated lessons:
Lesson 1: Preface of Structured Query Language Server 2005 Integration Services
This lesson explains the function that Integration Services performs in extraction, transformation, & loading of information. This lesson further explains the instruments, which one can utilize to create & administer Integration Services solutions.
* Summary of Integration Services Solutions
* Integration Services Instruments
Lesson 2: Expansion of I.S.S.
This lesson offers an outline of the growth functions that are included in building an Integration Services package. After completion of this lesson, students will be capable in creating a fundamental package.
* Building of an I.S.S.
* Variables Usage
* Creation & Administration of a Solution
Lesson 3: Control Flow Implementation
This lesson explains the functions & preference Restraints which one can bring into practice to apply control flow in an I.S.P..
* Control Flow Functions
* Control Flow Preference Restraints
* Control Flow Containers
Lesson 4: Information Flow Implementation
This lesson enumerates the information flow sources, Conversions, and Targets which one can utilize to execute an information flow function in an Integration Services control flow. It further enumerates the process of using information route to guide suitable & unacceptable rows throughout the information flow.
* Information Flow Sources & Targets
* Information Flow Conversions
* Information Flow Routes
Lesson 5: Implementing Logging
This lesson talks about the usage of logging in an I.S.P., & enumerates the process of configuring & using logging suppliers for generating data regarding package's implementation
* Summary of Integration Services Logging
* Logging Implementation
Lesson 6: Debugging & Mistakes Management
This lesson describes about debugging Integration Services package by utilizing the debugging instruments in Commercial Intelligence Development Studio. It further describes the ways of mistakes-control logic implementation in an Integration Services package.
* Package Debugging
* Mistakes Management Implementation
Lesson 7: Checkpoints & Proceedings Implementations
This lesson enumerates the nature of checkpoints & their implementation. It further talks about Proceedings, & enumerates the process with which one can apply transactional information access reason in an Integration Services package.
* Checkpoints Implementations
* Proceedings Implementations
Lesson 8: Packages Deployment
This lesson talks about the process of creating Package arrangements & the deployment of Integration Services packages to production server.
* Configuring Package
* Packages Deployment
Lesson 9: Management & Security of Packages
* This lesson enumerates the managerial functions that are relevant to Integration Service packages & describes the process of performing those functions by utilizing the Integration Services management instruments. It also enumerates the ways of securing Integration Services packages.
* Packages Management
* Packages Security