No video

SQL Window Functions (LEAD/LAG and RANK) and Common Table Expressions in 60 minutes on DataExpert.io

  Рет қаралды 13,537

Data with Zach

Data with Zach

6 ай бұрын

We're covering SQL window functions, LAG, LEAD, etc and common table expressions today!

Пікірлер: 23
How to pick between Kimball, One Big Table, and Relational Modeling as a data engineer
41:59
How to pick between Kimball, One Big Table, and Relational Modeling as a data engineer
Data with Zach
Рет қаралды 28 М.
Data Lake Fundamentals, Apache Iceberg and Parquet in 60 minutes on DataExpert.io
59:31
Data Lake Fundamentals, Apache Iceberg and Parquet in 60 minutes on DataExpert.io
Data with Zach
Рет қаралды 32 М.
МАФИЯ в РЕАЛЬНОЙ ЖИЗНИ: Масленников, Матвиенко, Булкин, Сабина, Бустер, Дилара, Гурам, Леон, Янчик
1:00:04
МАФИЯ в РЕАЛЬНОЙ ЖИЗНИ: Масленников, Матвиенко, Булкин, Сабина, Бустер, Дилара, Гурам, Леон, Янчик
Дима Масленников
Рет қаралды 7 МЛН
A teacher captured the cutest moment at the nursery #shorts
00:33
A teacher captured the cutest moment at the nursery #shorts
Fabiosa Stories
Рет қаралды 62 МЛН
Joker can't swim!#joker #shorts
00:46
Joker can't swim!#joker #shorts
Untitled Joker
Рет қаралды 38 МЛН
How I Did The SELF BENDING Spoon 😱🥄 #shorts
00:19
How I Did The SELF BENDING Spoon 😱🥄 #shorts
Wian
Рет қаралды 35 МЛН
SQL Window Functions: The Key to Succeeding in Data Science Interviews
12:59
SQL Window Functions: The Key to Succeeding in Data Science Interviews
Emma Ding
Рет қаралды 47 М.
SQL Self Joins with Trino in 40 minutes on DataExpert.io
40:45
SQL Self Joins with Trino in 40 minutes on DataExpert.io
Data with Zach
Рет қаралды 4,3 М.
How to use Common Table Expressions vs Subqueries vs Views vs Temp Tables like a data engineer! #sql
19:43
How to use Common Table Expressions vs Subqueries vs Views vs Temp Tables like a data engineer! #sql
Data with Zach
Рет қаралды 21 М.
Dimensional data modeling and idempotent pipelines in 78 minutes with DataExpert.io
1:18:16
Dimensional data modeling and idempotent pipelines in 78 minutes with DataExpert.io
Data with Zach
Рет қаралды 18 М.
Data modeling a 100 TB data lake into 5 TBs with STRUCT and Array - DataExpert.io Bootcamp preview
48:17
Data modeling a 100 TB data lake into 5 TBs with STRUCT and Array - DataExpert.io Bootcamp preview
Data with Zach
Рет қаралды 58 М.
Data Modeling Where Theory Meets Reality - How Different Companies I Worked At Modeled Their Data
18:13
Data Modeling Where Theory Meets Reality - How Different Companies I Worked At Modeled Their Data
Seattle Data Guy
Рет қаралды 12 М.
This is how I actually clean data using Power Query
27:49
This is how I actually clean data using Power Query
Mo Chen
Рет қаралды 25 М.
Learn SQL + Database Concepts in 20 Minutes
24:34
Learn SQL + Database Concepts in 20 Minutes
Chandoo
Рет қаралды 45 М.
SQL Value Window Functions | LEAD, LAG, FIRST_VALUE, LAST_VALUE | #SQL Course #6
45:02
SQL Value Window Functions | LEAD, LAG, FIRST_VALUE, LAST_VALUE | #SQL Course #6
Data with Baraa
Рет қаралды 2,6 М.
FASTEST Way To Become a Data Analyst and ACTUALLY Get a Job
14:03
FASTEST Way To Become a Data Analyst and ACTUALLY Get a Job
Unorthodox Change
Рет қаралды 231 М.
МАФИЯ в РЕАЛЬНОЙ ЖИЗНИ: Масленников, Матвиенко, Булкин, Сабина, Бустер, Дилара, Гурам, Леон, Янчик
1:00:04
МАФИЯ в РЕАЛЬНОЙ ЖИЗНИ: Масленников, Матвиенко, Булкин, Сабина, Бустер, Дилара, Гурам, Леон, Янчик
Дима Масленников
Рет қаралды 7 МЛН