Training Course:SQL Server 2005 Integration Services (SSIS)School/Trainer:Software Training Academy
Toronto, Ontario, Canada
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' This course will enable technology professionals with little or no ETL experience and minimal exposure to SQL Server 2005 and Visual Studio 2005 to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development Studio (BIDS) and working with Control Flow and Data Flow. 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 Duration: 3 days
Prerequisites:This course assumes no prior knowledge of SQL Server Integration Services. This course does assume prior knowledge of SQL Server 2005 and basic use of SQL Server Management Studio. Other tools used in this course include Notepad, Microsoft Excel, and basic features of Windows.
1. A Guided Tour of SSIS
Understanding SSIS
Exploring and Executing an SSIS Package in BIDS
Exploring and Executing a Package in BIDS
2. Introduction to Control Flow
Overview of Control Flow in SSIS
Control Flow Tasks
Workflow Tasks
Other SQL Server Operations Tasks
Precedence Constraints
Data Processing Tasks
3. Introduction to Data Flows
Data Flow Overview
Data Flow Pipeline
Data Flow Sources
Data Flow Destination
Data Viewers
Data Flow Transformations
4. Variables and Configurations
Understanding Variables
Using Variables in Control Flow
Using Variables in Data Flow
Understanding Property Expressions
Using Property Expressions
Understanding Configurations
Using Configurations
Using Variables and Configurations between Packages
5. Advanced Control Flow
Advanced Control Flow Overview
Using Containers
Transactions Support in SSIS
Additional Control Flow Tasks
6. Error Logging and Handling
Error Logging and Handling Overview
Checkpoints
Package Logging
Event Handling
7. Advanced Data Flow
Synchronous Transformations
Asynchronous Transformations
Working with Error Outputs
Using Advanced Transformations
8. Package Deployment
Overview of Deploying Packages
Deployment Challenges
Create a Package Deployment Utility
The Package Installation Wizard
Deploy a Package to the File System
Deploy a Package to SQL Server
Redeploying Updated Packages
9. Package Management
Overview of Package Management
Managing Packages with DTUtil
Managing Packages with SQL Server Management Studio
Executing Packages
Scheduling Packages with SQL Server Agent
SSIS Security
10. Introduction to Scripting and Custom Components
Extending SSIS Capabilities Through Code
The SSIS Scripting
Scripting in Control Flows
Scripting in Data Flows
Script Compilation
Custom SSIS Components
11. Best Practices
Best Practices for Using SSIS
Best Practices for Package Design
Data Flow Best Practices
12. Beyond ETL: Other Scenarios for SSIS
Using SSIS Beyond ETL
Migrating SQL Servers with SSIS
SQL Server Maintenance Plans
Working with Analysis Services
Folder and File Management
Working with the Windows Event Log
...''
Please go to the school's official website for training price and schedule:
http://www.softwaretrainingacademy.com/
Phone:1-888-896-7852
School Address:
Toronto Star Building
1 Yonge Street, Suite 1801
Downtown Toronto
Ontario, Canada - M5E 1W7
Jobs & Resumes: Toronto
Houses & Roommates: Toronto
Travel Agencies: Toronto
Search other schools for SQL Server 2005 Integration Services (SSIS) training resources.
Other training courses offered by Software Training Academy:
Oracle 10g Advanced SQL
Oracle 10g Introduction to SQL
Oracle 10g PL/SQL Programming
Oracle Applications Using ADO.NET and C#
J2EE
Visual Basic for Applications (VBA)
Securing Java Web Applications
SQL Server 2005 Additional Topics
SQL Server 2005 Analysis Services (SSAS)
SQL Server 2005
SQL Server 2005 Reporting Services (SSRS)
SQL Server 2005 Transact SQL (T-SQL)
The Java Message Service
JSP Standard Tag Library
Using and Developing JavaBeans
XML Programming Using C# and .NET
XML Programming Using Java
XML Programming Using Visual Basic and .NET
XML Schema
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Facts:
We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa. |
|
|
