Azure Data Factory
-
01 Azure Data Engineering Demo Part1 (53:13)
-
02 Azure Data Engineering Demo Part2 (58:51)
-
03 ADF - Install SQL and Create Free Azure Account (45:29)
-
04 ADF - Cloud Types, Regions, Resource Group (45:34)
-
05 ADF - Create Azure Data Factory Project (38:37)
-
06 ADF - Storage Accounts BLOB and Data Lake (54:56)
-
07 ADF - Demos on BLOB and Data Lake (38:30)
-
08 ADF - Access Keys, SAS Tokens (47:07)
-
09 ADF - Create My First Pipeline (54:42)
-
10 ADF - Load Data from BLOB to Data Lake (48:22)
-
11 ADF - Data Flow Conditional Split (55:37)
-
12 ADF - Joins (50:14)
-
13 ADF - Interview Qns and Ans (10:02)
-
14 ADF - Self Joins and Union and Union All (22:25)
-
15 ADF - Data Flow Transformations Part1 (44:17)
-
16 ADF - Data Flow Transformations Part2 (42:03)
-
17 ADF - Dataset Level Parameters and Demo on Load Any File Data (52:01)
-
18 ADF - Medallion Architecture and Exists and LookUp (54:56)
-
19 ADF - Add Time Stamp to Sink and Demo on Pipeline Level Parameters (52:28)
-
20 ADF - Azure Key Vault, Keys and Secrets (53:41)
-
21 ADF - Demo on Dynamic Linked Services (53:00)
-
22 ADF - Global Parameters (11:22)
-
23 ADF - Load the Data If File Exists (61:44)
-
24 ADF - Load Last 24 Hrs Modified Files (55:48)
-
25 ADF - Rest API (26:42)
-
26 ADF - Azure SQL (54:05)
-
27 ADF - Create Azure SQL Database (28:07)
-
28 ADF - Load Data From Azure SQL to Data Lake Dynamically (56:53)
-
29 ADF - Load Data From Data Lake to Azure SQL Assignment (46:04)
-
30 ADF - Load Multiple Excel Files Data into Azure SQL (70:42)
-
31 ADF - Load Data from Datalake to Azure SQL Dynamically (41:47)
-
32 ADF - On Prem SQL To Azure SQL Demo and Self Hosted Integration Runtime (48:52)
-
33 ADF - CICD Part1 (41:13)
-
34 ADF - CICD Part2 (38:39)
-
35 ADF - Triggers (39:36)
-
36 ADF - Tumbling Window Triggers (37:46)
-
37 ADF - Tumbling Window Triggers Demos (52:23)
-
38 ADF- Incr Loading using SCD (43:33)
-
39 ADF - Incr Loading Using Merge SQL (47:38)
-
40 ADF - Incr Loading using CDC and Copy Data Upsert Demo (44:00)
-
41.ADF-Incr loading demo using watermark (82:39)
-
42 ADF - Fail, Script Task, Logging (62:53)
-
43 ADF - Assignment Incr Loading (36:52)
-
44 ADF - Interview Questions (75:47)
-
45 ADF - Interview Preparation (21:43)
-
ADF Project PDF
DWH
-
01 DWH - Intro (49:52)
-
02 DWH - Top Down vs Bottm Up Approach (44:53)
-
03 DWH - ODS Vs DWH (43:28)
-
04 DWH - Convert OLTP Data to OLAP Data (43:15)
-
05 DWH - Intro to Dim Modeling (56:13)
-
06 DWH - Designing Stage and DWH (49:54)
-
07 DWH - Normalization Vs De-Normalization and Designing DWH (57:03)
-
08 DWH - Schemas (52:29)
-
09 DWH - Load Data to DWH using SSIS (72:37)
-
10 DWH - Dims and Facts (17:18)
-
11 DWH - Types of Dimensions (61:25)
-
12 DWH - Types of Dimensions SCD and Inferred Dim (54:04)
-
13 DWH - Types of Facts (51:03)
-
Amazon Project Scripts
-
Incr Loading Vs Full Loading
-
ODS
PPTs and Resumes
