SQL POSITIONAL Join (DuckDB, ClickHouse)
Bill Wallis
SQL POSITIONAL Join (DuckDB, ClickHouse)
14:26
SQL SEMI and ANTI Joins
Bill Wallis
SQL SEMI and ANTI Joins
12:24
SQL ASOF Join (DuckDB, Snowflake)
Bill Wallis
SQL ASOF Join (DuckDB, Snowflake)
22:20
SQL Join Fundamentals
Bill Wallis
SQL Join Fundamentals
40:14
From Excel to SQL - Introduction and setting the context
Bill Wallis
From Excel to SQL - Introduction and setting the context
5:06
From Excel to SQL - Getting Data (SELECT and FROM)
Bill Wallis
From Excel to SQL - Getting Data (SELECT and FROM)
22:28
From Excel to SQL - Final Notes
Bill Wallis
From Excel to SQL - Final Notes
2:56
From Excel to SQL - Window Functions (OVER)
Bill Wallis
From Excel to SQL - Window Functions (OVER)
33:15
From Excel to SQL - Subqueries
Bill Wallis
From Excel to SQL - Subqueries
21:28
From Excel to SQL - Unions (UNION)
Bill Wallis
From Excel to SQL - Unions (UNION)
8:34
From Excel to SQL - Joins (JOIN)
Bill Wallis
From Excel to SQL - Joins (JOIN)
34:55
From Excel to SQL - Pivot Tables (ROLLUP)
Bill Wallis
From Excel to SQL - Pivot Tables (ROLLUP)
10:01
From Excel to SQL - Aggregations (GROUP BY)
Bill Wallis
From Excel to SQL - Aggregations (GROUP BY)
30:40
From Excel to SQL - Date Formatting (FORMAT)
Bill Wallis
From Excel to SQL - Date Formatting (FORMAT)
17:06
From Excel to SQL - Conditionals (IIF and CASE)
Bill Wallis
From Excel to SQL - Conditionals (IIF and CASE)
18:21
From Excel to SQL - Operators (+, -, *, /)
Bill Wallis
From Excel to SQL - Operators (+, -, *, /)
14:46
From Excel to SQL - Data Types (CHAR, INT, DATE)
Bill Wallis
From Excel to SQL - Data Types (CHAR, INT, DATE)
43:40
From Excel to SQL - Top Rows, Distinct Rows (TOP and DISTINCT)
Bill Wallis
From Excel to SQL - Top Rows, Distinct Rows (TOP and DISTINCT)
12:58
From Excel to SQL - Filtering Data (WHERE)
Bill Wallis
From Excel to SQL - Filtering Data (WHERE)
21:20
From Excel to SQL - Comments (-- and /**/)
Bill Wallis
From Excel to SQL - Comments (-- and /**/)
9:36
From Excel to SQL - Sorting Data (ORDER BY)
Bill Wallis
From Excel to SQL - Sorting Data (ORDER BY)
8:20