Azure Azure SSIS Online Training course with 100% HandsOn. Course includes Azure SSIS IR, Provisioning SSISDB in Azure SQL Server, Using Azure SSIS Feature Pack, Blob Connections, SQL DB and Azure SQL DW Connections in SSIS. Also using ADF Integrations, Azure File System Deployments and Azure SSIS Migration Considerations. Includes Elastic Jobs, History Retention Schemas, Azure SSISB Package Executions, Audit Reports, Versions and Security.
This Azure SSIS Online Training course also includes best practices on Migrations, Azure SSIS Web Activity in ADF for IR Scheduling, Lift & Shift Considerations, SSIS Package Executions from ADF as well as from Visual Studio with ADF Account. Register Today for Free Demo
PLAN A | PLAN B | PLAN C | PLAN D | |
---|---|---|---|---|
Course includes | Azure SSIS | ADF, Synapse,Azure SSIS | SSIS,ADF, Synapse, Azure SSIS | T-SQL, SSIS, ADF, Synapse,Azure SSIS |
Total Duration | 1 Week | 3 Weeks | 5 Weeks | 7 Weeks |
Azure SSIS: Migrations to ADF | ✔ | ✔ | ✔ | ✔ |
Azure SSIS: IR Schedules, Versioning | ✔ | ✔ | ✔ | ✔ |
Azure SSIS: Elastic Jobs, Adf Jobs | ✔ | ✔ | ✔ | ✔ |
ADF: Pipelines, Activities, IR, DIU | ❌ | ✔ | ✔ | ✔ |
ADF: Data Flow & Data Wrangling | ❌ | ✔ | ✔ | ✔ |
Synapse: MPP Architecture, DWUs | ❌ | ✔ | ✔ | ✔ |
Synapse: Data Loads, CTAS @ T-SQL | ❌ | ✔ | ✔ | ✔ |
SSIS: ETL Concepts, Transformations | ❌ | ❌ | ✔ | ✔ |
SSIS: SCD & CDC for DWH Design | ❌ | ❌ | ✔ | ✔ |
SSIS: Fact Loads, SSDB Catalog DB | ❌ | ❌ | ✔ | ✔ |
T-SQL: Db Basics, SQL Queries, Constraints | ❌ | ❌ | ❌ | ✔ |
T-SQL: Joins, Queries, Parameters, Locks | ❌ | ❌ | ❌ | ✔ |
Course Fee | INR 5000 USD 68 |
INR 14000 USD 190 |
INR 20000 USD 271 |
INR 24000 USD 325 |
If above schedules does not work for you, please register for Azure SSIS Training Videos
Azure Migrations | SSIS Migrations |
Big Data Sources | IR Config |
Elastic Jobs | ADF Jobs |
ADLS Sources | Synapse DWH |
MPP, DWUc | CTAS, T-SQL |
ALL SESSIONS ARE COMPLETELY PRACTICAL & REAL-TIME
Chapter 1: SSIS Migrations to Azure Data Factory Provision Azure SQL Server Integration Services; SSIS DB Creation and Configuration Recommendations; Node Size, Node Number and Edition / License Options; Count, Parallel Execution Settings and DIUs; Edition Settings, logical SQL Server Configurations; SSIS DB Access from SSMS, SKU & Edition Checks; SSIS Package Validations with Connection Parameters; Generation of ISPAC Files in On-Premise, Validations; SSIS Catalog Database, Catalog Folders Creation; SSIS Deployments with ISPAC to Azure SSIS Catalog DB; Package Verifications and Acess from ADF Portal; SSIS Package Execution from ADF Portal, SSIS Store; |
Chapter 2: Azure SSIS from Visual Studio (SSDT) Accessing Azure Data Factory Resource from SSDT; Storage Account and BLOB Container Configurations; Azure SQL Server Deployment for SSIS Catalog DB; Configuring Azure Data Factory, Azure SSIS IR; Using Azure Enabled Integration Services Project in SSDT; Enabling, Linking ADF Account to SSIS Project; Using Azure BLOB Upload Task in SSIS - SSDT Tool; Storage Account, Access Key & Authentication Tests; SSIS Import and Export Operations with Azure; Excel Sheet to Azure SQL Database Tables in SSIS; Connection Settings and Package Executions in Azure; PIVOT Operations in SSIS, Data Uploads to Azure; |
Chapter 3: SSIS Packages with Azure Feature Pack Azure Feature Pack Installations and Real-time Usage; Using Azure BLOB Destination with ETL in SSIS; Using Azure SQL Server Databases with ETL in SSIS; SSIS Package Design with Azure Connections, Parameters; Azure SSIS Runtime Configurations, SSIS DB usage; Azure SSIS Package Executions with T-SQL Scripts; Real-time Considerations with Azure SSIS Migrations; Security Options - Data Security at Rest, TDE Options; Tools - Azure SSIS IR Customizations and Precautions; Pricing - Azure Hybrid Benefit (AHB), DIU and DTU Costs; 3rd Party Tools - Azure SSIS Feature Pack, IR Customization; Networking - Odata Sources, WAN & VNET Considerations; |
Chapter 4: Elastic Jobs with Azure SSIS DB Working with Azure SSIS DB - Standard Edition; Elastic Job Agent Service and Job Databases; Creating Master Keys and Database Credentials; Job Database Configurations with T-SQL Scripts; Testing Elastic Jobs from Azure Portal, T-SQL; Setting Retention Window in Azure SSIS DB with T-SQL; Start, Stop & Schedule Azure SSIS IR; Working with Web Activity in Azure Data Factory; Web Activity : PUSH / PULL Settings, Messages; Azure Management URLs, Azure SSIS IR Start & Stop; MSBI Authentication with Web Activity, Security; Execute SSIS Package Activity with ADF Pipeline; ADF Trigger Schedules and Tumbling Window; |
Chapter 5: Azure SSIS Projects : Versioning, ADF Jobs Azure SSIS Projects : Deployments and Exports; Azure SSIS Projects : Improts to SSDT Environment; Enabling ADF for Existing SSIS Projects, Parameters; SSIS Package Deployments. Deployment Rollbacks, LSN; Creating ADF Jobs from SSMS - using SSIS Schedules; Trigger Edits and Configuration Settings with ADF Jobs; Azure SSIS - Security Management; Creating Logins and Users in Azure SQL Server; User Mapping with SSIS Catalog Database, Scripts; Folder Level and Project Level Permissions in SSSDB; Read, Modify and Manage Permissions in SSIS DB; Principal IDs and Permission Types, Object Types; IAM : ADF Security @ Azure Active Directory Users, Groups; |
1. Azure Fundamentals: What is Cloud? Advantages of Azure Cloud? IaaS, SaaS & PaaS. Azure Data Engineer Technologies, Job Roles. DP 200, 201 Exams Azure Account Registration and Free Trail Activation; Understanding Azure Resources and Resource Types; Creating Resource Groups in Azure Portal; | ||
2. Azure SQL Server: Azure Resources; Resource Groups; Azure SQL Server [Logical Server] Creation; Server Name Format and Firewall Rules; Azure Services Access with Firewall; Test Connections with SSMS Tool and Azure Data Studio Tool; Creating Azure SQL Databases in Portal, T-SQL; Tables, Data Inserts; | ||
3. Azure SQL DB Migrations: Azure SQL DB Migrations from OnPremise; Using Data Migration Assistant Tool; Migration Assessments; Deploy Schema & Migrate Data Options; Onpremise Versus Azure SQL DB Differences; Generating bacpac Files From SSMS Tool; Azure SQL DB Exports & Imports; |
Module 1 |
Module 2 |
Module 3 |
Ch 1: Azure Data Factory, Synapse Intro
|
Ch 4: Azure Data Lake with ADF
|
Ch 7: Incremental Loads with ADF - 2
|
Ch 2: Azure Synapse Architecture
|
Ch 5: On-Premise Data to Azure
|
Ch 8: Mapping Data Flow in ADF
|
Ch 3: Azure Data Factory Architecture
|
Ch 6: Incremental Loads with ADF - 1
|
Ch 9: Wrangling Data Flow in ADF
|
Ch 10: ADF : End to End Implementation
|
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: EVENTS, LOOPS, EXPRESSIONS
|
Ch 11: SSIS PROJECT DEPLOYMENT, UPGRADES
|
Ch 6: DATAWAREHOUSE (DWH) DESIGN WITH SSIS
|
Ch 12: SSIS PROJECT [ECommerce Domain]
|
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 |