Description
Microsoft SSIS (SQL Server Integration Services) is an enterprise data integration, data transformation and data migration tool built into Microsoft’s SQL. SSIS is part of the Microsoft SQL Server data software, used for many data migration tasks.
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.
Reviews
There are no reviews yet.