• Venue
  • Register
  • FAQs
  • Contact
  • Time Zone

SQL Server Integration Services (SSIS) Advance

Batch Price From £240 (approx. $298 USD) View Dates & Prices
Custom Price From £160 (approx. $199 USD) Price Calculator & Booking Short course on Microsoft SQL Server Integration Services (SSIS)
Total Duration: 8 Hours
Course level: Intermediate to Advanced
Delivery Method: Instructor Led Classroom Training
Certification: Certificate of Completion will be provided after completing the course

Course Overview

This course will help students to build the SSIS packages to extract, transform and load operations for a data warehouse. It details the methodologies for managing high-volume, slowly changing dimensions and for handling XML files.
In addition, it covers the design patterns to load data for dimension and fact tables. Also this course helps the students to deploy the packages to production and execute the packages.

Requirements

This course is suitable for those who already have basic knowledge of SQL Server Integration Services. Our SQL Server Integration Services (SSIS) Training Courses cover all of the prerequisites.

Course Dates, Prices & Enrolment

All Training Physical Classes Virtual Classes
Time Zone:
Training MethodDates and TimesPrice 
Online Training using Zoom 23 May 2024 - 24 May 2024
Thursday & Friday
05:00 AM - 09:00 AM ET 		£240 £280
(approx. $298 USD) 		Full
Classroom Training 11 Jun 2024 - 13 Jun 2024
Tuesday & Thursday
05:00 AM - 09:00 AM ET 		£280
(approx. $348 USD) 		Enrol Now

Course Content

  1. Advanced Integration Services - I
    • Advanced Control Flow
      • Using XML Files
      • Using Web Service in SSIS
      • 32 bit Vs 64 Bit
      • SQL Task to return single / multiple columns / record set
      • Using SQL Task in Control flow
  2. Advanced Integration Services - II
    • SSIS Expressions
      • Expression Introduction
      • Expression Builder & Functions
      • Using expression in precedence constraint
      • Operators and More Variables
      • Variables
      • Expression Usage
        • Connection Manager
        • SQL Statement
        • Precedence Constraints
    • Debugging SSIS Packages
      • Debugging - Basics
      • Breakpoints
      • Debug Windows
      • Script Task Debugging
      • Script Component Debugging
      • Data Viewer
      • Using the Grid Viewer
    • Logging & Error Handling in SSIS Packages
      • Package Logging
      • Different types of logging using SQL server, Flat file, XML
      • Logging in Control flow and Script Task
      • Error output in Data Flow task
      • Transaction Support
      • Checkpoints
    • Package Execution
      • Package execution utilities
      • DTEXEC
      • SQL Server Agent
  3. Introduction to Data Warehouse
    • Data Warehouse Basics
      • OLTP Vs OLAP
      • Star Schema / Snow flake Schema
      • Kimball Vs Bill Inmon
      • ETL Vs BI
      • ETL Tools
    • Dimension
    • Facts
    • Summary
  4. Developing SSIS Packages for Data Warehouse - I
    • ETL Design pattern
    • Extract package
    • Extracting to staging
    • Load Patterns
    • Fact extract for ongoing load
  5. Developing SSIS Packages for Data Warehouse - II
    • Slowly changing dimension
    • Dimension loading pattern for Type 0, Type 1 & Type 2
    • Dimension Load Design patterns
    • Fact table load design pattern

Price Calculator & Booking Request Form

Calculate prices for Corporate, 1-on-1 or group training and request a booking.

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

  • book a course on different dates
  • book for a group of delegates
  • book corporate training
  • book a customised training
  • book a one-on-one training

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:


Share This Course

Newsletter Sign-up

Have a Question?

Please read our frequently asked questions or contact us.

We are providing affordable IT training courses at times to suit you - enhance your employability and stand out from the crowd.

Become an IT expert and get that competitive edge that employers are looking for.

Popular Courses

Useful Links

Contact Us

London Academy of IT
Unit 15, Boardman House
64 Broadway
Stratford
London E15 1NT
United Kingdom
UK: +44 (0)208 432 6218
USA: +1 610-234-7870
CANADA: +1 416-900-1211

Share this page now!

2012 - 2024 © London Academy of IT Limited. All Rights Reserved.
Registered in England & Wales with company no. 07923992.