MS SQL Server Integration Services – SSIS

Duration: Hours


    Category: Tag:

    Training Mode: Online


    Course Content 

     1 Module 

    • What is Data and Information
    • Introduction to DBMS and RDBMS Concepts
    • DDL ,DML and DQL commands
    • Doubts and assignments

     2 Module 

    • Operators in SQL(Arithmetic Operators, Comparison Operators, Logical operators
    • SQL clauses (TOP, like Group by ,Having and order by Doubts and assignments)

     3 Module 

    • Discussion on assignments and tasks
    • SQL Functions
    • Module 4-
    • SQL Joins
    • Understanding of table relations
    • Tasks on joins

    4 Module 

    • Discussion on sql joins tasks
    • SQL views
    • Doubts and Queries


    5 Module 

    • Introduction to ETL Concepts
    •  Microsoft SSIS installation
    •  SSIS Package configuration

     6 Module 

    • Data Flow Task
    • control flow task
    • execute sql task

    7 Module

    • Data Sources
    • Data Flow Destinations
    • Source to destination mappings

    8 Module

    • Data Flow Transformations
    • Lookup Transformation
    • multiple table load in  Microsoft SSIS

    9 Module

    • Data conversion
    • Derived Column transformation
    • Calculated fields in SSIS

    10 Module 

    • Send Mail task
    • conditional split ,multicast
    • union all, merge

    11 Module

    • Event Handlers
    • Error handling
    • Audit Tables

    12 Module

    • SSIS package deployment
    • Package execution
    • Package Scheduling

    Locus IT Academy has more than a decade experience in delivering the training, Staffing on Microsoft SSIS for corporates across the globe. The participants for the training Staffing on Microsoft SSIS  are extremely satisfied and are able to implement the learnings in their on going projects.


    There are no reviews yet.

    Be the first to review “MS SQL Server Integration Services – SSIS”

    Your email address will not be published. Required fields are marked *


      Category: Tag: