SQL Server training -  Integration Services

SSIS Training

Integration Services (2 days)

£695 + VAT for most venues (£795 + VAT for London)

SQL Server Integration Services (often abbreviated to SSIS) allows you to automate the import, export and conversion of data. Whether you want to fill your data warehouse each evening with that day's transactions (whatever they may be) - or simply learn how SSIS fits into the wider SQL Server picture - this course is for you!

Refreshingly, the course doesn't use any large, impenetrable Microsoft database, but instead uses a simple Wise Owl one, and the exercises use simulated examples of real-life tasks.

Course details

  • Locations for Integration Services coursesLocations:London, Manchester
  • Next Integration Services course locationNext course:Tue 04 October 2016
  • Integration Services course timesTime:09.30-16.30

Course Contents

SSIS basics

  • Training topicSolutions and projects
  • Training topicBasic packages
  • Training topicTwo ways to run packages

Data flow tasks

  • Training topicConnection managers
  • Training topicSources and destinations
  • Training topicExcel, OLEDB and flat files

Data transformations

  • Training topicSorting and aggregating
  • Training topicFully and partially blocking
  • Training topicSampling data

Data viewers

  • Training topicAttaching data viewers
  • Training topicUsing dead-end destinations

Variables

  • Training topicThe Row Count transform
  • Training topicSystem variables
  • Training topicChanging scope

Expressions

  • Training topicExpression syntax
  • Training topicData types and casting
  • Training topicConditional split transforms
  • Training topicDerived column transforms

Lookup transforms

  • Training topicFull and partial caching
  • Training topicRedirecting unmatched rows
  • Training topicCache Connection Managers

Containers

  • Training topicFour types of container
  • Training topicBasic FOR loops

Foreach loops

  • Training topicLooping over files
  • Training topicLooping over records
  • Training topicOther foreach loops

Scripting

  • Training topicScript tasks
  • Training topicScript components
  • Training topicThe variable dispenser

Controlling flow

  • Training topicPrecedence constraints
  • Training topicEvent-handling

Managing errors

  • Training topicRedirecting and ignoring errors
  • Training topicDealing with truncations

Covered if time allows If time

Overview of logging

  • Training topicLogging to text files
  • Training topicLogging to SQL Server

Deployment

  • Training topicProject-level deployment
  • Training topicCreating an SSIS Catalog

Parameters and environments

  • Training topicPackage and project parameters
  • Training topicCreating and using environments

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"The trainer is very friendly and helpful."

Wenlong Wang (Hometrack Data System )

"Trainer was very good, with an informal delivery. Good selection of refreshments. Meal out was good touch; better than cheap sandwiches. Location is literally 2 mins from Piccadilly."

Stephen Hope (UK General Insurance)

"Course was very good. Content of database better than normal. Lunch was nice as well."

James Van Sluis (NHS North of England Commissioning Support Unit)

"Interesting and lots of useful content. Going out to lunch creates relaxed friendly atmosphere. Only course of its kind available for the price. I’ve since been recommending your courses around the office too, so hopefully you’ll see some more HSCIC staff soon enough!"

Lewis Cameron (Health and Social Care Information Centre)

"Really useful course and pitched at the level I anticipated. Thanks."

Jefferson Hardy (Leicestershire County Council)

There are lots more where these came from (or just refresh this page to change the quotes shown).

You must have a basic understanding of SQL and SQL Server to attend this course (you don't need to be a rocket scientist; just be able to navigate your way round a SELECT statement).  This course uses SQL Server 2012 (although if you're using 2014 you'll find it just as useful, as there are virtually no differences between the versions).

If you're using SQL Server 2008 R2 you should be aware that there are differences between the versions, but it is our opinion that 80-90% of the course will still be useful.  Alternatively, you could consider booking onsite training in SSIS 2008 R2 (or even 2005!).

Related Courses

Reporting Services

Introduction

2 day course

Introduction to SQL

Basic

2 day course

Advanced SQL RECOMMENDED

Advanced

2 day course

Other SQL Server Integration Services training resources

SSIS exercises

SSIS exercises

We've published all of our Integration Services exercises online to allow you to inspect them before booking this introduction to SSIS course.

View SSIS exercises

SSIS videos

SSIS videos

You can learn particular aspects of creating SSIS packages by following one of the videos we've created and put online.

View Integration Services videos

SSIS blogs

SSIS blogs

Have a look at the various blogs we've published on all things SQL Server Integration Services.

View SSIS blogs

This page has 0 threads Add post