Course Content
SECTION 1: INTRODUCTION
0/1
Introduction
SECTION 2: ENVIRONMENT SETUP
0/8
Module Overview
Create Azure Account
Azure Portal Walkthrough
Create Storage Account
Create Azure DataLake Gen 2
Create Azure Data Factory
Create Azure SQL
Create Azure SQL Server VM (Virtual Machine)
SECTION 3: BUILDING BLOCKS OF ADF
0/6
Pipelines
Activities
Linked Service
Dataset
Supported File Formats
Interaction Between Different Components
SECTION 4: COPY DATA ACTIVITY
0/10
Copy Data From Blob ADLS(Azure DataLake Storage)
Copy Data Logging Settings
Copy Data – Multiple Files From a Folder & Other Settings
Copy Data – Last Modified Filter
Copy Data SQL DB to ADLS
Copy Data Fault Tolerance
Setup Self Hosted IR(Integration Runtime)
Copy Data On Prem DB to ADLS
Delete SQL Server VM
Ingest Data From API to ADLS
SECTION 5: PARAMETERS AND VARIABLES
0/4
Parameterized Components
Variables in ADF
System Variables
Set Variable Activity
SECTION 6: CONTROL FLOW ACTIVITY
0/10
Filter Activity
ForEach Activity
LookUp Activity
Real World Scenario 2#
Get Meta Data Activity
Real World Scenario
If Condition Activity
The Wait Activity
The Switch Activity
Validation Activity
SECTION 7: OTHER IMPORTANT PIPELINE ACTIVITIES
0/5
Stored Procedure Activity
Real World Scenario
Delete Activity
Execute Pipeline
Dataflow Activity
SECTION 8: MAPPING DATAFLOWS
0/18
Mapping Dataflows
Source Transformation
Sink Transformation
Select Transformations
Filter Transformation
Exist Transformation
Sort Transformation
Rank Transformation
Aggregate Transformation
Join Transformation
Pivot Transformation
LookUp Transformation
Derived Column
New Branch
Surrogate Key Transformation
Flatten Transformation
Alter Row Transformation
Asset Transformation
SECTION 9: ADVANCED CONCEPT
0/2
Expression & Function
Dynamic Queries
SECTION 10: TRIGGERS
0/4
Types of Trigger
Schedule Trigger
Storage Event Based Trigger
Tumbling Window Trigger
SECTION 11: MONITORING
0/1
Pipeline Monitoring
Azure Data Factory
Exercise Files
SQL+data+creation+query (1).zip
Size: 1.53 KB
Previous
Next