QUESTPOND ONLINE COURSE

Azure Data Factory (ADF)

What you'll learn

  • Learn Azure Data Factory with Hands on
  • Practical Technology using Azure Cloud

Course Curriculum

Explore the topics covered in this course.

+
Azure Data Factory (ADF) Training Recordings Click to view syllabus
Module 1
  • Day 1 :- Introduction to Azure Data Factory, Azure Cloud and What is Opex and Capex Model in Azure - 23-08-2025.
  • Day 2 :- Azure Deep Dive: IaaS, PaaS, SaaS, VM Creation, Cloud Types, Regions & Availability Zones. - 24-08-2025.
  • Day 3 :- Azure Core Concepts with Scalability and Elasticity Practical. - 30-08-2025.
  • Day 4 :- Advance Demo of SSIS using ForLoop, ForeachLoop, Script Task, Excel File. - 31-08-2025.
  • Day 5:- Azure Storage, Redundancy Options, Access Tier. - 13-09-2025.
  • Day 6:- Azure Storage Account Types, DataLake Gen2,Storage Account vs Data Lake Gen2 Sql Elastic Pool, DTU, EDTU. - 14-09-2025.
  • Day 7:- Azure SQL DB, Azure SQL Server On VM and What is Azure ADF. - 20-09-2025.
  • Day 8:- Azure Data Factory Step Up, ADF Tour, Copy Data Activity, Data Set, Linked Services, Integration Runtime & Types. -26-09-2025.
  • Day 9:- Copy Data Tool, Copy Activity Azure Blob to Data Lake, Types of File Format Azure Blob and DataLake Gen2, Degree of Parallelism - 28-09-2025.
  • Day 10 :- Self IR, Local Sql to Azure Blob, Create SSIS IR Lift and Shift & Run an SSIS package vis SSISDB Azure SQL Db. 04-10-2025.
  • Day 11 :- Run SSIS Package in ADF, List of Files, Wildcard Patterns in Copy Activity. 05-10-2025.
  • Day 12 :- CDC, Max rows in copy activity. 11-10-2025.
  • Day 13 :- Copy Activity Azure Blob to Azure SQL DB, Triggers and its Type using Set Variable Example. 12-10-2025.
  • Day 14 :- ADF Parameters, Get metadata Activity and Foreach Activity -26-10-2025.
  • Day 15:- Validation Activity, IF Condition and Web Activity in ADF -01-11-2025.
  • Day 16 :- Understanding Web Activity with Variables, Until Activity using GetMetaData, IF, Fail, Set Variable and Wait Activity -02-11-2025.
  • Day 17 :- Until Activity, Append Activity,Filter Activity, Delete Activity and Sending Email if Conditions Fails using Web Activity -08-11-2025.
  • Day 18 :- Delete Activity, Send Custom Mail if Condition fails using Web Activity and Lookup Activity with Script Activity 09-11-2025.
  • Day 19 :- Lookup Activity, Script Activity and Switch Activity in ADF. -15-11-2025.
  • Day 20 :- ADF Dataflow Essentials - Source, Sink & Data Cleaning with Expression Formulas. 22-11-2025.
  • Day 21 :- Demo on Round Robin Partitioning and Derived column. 23-11-2025.
  • Day 22 :- Transforming Data in ADF using Derived Columns, Conditional Split and Aggregate. 29-11-2025.
  • Day 23 :- Derived Column, Union Transformation, Aggregation, Select Transformation, Join and Join Types in ADF Data Flow. 30-11-2025.
  • Day :- 24 Lookup Transformation, Alterrow Transformation, Surrogate Key and New Branch (Final Session). 06-12-2025.
  • MSBI Data and CSV Files.