SQL Integration Services

Approved by Habanero Data
SQL Server
next available:
January 11, 2021
Duration :
5 Day/s
DURATION
5 Day/s
USD $
650
USD
$ 650
NGN ₦
300,000
NGN
₦ 300,000

Course Information

Everything you need to know

  • Course Syllabus
  • Your trainer
  • Key Information

This 5 day course will give delegates a thorough study on using SQL Integration Services (SSIS). The course will teach delegates how to build simple as well as complex data integration solutions using Microsoft SQL Server Integration Services. The course covers all aspects of development, deployment and administration of SSIS packages. The course is based on SQL Server 2019. The course will teach delegates how to implement SQL Server Integration Services (SSIS) to export and import data between mixed data sources.

Delegates will learn how to carry out data cleansing tasks such as de-duplicating & fuzzy lookups. Further tasks covered include converging heterogeneous data sources through transformations such as merge and union. We will also look at splitting single data sources into transformations such as conditional split, handle multiple import files with containers such as for and foreach loops, and much more.

In this course you will learn about the Microsoft SQL Server Visual Studio development environment for design, creation and management of SSIS packages, and work with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL Integration Services.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: Basic knowledge of Business Intelligence and relational database systems.

Course Schedule: 5 Days, 40 Academic Hours
 
Course Syllabus:
 
Day 1
 
Introduction to SQL Server Integration Services (SSIS)

  • SSIS Overview
  • SSIS Architecture
  • Exploring SQL Server Data Tools
  • Creating a SSIS Solution and Project
  • Creating a Basic SSIS Package
  • Moving Data with the Import Export Wizard

 
Introduction to Control Flow

  • Overview of Control Flow in Integration Services
  • Connecting Control Flow with Precedence Constraints
  • Manipulating Files with File System Task
  • Coding Custom Script Tasks
  • Control Flow Tasks
  • Working with Workflow Tasks
  • Using Execute SQL Task
  • Using Execute Process Task
  • Using File System Task
  • Using Send Mail Task
  • Using FTP Task
  • Elements in Control Flow
  • Creating a Data Flow

 
Day2
 
Introduction to Data Flow

  • Data Flow Overview
  • Data Flow Pipeline
  • Extracting Data from Sources
  • Loading Data to a Destination
  • Changing Data Types with the Data Conversion Transform
  • Creating and Replacing Columns with the Derived Column Transform
  • Rolling up Data with the Aggregate Transform
  • Ordering Data with the Sort Transform
  • Joining Data with Lookup Transform
  • Auditing Data with the Row Count Transform
  • Combining Multiple Inputs with the Union All Transform
  • Cleansing Data with Script Component
  • Seperating Data with Conditional Split Transform
  • Alternating Rows with OLE DB Command Transform
  • Handling Bad Data with the Fuzzy Lookup Transform
  • Removing Duplicating with the Fuzzy Grouping Transform
  • Data Viewers
  • Data Transformations

 
Variables and Configurations

  • Understanding Variables
  • Using Variables in Control Flow
  • Using Variables in Data Flow
  • Understanding Property Expressions
  • Using Property Expressions
  • Understanding Configurations
  • Using Configurations
  • Using Variables and Configurations between Packages

 
Day 3
 
How to make SSIS Packages Dynamic

  • Making a SSIS Package Dynamic with variables
  • Making a Connection Dynamic with Expressions
  • Making a Task Dynamic with Expressions

 
Containers

  • Using Sequence Containers to Organize a Package
  • Using for Loop Containers to Repeat Control Flow Tasks
  • Using the Foreach Loop Container to Loop through a collection of objects

 
Trouble Shooting SSIS

  • Logging Package Data
  • Using Event Handlers
  • Troubleshooting Errors
  • Using Data Viewers
  • Using Breakpoints

 
Day 4
 
SSIS Package Deployment

  • Overview of Deploying Packages
  • Deployment Challenges
  • Create a Package Deployment Utility
  • The Package Installation Wizard
  • Deploy a Package to the File System
  • Deploy a Package to SQL Server
  • Importing a Package Using Management Studio
  • Redeploying Update Packages

 
Administering SSIS

  • Creating and Configuring the SSIS Catalog
  • Deploying Packages to the SSIS Catalog
  • Securing SSIS Packages
  • Running SSIS Packages
  • Scheduling Packages

 
Wrap up and Review

  • Bringing it all Together
  • SSIS Component and Crib Notes
  • Problem and Solution Crib Notes

Our international certified trainers have highly experienced Microsoft BI practitioners who have real-world expertise.

I – Laptops will be provided for all candidates with pre-installed Microsoft SQL Server Integration Services.

II – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of a place on the course).

For more information on our training, please enquire using the form above or call +2348103382376

SQL Integration Services

Contact Our Team Today!








    What's Included

    Find out what’s included in the training programme.
    COURSE MANUALS
    REFRESHMENTS
    INSTRUCTOR

    Delivery Options

    Everything you need to know

    CLASS ROOM TRAINING
    ONLINE TRAINING
    ONSITE TRAINING

    Course Schedule

    Find out the next available dates

    SQL Integration Services

    Available Dates

    Available Places

    Book or Enquire

    April 19, 2021

    Abuja, Accra, Addis Ababa, Freetown, Kigali, Lagos, Nairobi

    We are happy to help

    Call our team today on +2348103382376 or email training@habanerodata.net

    We’re here to discuss your needs with a free consultation and to offer guidance on the best route forward for you or your team. We’re proud of our expert data courses and consultancy services, and we’re always happy to talk about them.