This impeccable Azure Data Factory Training course is carefully designed for aspiring ETL Developers and Architects. This Azure Data Factory Training includes basic to advanced ETL Concepts, Data Warehouse (DWH) and Data Mashups / Data Flow concepts using SQL Server, Azure SaaS Components. This Azure Data Factory Training course also includes Azure SQL Database Migrations, Azure Storage, Azure Data Warehouse (ADW), Incremental Loads, Power Query, Azure Data Lake required for Big Data Analytics and Warehouse design with ONE Real-time Project.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Azure Data Factory & Synapse Analytics |
TSQL, Azure Data Factory |
TSQL, Azure Data Engineer |
|
Total Duration | 3 Weeks | 6 Weeks | 10 Weeks |
ADF : Azure Data Factory | ✔ | ✔ | ✔ |
ADF : Data Imports, ETL | ✔ | ✔ | ✔ |
ADF : Data Flows, Wrangling | ✔ | ✔ | ✔ |
ADF : Transformations, ETL | ✔ | ✔ | ✔ |
Synapse: Configuration, Loads | ✔ | ✔ | ✔ |
Synapse: ETL with ADF, DWH | ✔ | ✔ | ✔ |
Synapse: MPP, cDWH, DIUs | ✔ | ✔ | ✔ |
TSQL: Database Basics, T-SQL | ❌ | ✔ | ✔ |
TSQL : Constraints, Joins, Queries | ❌ | ✔ | ✔ |
TSQL: Views, Group By, Self Joins | ❌ | ✔ | ✔ |
TSQL: DB Objects, Queries | ❌ | ✔ | ✔ |
TSQL: Transactions, Lock Hints | ❌ | ✔ | ✔ |
Storage: ADLS Gen 2, BLOB | ❌ | ❌ | ✔ |
Storage: Az Tables, Shares, ACL | ❌ | ❌ | ✔ |
Azure Stream Analytics & Jobs | ❌ | ❌ | ✔ |
IoT Hubs and Event Hubs, ETL | ❌ | ❌ | ✔ |
ADB : Azure Data Bricks | ❌ | ❌ | ✔ |
ADB : Architecture, Data Loads | ❌ | ❌ | ✔ |
ADB : Run Spark Jobs, Pools | ❌ | ❌ | ✔ |
ADB : Workspace, Delta Tables | ❌ | ❌ | ✔ |
DP 203 Exams Guidance | ❌ | ❌ | ✔ |
Total Course Fee* | INR 15000 USD 200 |
INR 19000 USD 300 |
INR 39000 USD 400 |
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 |
Azure Data Factory Training Schedules | |||
S No | Time (IST, Mon - Fri) | Start Date | |
---|---|---|---|
6 | 7 AM - 8 AM | Dec 7th | Register |
7 | 10:30 AM - 11:30 AM | Dec 13th | Register |
8 | 7 PM - 8 PM | Dec 4th | Register |
If above schedule does not work, opt for Azure Synapse Training Videos
Azure Data Factory Training Highlights :
✔ Azure Data Factory |
✔ Azure Databricks |
✔ Azure Synapse |
✔ Azure Cosmos DB |
✔ ADF Resources, Monitor |
✔ Power Query in ADF |
✔ Azure Storage Explorer |
✔ Azure Data Explorer |
✔ On-Premise Migrations |
✔ Big Data Storage |
✔ Performance Tuning |
✔ Security Management |
✔ Prepping, Ingestions |
✔ Spark Clusters, Python, Scala |
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 1 |
Module 2 |
Module 3 |
Chapter 1: Cloud Basics, Azure SQL
|
Chapter 5: Incremental Loads with ADF
|
Chapter 9: Synapse Analytics with Spark
|
Chapter 2: Synapse SQL Pools (DWH)
|
Chapter 6: ADF Data Flow - 1
|
Chapter 10: Synapse Security & Parameters
|
Chapter 3: Azure Data Factory Concepts
|
Chapter 7: ADF Data Flow - 2
|
Chapter 11: Change Data Capture (CDC)
|
Chapter 4: OnPremise Data Loads
|
Chapter 8: Azure Synapse Analytics
|
Chapter 12: Pipeline Monitoring, Security
|
Mod 1: Azure Data Factory & Synapse Analytics |
Mod 2: Azure Data Lake Storage & Stream Analytics |
Mod 3: Azure Databricks & Spark, Python |
Chapter 1: Cloud Basics, Azure SQL
|
Chapter 1: Azure Fundamentals - Storage
|
Chapter 1: Azure Intro, Azure Databricks
|
Chapter 2: Synapse SQL Pools (DWH)
|
Chapter 2: Azure Storage Operations
|
Chapter 2: SparkDatabase, SQL Notebooks
|
Chapter 3: Azure Data Factory Concepts
|
Chapter 3: Azure Storage Security, ACLs
|
Chapter 3: Python Intro, Spark SQL
|
Chapter 4: OnPremise Data Loads
|
Chapter 4: SQL Database Migrations
|
Chapter 4: PySpark Notebooks, DBFS
|
Chapter 5: Incremental Loads with ADF
|
Chapter 5: Azure Tables, Key Vaults
|
Chapter 5: PySpark with ADLS, Widgets
|
Chapter 6: ADF Data Flow - 1
|
Chapter 6: Replication & Optimizations
|
Chapter 6: PySpark Jobs, Architecture
|
Chapter 7: ADF Data Flow - 2
|
Chapter 7: Azure Stream Analytics, IoT
|
Chapter 7: Scala with Spark, Azure SQL DB
|
Chapter 8: Azure Synapse Analytics
|
Chapter 8: Azure Event Hubs
|
Chapter 8: Scala with Spark, Azure SQL DB
|
Chapter 9: Synapse Analytics with Spark
|
Chapter 9: Storage Architecture, Queues
|
Chapter 9: DeltaLake Incr Loads, DWH
|
Chapter 10: Synapse Security & Parameters
|
Real-Time Project
|
|
Chapter 11: Change Data Capture (CDC)
|
||
Chapter 12: Pipeline Monitoring, Security
|