www.jbinternational.co.uk sales@jbinternational.co.uk Call Free 0800 028 6400

JB International 1345 High Road London, N20 9HR +44 (0) 20 8446 7555

 

SQL Server 2008 Integration Services (SSIS) Training Course UK

Dates and full course list

SQL Server 2008 Integration Services (SSIS) Training Course Overview

Course Code:	SQL0230
Price:	£500
Duration:	1 day
DATE:
Who should attend:	Anyone interested in getting raw data to the end user as information that has integrity, is retrieved quickly and requires little or no programming.
Prerequisite Skills:	Delegates should have some basic knowledge of SQL language queries.

Microsoft SQL Server Integration Services (SSIS) is a key Business Intelligence component of Microsoft SQL Server 2008. It supersedes Data Transformation Services (DTS).

The main function of SQL Server Integration Services is Data Warehousing...SSIS allows you to build data integration and workflow applications, and includes commercial-class features for data extraction, transformation, and loading (ETL).

SSIS can also be used for automating maintenance of SQL Server databases, update multidimensional cube data.

See also our full 5-day Business Intelligence with SQL Server 2008 training course

Course Content

This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email

SQL Server 2008 Reporting Services Training Course Outline

Introduction to SQL Server Integration Services (SSIS)

Using SSIS Wizards
Using SSIS Designer
Using SSIS to normalise data
Using SSIS to denormalise data
Using SSIS to process cubes
Using SSIS as an ETL Tool
DataFlow tasks

Running and saving SSIS

Scheduling SSIS packages
Running from stored procedures
Saving to SQL Server
Saving to file

Data Mining

Introduction to Data Mining
Deployment
Perspectives
Actions
Write-back

Associated Courses

Microsoft Business Intelligence Training Course: SQL Server 2008 / 2008 Analysis and Integration Services (SSAS / SSIS)
Advanced SQL Server Analysis Services Training Course
SQL Server 2008 / 2008 Reporting Services Training Course
Advanced Microsoft Business Intelligence with SSAS & PerformancePoint Server 2007 Training
Microsoft Performance Point 2007 Training Course - Visualising Business Intelligence

SQL Server 2008 Upgrade Training Course for existing SQL Server 2000 / SQL Server 2008 users

SQL Server 2008 Applications Development training course
SQL Server 2008 Database Administration Training Course
SQL Server 2008 Comprehensive Upgrade Training Course for existing SQL Server 2000 / Oracle / MySQL users

SQL Server 2000 Applications Development training
SQL Server 2000 Database Administration
SQL Server Performance Tuning
SQL Server OLAP, DTS & Cubes Training
SQL Design and Information Retrieval