Section 1 : Introduction

• Lecture 1: Big Data Introduction
• Lecture 2: Azure Data Factory Introduction
• Lecture 3: Azure Data Factory __ Important Concepts in Azure Data Factory
• Lecture 4: Azure Data Factory __ Create Azure Free Account for Azure Data Factory

Section 2: Integration Runtime and Types

• Lecture 5: Azure Data Factory __ Integration runtime in azure data factory __ Azure IR

Section 3: Azure Data Factory - Real Time Use case1

• Lecture 6: ADF Lab1__ Create Your First Azure Data Factory
• Lecture 7: ADF Lab2__ Create Your First Pipeline in Azure Data Factory

Section 4: Azure Storage Account Integration with Azure Data Factory

• Lecture 8: ADF Lab3__ Copy multiple files from blob to blob
• Lecture 9: ADF Lab4_ Filter activity __ Dynamic Copy Activity
• Lecture 10: ADF Lab5__ Get File Names from Folder Dynamically

Section 5: Deep dive into Copy Activity in Azure Data Factory

• Lecture 11: ADF Lab6__ Copy Activity Behavior in Azure Data Factory
• Lecture 12: ADF Lab7__ Copy Activity Performance Tuning in Azure Data Factory

Section 6: Validation in Azure Data Factory

• Lecture 13: ADF Lab8__ Get Count of files from folder in azure data factory
• Lecture 14: ADF Lab9__ Validate copied data between source and sink in Azure Data Factory

Section 7: Azure SQL Database integration with Azure Data Factory

• Lecture 15: Azure SQL Databases - Introduction __ Relational databases in Azure
• Lecture 16: Creating Your First Azure SQL Database _Deployment Models __Purchasing Modes
• Lecture 17: ADF Lab10__ Overwrite and Append Modes in Copy Activity in Azure Data Factory

Section 8: Full Load to Azure Synapse in Azure Data Factory

• Lecture 18: ADF Lab11__ Copy Data from Azure SQL Database to Azure Synapse in Azure Data Factory
• Lecture 19: ADF Lab12__ Copy multiple tables to Azure Synapse in Bulk with Lookup & ForEach in Data Factory

Section 9: Logging and Notification __ Azure Logic Apps

• Lecture 20: ADF Lab13__ Log Pipeline Executions to SQL Table using Azure Data Factory
• Lecture 21: ADF Lab14 _ Custom Email Notifications _ Send Error notification with logic app
• Lecture 22: ADF Lab15 __ Use Foreach loop activity to copy multiple Tables- Step by Step Explanation

Section 10: Incremental Load to Azure Synapse in Azure Data Factory

• Lecture 23: ADF Lab16 __Incremental Load or Delta load from SQL to blob Storage in Azure Data factory
• Lecture 24: ADF Lab17 __ Multi Table Incremental Load or Delta load from SQL to to Azure Synapse
• Lecture 25: ADF Lab18 __Incrementally copy new and changed files based on Last Modified Date

Section 11: Azure Key Vault integration with Azure Data Factory

• Lecture 26: ADF Lab19 __ Azure Key Vault, Secure secrets, keys & certificates in Azure Data

Section 12: Azure Data Factory Triggers

• Lecture 27: Azure Data Factory __ Event Based Trigger in Azure Data Factory
• Lecture 28: ADF Lab21 __ Tumbling window trigger dependency & parameters
• Lecture 29: ADF Lab22 __ Schedule Trigger in Azure Data Factory

Section 13: Self Hosted Integration Runtime

• Lecture 30: ADF Lab23- Copying On Premise data using Azure Self Hosted integration Runtime

Section 14: Data Migration from On premise SQL Server to Azure Synapse using Azure Data Factory

• Lecture 31: ADF Lab24 - Load data from on premise sql server to Azure Synapse

Section 15: Data Migration to Azure Synapse with polybase and Bulk insert

• Lecture 32: ADF Lab25 -Copy Data from sql server to to Azure Synapse with polybase & Bulk Insert

Section 16: Data Migration from On premise File System to Azure Synapse using Azure Data Factory

• Lecture 33: ADF Lab26 - Copy Data from on-premise File System to Azure Synapse

Section 17: Copying data from REST API using Azure Data Factory

• Lecture 34: ADF Lab27 -Loop through REST API copy data 2 ADLS Gen2 Linked Service Parameters

Section 18: Salesforce Integration with Azure Data Factory

• Lecture 35: ADF Lab28 _Copy data from Salesforce to ADLS Gen2 using ForEach & Copy in ADF V2

Section 19: AWS S3 integration with Azure Data Factory

• Lecture 36: ADF Lab29 -Migrate Data from AWS S3 Buckets to ADLS Gen2 using ADF (v2)

Section 20: Activities in Azure Data Factory

