Duration: Hours

Training Mode: Online

Enquiry

    Category: Tag:

    Description

    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

    SSIS

    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

    Reviews

    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 *