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 | ✖ | ✖ | ✓ |
SQL Server & T-SQL Schedules | ||||
S No | Time (IST, Mon - Fri) | Start Date | ||
---|---|---|---|---|
1 | 6 AM - 7 AM | June 27th | Register | |
2 | 8 PM - 9 PM | July 12th | Register | |
3 | 9 PM - 10 PM | June 8th | Register | |
4 | 11 PM - 12 AM | June 19th | Register |
SSIS Training Schedules | |||
S No | Time (IST, Mon - Fri) | Start Date | |
---|---|---|---|
5 | 8:30 AM - 9:30 AM | June 7th | Register |
6 | 8:30 PM - 9:30 PM | June 21st | 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, T-SQL INTRO
|
Ch 9: Triggers & Transactions
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 6 : CONSTRAINTS, INDEXES
|
Ch 10: DB Architecture & Group By
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 7: JOINS & LINKED SERVERS
|
Ch 11: TSQL Queries: Group By, Joins
|
Ch 4: SQL BASICS - 2
|
Ch 8: VIEW, SPs, FUNCTIONS BASICS
|
Ch 12 : ER MODELS, NORMAL FORMS
|
Case Study 1 - For Database, Table Design (Constraints, Keys) |
Case Study 2 - For Query Writing + Window Functions (Rank, RowNumber) |
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
|