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 Online 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.
Pre-requisites: Participant needs to have knowledge on SQL Server T-SQL Queries to join our Real-time Practical Data Modelling (SSAS) Training Course.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Description | SSIS | T-SQL & SSIS | T-SQL & SSIS, ADF |
Total Duration | 2.5 Weeks | 5.5 Weeks | 8.5 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 | ✖ | ✖ | ✓ |
ADF : Data Imports, ETL | ✖ | ✖ | ✓ |
ADF : Data Flows, Wrangling | ✖ | ✖ | ✓ |
ADF : Transformations, ETL | ✖ | ✖ | ✓ |
Synapse: Configuration, Loads | ✖ | ✖ | ✓ |
Synapse: ETL with ADF, DWH | ✖ | ✖ | ✓ |
Synapse: Performance Tuning | ✖ | ✖ | ✓ |
Synapse: MPP, cDWH, DIUs | ✖ | ✖ | ✓ |
Total Course Fee* | INR 7000 USD 100 |
INR 12000 USD 150 |
INR 27000 USD 375 |
SQL Server & T-SQL Schedules | ||||
S No | Time (IST, Mon - Fri) | Start Date | ||
---|---|---|---|---|
1 | 6 AM - 7 AM | Dec 5th | Register | |
2 | 8 AM - 9 AM | Dec 13th | Register | |
3 | 6 PM - 7 PM | Jan 3rd | Register | |
4 | 8 PM - 9 PM | Jan 22nd | Register | |
5 | 9 PM - 10 PM | Dec 19th | Register |
SSIS Training Schedules | |||
S No | Time (IST, Mon - Fri) | Start Date | |
---|---|---|---|
6 | 8:30 AM - 9:30 AM | Dec 6th | Register |
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: DATABASE INTRODUCTION
|
Ch 5: SQL Basics - 3, TSQL INTRO
|
Ch 9: Functions, Procedures Basics
|
Ch 2: SQL SERVER INSTALLATION
|
Ch 6: Constraints, Index Basics
|
Ch 10: TRIGGERS & TRANSACTIONS
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 7: Joins Basics, TSQL Queries
|
Ch 11: Normal Forms, Cursors
|
Ch 4: SQL BASICS - 2
|
Ch 8: Group By in TSQL, Views Basics
|
Ch 12: TSQL Queries, SQL Analytics
|
Case Study 1: Database Design with Tables, Constraints, Keys & Relations |
Case Study 2: Joins with Group By, Sub Queries, Views, Excel Analytics |
Module I: Basic SSIS Development & ETL - DWH |
Module II: Advanced SSIS Development & Deployments |
Ch 1: SSIS INTRO, INSTALLATION
|
Ch 7: Checksum & DWH Design
|
Ch 2: SSIS ETL PACKAGES: BASICS
|
Ch 8: CDC Transformations for DWH
|
Ch 3: MERGE & FUZZY LOOKUP
|
Ch 9: Fact Table Design, DWH Loads
|
Ch 4: SSIS CHECKPOINT & PIVOT
|
Ch 10: DWH MIGRATIONS, SCRIPT Task
|
Ch 5: EVENTS, LOOPS, EXPRESSIONS
|
Ch 11: SSIS DEPLOYMENTS, UPGRADES
|
Ch 6: SSIS with ETL, Warehouse (DWH)
|
Ch 12: SSIS PROJECT [ECommerce Domain]
|
Module 1 |
Module 2 |
Module 3 |
Chapter 1: Azure Basics, Azure SQL DB
|
Chapter 5: OnPremise Data with ADF
|
Chapter 9: Synapse Analytics with Spark
|
Chapter 2: Synapse SQL Pools (DWH)
|
Chapter 6: ADF Data Flow - 1
|
Chapter 10: Incremental Loads @ Synapse
|
Chapter 3: Azure Data Factory Concepts
|
Chapter 7: ADF Data Flow - 2
|
Chapter 11: Optimizations, Power Query
|
Chapter 4: ADF Pipelines, Polybase
|
Chapter 8: Azure Synapse Analytics
|
Chapter 12: Pipeline Monitoring, Security
|