Short course on Microsoft SQL Server Integration Services (SSIS) Regular Course Price: £200.00   
Total Duration: 5 Hours
Course level: Beginner to Intermediate
Delivery Method: Instructor Led Online Training
Certification: Certificate of Completion will be provided after completing the course

Course Overview:
Our SQL Server Integration Services (SSIS) is an instructor-led classroom based training course that teaches attendees how to perform data integration and transformation by using SSIS. At the end of this course attendees will have a good understanding of SSIS concepts and creating SSIS packages.

Skills Required

This course is suitable for those who already have basic knowledge on Microsoft SQL Server database and table design, SQL, T-SQL and Stored Procedure. Our Database Design with Microsoft SQL Server Training Courses cover all of the prerequisites.

Course Dates, Prices & Enrolment

Training
Method
Dates and Times
(in the UK)
Dates and Times
(if not in the UK)
Price 
Online Training using Zoom 22 Jun 2021 - 23 Jun 2021
Tuesday & Wednesday
11am - 1:30pm
Start Date & Time
End Date & Time
£150 £200
Enrol Now

Full Course Outline

  1. Introduction to SSIS
    • SSIS Basics
    • SSDT Introduction
    • Connection Managers
    • Basic SSIS Package
  2. Control Flow
    • Control Flow Basics
    • Tasks
    • Precedence Constraint
    • Containers
  3. Containers
    • Four types of container
    • Basic FOR loops
    • Foreach loops
    • Looping over files
    • Looping over records
    • Other foreach loops
  4. Data Flow – I
    • Data Flow Basics
    • Data Sources - I
    • Data Sources – II
    • Excel, XML, Raw File
    • Data Destinations
    • OLEDB, Excel, Flat File
  5. Data Flow – II
    • Data Flow Transformation – Introduction
    • Row Transformation
    • Character Map, Copy Column
    • Aggregate, Sort
    • Split and Join Transformations
    • Conditional Split, Multicast, Union All, Merge Join
  6. Data viewers
    • Attaching data viewers
    • Using dead-end destinations

Booking Request

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:

You must need to Register / Sign In first to submit this booking request form.

Career Path

This is a possible career path after completing this course:
BI Developer / Data Warehouse Developer > Senior BI Developer / Integration Consultant

Course Tutors

The course is working as an independent SQL BI consultant in the UK. He is a specialist consultant for building CI (Continuous Integration) solution for BI projects (SSIS, SSRS). He has considerable years of experience with the UK Financial Services Industry (Mainly in Insurance and Investment Banking). He has been presenting sessions in SQLBits, SQLPass and London SQL Server user Group since 2015.

Save Money with Packages

SAVE more than 15% by booking this course with other related courses as shown below:

Newsletter Sign-up

Have a Question?