Description
Introduction to SQL SSIS Bootcamp
Welcome to the SQL SSIS Bootcamp! This immersive training program is designed to provide participants with a thorough understanding of SQL Server Integration Services (SSIS) and its role in data integration and transformation. Throughout the course, you will explore essential concepts, such as Extract, Transform, Load (ETL) processes, while also gaining hands-on experience in building and deploying SSIS packages. By the end of this bootcamp, you will be equipped with the skills needed to efficiently manage data workflows and implement robust data integration solutions within your organization.
Prerequisites
- Basic SQL Knowledge
- Familiarity with SQL syntax and basic database operations.
- Understanding of Databases
- Basic understanding of relational database concepts and structures.
- Problem-Solving Skills
- Strong analytical skills to address data integration challenges and troubleshoot issues.
- Basic Programming Concepts
- Some knowledge of programming logic will be helpful, though not mandatory.
Course ContentÂ
 1 ModuleÂ
1.1 What is Data and Informatio
1.2 Introduction to DBMS and RDBMS Concepts
1.3 DDL ,DML and DQL commands
1.4 Doubts and assignments
 2 ModuleÂ
2.1 Operators in SQL(Arithmetic Operators, Comparison Operators, Logical operators
2.2 SQL clauses (TOP, like Group by ,Having and order by Doubts and assignments)
 3 ModuleÂ
3.1 Discussion on assignments and tasks
3.2 SQL Functions
3.3 SQL Joins
3.4 Understanding of table relations
3.5 Tasks on joins
4 ModuleÂ
4.1 Discussion on sql joins tasks
4.2 SQL views (Ref: MS SQL Administration)
4.3 Doubts and Queries
SSIS
5 ModuleÂ
5.1 Introduction to ETL Concepts
5.2 Microsoft SSIS Installation
5.3 SSIS Package Configuration
 6 ModuleÂ
6.1Data Flow Task
6.2control flow task
6.3execute sql task
7 Module
7.1Data Sources
7.2Data Flow Destinations
7.3Source to destination mappings
8 Module
8.1 Data Flow Transformations
8.2 Lookup Transformation
8.3 multiple table load in Microsoft SSIS
9 Module
9.1 Data conversion
9.2 Derived Column transformation
9.3 Calculated fields in SSIS
10 ModuleÂ
10.1 Send Mail task
10.2 conditional split ,multicast
10.3 union all, merge
11 Module
11.1Event Handlers
11.2Error handling
11.3 Audit Tables
12 Module
12.1SSIS package deployment
12.2Package execution
12.3Package 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.