img

SQL Server Integration Services (SSIS) Training Course

SQL Server Integration Services (SSIS)

  • $449.00
  • 8 hours
  • Beginner to Intermediate
  • Instructor Led Classroom Training
  • SQL Server Integration Services (SSIS) training 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.

Career Path

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

  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
A photo of Younus

Younus Kazi

Younus has over 18 years experiences in working and teaching IT in both public and private organisations. His specialities include Web design, development, software development and project management. He graduated from London Metropolitan University in Computing and Information Systems. He is also a Microsoft Certified Application Developer (MCAD).

Subscribe To Our Onlinesletter

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor