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 Videos | 12 Videos | 24 Videos | 40 Videos |
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 20000 USD 300 |
INR 42000 USD 400 |
Register for Azure Data Factory Videos at 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: Cloud Basics, Azure SQL DB
|
Chapter 1: Azure Storage & Containers
|
Chapter 1: Azure Intro, Azure Databricks
|
Chapter 2: Synapse SQL Pools (DWH)
|
Chapter 2: Azure Migration, 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: Open Data Sources, DeltaLakes
|
Chapter 5: OnPremise Data with ADF
|
Chapter 5: Azure Monitoring, Power BI
|
Chapter 5: Databricks Security & Jobs
|
Chapter 6: ADF Data Flow - 1
|
Chapter 6: Azure Stream Analytics, IoT
|
Chapter 6: Databricks @ BLOB, Power BI
|
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
|
Real-Time Project
|
Chapter 9: Synapse Analytics with Spark
|
||
Chapter 10: Incremental Loads @ Synapse
|
||
Chapter 11: Optimizations, Power Query
|
||
Chapter 12: Pipeline Monitoring, Security
|