Azure Data Factory
-
01 Azure Data Engineering Demo Part1 (73:29)
-
02 Azure Data Engineering Demo Part2 (67:00)
-
03 Azure Data Engineering - Install SQL Server (43:55)
-
04 ADF - Cloud Types, Regions, Resource Group (45:42)
-
05 ADF - Create Azure Data Factory Project (38:51)
-
06 ADF - Storage Accounts BLOB and Data Lake (55:01)
-
07 ADF - Demos on BLOB and Data Lake (38:52)
-
08 ADF - Create My First Pipeline (55:16)
-
09 ADF - Load Data from BLOB to Data Lake (48:31)
-
10 ADF - Data Flow Conditional Split (55:51)
-
11 ADF - Joins (50:22)
-
12 ADF - Interview Qns and Ans (10:02)
-
13 ADF - Self Joins and Union and Union All (22:32)
-
14 ADF - Data Flow Transformations Part1 (44:33)
-
15 ADF - Data Flow Transformations Part2 (42:16)
-
16 ADF - Dataset Level Parameters and Demo on Load Any File Data (52:11)
-
17 ADF - Medallion Architecture and Exists and LookUp (55:01)
-
18 ADF - Add Time Stamp to Sink and Demo on Pipeline Level Parameters (52:42)
-
19 ADF - Azure Key Vault, Keys and Secrets (57:03)
-
20 ADF - Demo on Dynamic Linked Services (53:22)
-
21 ADF - Global Parameters (11:22)
-
22 ADF - Access Keys, SAS Tokens (46:31)
-
23 ADF - Load the Data If File Exists (61:46)
-
24 ADF - Load Last 24 Hrs Modified Files (55:41)
-
25 ADF - Rest API (26:52)
-
26 ADF - Azure SQL (54:06)
-
27 ADF - Create Azure SQL Database (28:32)
-
28 ADF - Load Data From Azure SQL to Data Lake Dynamically (56:31)
-
29 ADF - Load Data From Data Lake to Azure SQL Assignment (46:07)
-
30 ADF - Load Multiple Excel Files Data into Azure SQL (70:18)
-
31 ADF - Load Data from Datalake to Azure SQL Dynamically (41:52)
-
32 ADF - On Prem SQL To Azure SQL Demo and Self Hosted Integration Runtime (48:51)
-
33 ADF - CICD Part1 (42:01)
-
34 ADF - CICD Part2 (38:43)
-
35 ADF - Triggers (39:42)
-
36 ADF - Tumbling Window Triggers (37:07)
-
37 ADF - Tumbling Window Triggers Demos (52:20)
-
38 ADF- Incr Loading using SCD (43:27)
-
39 ADF - Incr Loading Using Merge SQL (47:46)
-
40 ADF - Incr Loading using CDC and Copy Data Upsert Demo (43:59)
-
41 ADF - Incr Loading Demo using Watermark or Timestamp (81:47)
-
42 ADF - Fail, Script Task, Logging (62:52)
-
43 ADF - Assignment Incr Loading (36:54)
-
44 ADF - Interview Questions (75:47)
-
45 ADF - Interview Preparation (21:37)
DWH
-
02 DWH - Top Down vs Bottm Up Approach (44:53)
-
01 DWH - Intro (49:52)
-
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
Resumes
PPTs
