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 | 2.5 Weeks | 6.5 Weeks | 10.5 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: Performance Tuning | ✔ | ✔ | ✔ |
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 | ❌ | ✔ | ✔ |
ADB : Azure Data Bricks | ❌ | ❌ | ✔ |
ADB : Architecture, Data Loads | ❌ | ❌ | ✔ |
ADB : Run Spark Jobs, Pools | ❌ | ❌ | ✔ |
ADB : Workspace, Delta Tables | ❌ | ❌ | ✔ |
Cosmos : Configurations | ❌ | ❌ | ✔ |
Cosmos: Distribute Data, ETL | ❌ | ❌ | ✔ |
Cosmos: Integration with ADF | ❌ | ❌ | ✔ |
Cosmos: Structured Streaming | ❌ | ❌ | ✔ |
Total Course Fee * |
INR 9,000 USD 122 |
INR 13,000 USD 176 |
INR 28,000 USD 379 |
Azure Data Engineer Training Schedules | ||||
S No | Timings (IST) | Start Date | ||
---|---|---|---|---|
Regular Schedules [Mon - Fri] | ||||
1 | 7 AM - 8 AM | July 5th | Register | |
2 | 7 PM - 8 PM | June 27th | 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: 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 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
|
Mod 1: Azure Data Factory [ADF], Synapse |
Mod 2: Azure Storage & Stream Analytics |
Mod 3: Azure Databricks & SparkSQL |
Chapter 1: Azure Basics, Azure SQL DB
|
Chapter 1: Azure Storage & Containers
|
Chapter 1: Azure Intro, Azure Databricks
|
Chapter 2: Synapse SQL Pools (DWH)
|
Chapter 2: Azure Migrations, BLOB Imports
|
Chapter 2: SQL Notebooks & Python
|
Chapter 3: Azure Data Factory Concepts
|
Chapter 3: Azure Tables, Shares
|
Chapter 3: Python Notebooks
|
Chapter 4: ADF Pipelines, Polybase
|
Chapter 4: Azure Storage Security, Admin
|
Chapter 4: Scala Notebooks,Transformations
|
Chapter 5: OnPremise Data with ADF
|
Chapter 5: Azure Monitoring, Power BI
|
Chapter 5: ADB with Virtual Network
|
Chapter 6: ADF Data Flow - 1
|
Chapter 6: Azure Stream Analytics, IoT
|
Chapter 6: DeltaLakes & ADF Integration
|
Chapter 7: ADF Data Flow - 2
|
Chapter 7: IoT Hubs & Event Hubs
|
Chapter 7: Databricks Integrations
|
Chapter 8: Azure Synapse Analytics
|
Chapter 8: Azure Stream Analytics Security
|
|
Chapter 9: Synapse Analytics with Spark
|
||
Chapter 10: Incremental Loads @ Synapse
|
||
Chapter 11: Optimizations, Power Query
|
||
Chapter 12: Pipeline Monitoring, Security
|