Azure Data Bricks
-
01 Azure Databricks Demo Part1 (66:03)
-
02 Azure Databricks Demo Part2 (69:15)
-
03 ADB - Create a Free Subscription (60:24)
-
04 ADB - Create Azure Subscription (50:56)
-
05 ADB - Read Data From CSV File (74:27)
-
06 ADB - Read Data From CSV File Part2 (50:00)
-
07 ADB - Utilities (45:56)
-
08 ADB - Install SQL (35:26)
-
09 ADB - Widgets Part1 (57:33)
-
10 ADB - Widgets Part2 (65:34)
-
11 ADB - Mounts (71:18)
-
12 ADB - Secrets and Types (55:18)
-
13 ADB - Install CLI (43:37)
-
14 ADB - Demos on Creating Secret Scope in Databricks (54:44)
-
15 ADB - Read the csv Files Data using Various Methods (65:50)
-
16 ADB - PySpark Intro, DWH and Big Data and Data Frame (64:15)
-
17 ADB - Write Modes in PySpark (66:16)
-
18 ADB - Read and Write Data in Parquet Files (49:03)
-
19 ADB - Create Data Frame with Schema (42:37)
-
20 ADB - Spark Data Types (10:33)
-
21 ADB - Intro on PySpark Functions (19:38)
-
22 ADB - Array Related Functions, withColumn, Col, Explode, Split (53:26)
-
23 ADB - Conditional Statement, Sort, Alias Functions (35:49)
-
24 ADB - Distinct, Union, Group By, Order By, Drop Duplicates (58:43)
-
25 ADB - Inner Join, Outer , Left Semi, Left and Right Anti Joins (29:22)
-
26 ADB - Pivot, UnPivot, Cross and Self Join, Lit Function (69:41)
-
27 ADB - Fillna, Range, Sample, Collect, Create Temp Table, Transform , UDFs (77:05)
-
28 ADB - ToJson, Ranking, Date and Time Functions (67:02)
-
29 ADB - Spark Functions Part5 Array Functions (19:40)
-
30 ADB - RDD, Data Frame, Dataset and Lazy Evalution and DAG (56:18)
-
31 ADB - Distribution Types, Broadcast Join and Optimize Spark Jobs (44:21)
-
32 ADB - Intro on Delta Lake or Lake House (60:06)
-
33 ADB - Understand ACID Properties in Delta Lake (51:10)
-
34 ADB - Delta Lake Demo using CSV File (58:33)
-
35 ADB - Delta Table with Path and Meta Store using Partitions (52:34)
-
36 ADB - Schema Enforcement in Delta Tables (18:59)
-
37 ADB - Time Travel and Audit History (59:48)
-
38 ADB - Restore and Truncate, Internal and External Tables (32:00)
-
39 - ADB - Vacuum Delta Tables (40:47)
-
40 ADB - More Small Files Issue and Optimization (49:56)
-
41 ADB - Intro to Hive (48:22)
-
42 ADB - Partition, Repartition, Optimize and Z-Ordering (48:38)
-
43 ADB - Demo on Z Ordering (45:52)
-
44 ADB - Data Engineering Interview Questions (39:51)
-
45 ADB - Liquid Clustering (52:13)
-
46 ADB - Streaming Data (39:55)
-
47 ADB - Demo on Stream Data (49:08)
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
Azure Synapse
