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

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.