SSIS provides Data Extraction, Consolidation and Loading Options (ETL), SQL Server Coding enhancements, Data Warehousing and Customizations for SQL Server Developers, Administrators, BI Engineers and Data Analysts. In our SSIS Training course, we deal with complete SSIS Design, Development and Deployment & Management of Various ETL Transformations, Data Loads, Data Cleansing, Incremental Data Loading Techniques including DWH Design, Management, SCD, Profiling, Tuning and Fact Table Loads. This SSIS Classroom Training course also includes Azure Data Factory (ADF) Pipelines and SSIS Package Migrations to ADF with Self Hosted and Integrtion Runtime ENgines, Stored Procedures Executions, Watermark Columns and Azure Data Lake with SSIS Integrations. All sessions are completely practical and realtime.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Description | SSIS | T-SQL & SSIS | T-SQL & SSIS, ADF |
Total Duration | 2.5 Weeks | 5 Weeks | 8 Weeks |
SSIS: Control Flow, Data Flow; SSIS DB | ![]() |
![]() |
![]() |
SSIS: Static & Dynamic Connections | ![]() |
![]() |
![]() |
SSIS: ETL, Data Warehouse Design | ![]() |
![]() |
![]() |
SSIS: Transformations, Data Loads | ![]() |
![]() |
![]() |
SSIS: Data Cleansing, Lookups | ![]() |
![]() |
![]() |
SSIS: Catalog Databases, Usage | ![]() |
![]() |
![]() |
SSIS: Deployments, Migrations | ![]() |
![]() |
![]() |
SSIS : Star & Snowflake Schemas | ![]() |
![]() |
![]() |
SQL : Basics, DDL, DML, SELECT | ❌ | ![]() |
![]() |
T-SQL : Constraints, Normal Forms | ❌ | ![]() |
![]() |
T-SQL: Joins, Group By, Queries | ❌ | ![]() |
![]() |
T-SQL: Merge, Pivot, Date & Time Formats | ❌ | ![]() |
![]() |
T-SQL: Excel Integrations, Pivot Charts | ❌ | ![]() |
![]() |
ADF : Azure Data Factory Architecture | ❌ | ❌ | ![]() |
ADF : Azure Data Warehouse Concepts | ❌ | ❌ | ![]() |
ADF : Massively Parallel Processing (MPP) | ❌ | ❌ | ![]() |
ADF : Copy Data Tool and ADF Portal | ❌ | ❌ | ![]() |
ADF : Stored Procedures For Incremental Loads | ❌ | ❌ | ![]() |
ADF : SSIS Package Migrations to Azure | ❌ | ❌ | ![]() |
Total Course Fee * | INR 7,000 USD 95 |
INR 11,000 USD 149 |
INR 20,000 USD 271 |
If above schedule does not work, opt for SSIS Training Videos
SSIS TRAINING HIGHLIGHTS :
✔ Basic to Adv. ETL | ✔ Basic to Adv. DAX |
✔ Data Modelling | ✔ OLAP DB Design |
✔ Power Query | ✔ Basic to Adv. MDX |
✔ Kimball BI Design | ✔ Inmon BI Design |
✔ Star, Snowflake | ✔ Data Warehousing |
✔ OLTP, File Data | ✔ JSON, XML Data |
✔ Resume Guidance | ✔ MCSA MSBI Exam |
All Session Are Completely Practical & Real Time
Ch 1: SQL SERVER INTRODUCTION
|
Ch 5: SQL Basics - 3, T-SQL INTRO
|
Ch 9: JOINS, T-SQL QUERIES Level 3
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 6 : CONSTRAINTS,INDEXES Basics
|
Ch 10: VIEW, SPs, Function Basics
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 7: JOINS, T-SQL Queries : Level 1
|
Ch 11: Triggers & Transactions
|
Ch 4: SQL BASICS - 2
|
Ch 8: Group By, T-SQL Queries Level 2
|
Ch 12 : ER MODELS, NORMAL FORMS
|
Real-time Case Study - 1
(Sales & Retail) Objective : Database Design, Table Design and Relations. Involves Purchases, Products, Customers and Time Data with Various Data Types. |
Real-time Case Study - 2
(Sales & Retail) Objective : Queries, Excel Integration Pivot Tables, Pivot Charts, ODC Connections |
Module I: Basic SSIS Development & ETL - DWH |
Module II: Advanced SSIS Development & Deployments |
Ch 1: SSIS INTRODUCTION & INSTALLATION
|
Ch 7: CHECKSUM TRANSFORMATION, DWH DESIGN
|
Ch 2: SSIS ETL PACKAGES: EXTRACT,TRANSFORM,LOAD
|
Ch 8: CHANGE DATA CAPTURE: DWH DIMENSIONS
|
Ch 3: MERGE, FUZZY LOOKUP, DATA CONVERSION
|
Ch 9: FACT TABLE DESIGN, FACT LOADS (DWH)
|
Ch 4: PACKAGE PROPERTIES, CHECKPOINT, PIVOT
|
Ch 10: DWH MIGRATIONS with SSIS, SCRIPT Task
|
Ch 5: SSIS with ETL & DWH. SCD TYPE 1, TYPE 2
|
Ch 11: SSIS PROJECT DEPLOYMENT, UPGRADES
|
Ch 6: DATAWAREHOUSE (DWH) DESIGN WITH SSIS
|
Ch 12: SSIS PROJECT [ECommerce Domain]
|
Module I: AZURE DATA FACTORY - 1 |
Module II: AZURE DATA FACTORY - 2 |
HOUR 1: ADF INTRODUCTION
|
HOUR 6 : AZURE DATA FACTORY - 3
|
HOUR 2: AZURE SQL CONFIG, DTU
|
HOUR 7 : AZURE DATA FACTORY - 4
|
HOUR 3: AZURE DATA WAREHOUSE
|
HOUR 8: AZURE DATA FACTORY - 5
|
HOUR 4: AZURE DATA FACTORY - 1
|
HOUR 9: AZURE DATA FACTORY - 6
|
HOUR 5: AZURE DATA FACTORY - 2
|
HOUR 10: AZURE DATA FACTORY - 7
|