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.
Table of contents
1. Introduction to SQL and Databases
1.1 What is Data and Information
1.2 Introduction to DBMS and RDBMS Concepts
1.3 DDL, DML, and DQL Commands
1.4 Doubts and Assignments
2. SQL Operators and Clauses
2.1 Operators in SQL (Arithmetic, Comparison, Logical Operators)
2.2 SQL Clauses (TOP, LIKE, GROUP BY, HAVING, ORDER BY)
2.3 Doubts and Assignments
3. SQL Functions, Joins, and Relationships
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. Advanced SQL Concepts
4.1 Discussion on SQL Joins Tasks
4.2 SQL Views (Ref: MS SQL Administration)
4.3 Doubts and Queries
SSIS – SQL Server Integration Services
5. Introduction to SSIS
5.1 Introduction to ETL Concepts
5.2 Microsoft SSIS Installation
5.3 SSIS Package Configuration
6. SSIS Core Components
6.1 Data Flow Task
6.2 Control Flow Task
6.3 Execute SQL Task(Ref: Mastering SQL Server with SSIS & SSRS)
7. Data Sources and Destinations
7.1 Data Sources
7.2 Data Flow Destinations
7.3 Source to Destination Mappings
8. Data Transformations in SSIS
8.1 Data Flow Transformations
8.2 Lookup Transformation
8.3 Multiple Table Load in Microsoft SSIS
9. Data Processing and Calculations
9.1 Data Conversion
9.2 Derived Column Transformation
9.3 Calculated Fields in SSIS
10. Advanced SSIS Tasks
10.1 Send Mail Task
10.2 Conditional Split, Multicast
10.3 Union All, Merge
11. Error Handling and Auditing
11.1 Event Handlers
11.2 Error Handling
11.3 Audit Tables
12. SSIS Deployment and Scheduling
12.1 SSIS Package Deployment
12.2 Package Execution
12.3 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.