• Lecture 37: ADF Lab30 -Switch Activity In Azure Data Factory __Copy, Move and delete data
• Lecture 38: ADF Lab31 _Until Activity in Azure Data Factory __ Parameters & Variables
• Lecture 39: ADF Lab32 -Copy Recent Files From Blob input to Blob Output folder without LPV

Section 21: Snowflake integration with Azure Data Factory

• Lecture 40: ADF Lab33 -Copy data from Azure Snowflake to Azure Synapse

Section 22: Azure CosmosDB integration with Azure Data Factory

• Lecture 41: ADF Lab34-Copy data from Azure SQLDB to CosmosDB_Copy data from blob to cosmosDB

Section 23: Advanced Concepts in Azure Data Factory

• Lecture 42: ADF Lab35 -Nested ForEach in ADF _ pass parameters from Master to child pipeline
• Lecture 43: ADF Lab36 -High Availability of Self Hosted IR &Sharing IR with other ADF

Section 24: Data Flows Introduction

• Lecture 44: Azure Data Flows Introduction __ Setup Integration Runtime for Data Flows
• Lecture 45: Azure Data Flows __ Basics of SQL Joins for Azure Data Flows

Section 25: Joins in Data Flows

• Lecture 46: ADF Lab37 -Aggregations and Derive Column Transformations
• Lecture 47: ADF Lab38 _Joins in Azure DataFlows
• Lecture 48: ADF Lab39 -Advanced Join Transformations with filter and Conditional Split

Section 26: Data Flows - Data processing use case1

• Lecture 49: ADF Lab40 -Restart data processing from failure
• Lecture 50: ADF Lab41 -Remove Duplicate Rows &Store Summary Credit Stats __ Azure Data Flows
• Lecture 51: ADF Lab42 -Difference Between Join vs.Lookup Transformation& Merge Functionality

Section 27: Dimensions in Data Flows

• Lecture 52: ADF Lab43 -Slowly Changing Dimension Type1 (SCD1) with HashKey Function and Load to Azure Synapse
• Lecture 53: ADF Lab44 -Slowly Changing Dimension Type(SCD1) with SurrogateKey Transformation and Load to Azure Synapse
• Lecture 54: ADF Lab45 -Slowly Changing Dimension Type2 (SCD2) and Load to Azure Synapse

Section 28: Data Flows - Data processing use case2

• Lecture 55: ADF Lab46 - Flatten Transformation and Rank, Dense_Rank Transformatios
• Lecture 56: ADF Lab47 -Data Flows Performance Metrics and Data Flow Parameters
• Lecture 57: ADF Lab48 -How to use pivot and unpivot Transformations
• Lecture 58: ADF Lab49 -Data Quality Checks and Logging using Data Flows

Section 29: Batch Account Integration with Azure Data Factory

• Lecture 59: ADF Lab50 - Custom Activity in Azure Data Factory

Section 30: Azure Functions Integration with Azure Data Factory

• Lecture 60: ADF Lab51 - Azure Functions Integration with Azure Data Factory

Section 31: Azure HDInsight Integration with Azure Data Factory

• Lecture 61: ADF Lab52 -Azure HDInsight with Spark Cluster

Section 32: Azure Databricks Integration with Azure Data Factory

• Lecture 62: ADF Lab53 -Azure Data Factory Integration with Azure Databricks

Section 33: Azure Data Lake Analytics with Azure Data Factory

• Lecture 63: ADF Lab54 -Azure Data Lake Analytics integration with Azure Data Factory

Section 34: Azure Machine Learning

• Lecture 64: ADF Lab55 -Azure Machine Learning

Section 35: Azure Automation Integration with Azure Data Factory

• Lecture 65: Auto Termination of server with Automation Account

Section 36: Azure Devops - CICD

• Lecture 66: ADF Lab56 -Azure Data Factory CICD Pipeline

Section 37: Azure Data Factory Projects

• Lecture 67: ADF Lab57 -Azure Data Factory project-1
• Lecture 68: ADF Lab58 -Azure Data Factory project-2

Section 38: Azure Data Factory Interview Question and Answers

• Lecture 69: BI Master Program Interview Question and Answers

Section 39: Synapse Analytics

• Lecture 72: Lab59 : External Tables creation in Azure Synapse
• Lecture 73: Lab60 : Project on Azure Synapse Workspace

Section 40: Additional Content

• Lecture 72: Python Basics
• Lecture 73: Python Data Types
• Lecture 74: Python Functions
• Lecture 75: Python Modules and packages

Section 41: Additional Content

• Lecture 76: Spark Architecture
• Lecture 77: Spark RDD
• Lecture 78: Spark SQL
• Lecture 79: Spark SQL Functions
• Lecture 80: Spark SQL Advanced