Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Jan 2025 ADB @9:30AM
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
Session 10 (49:29)
Session 1 (29:38)
Session 11 (81:08)
Session 12 (62:53)
Session 2 (65:27)
Session 3 (52:07)
Session 4 (50:27)
Session 5 (40:09)
Session 6 (48:02)
Session 7 (40:46)
Session 8 (33:41)
Session 9 (50:36)
Resumes and PPTs
Resumes
PPTs
Teach online with
27 ADB - Fillna, Range, Sample, Collect, Create Temp Table, Transform , UDFs
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock