Bill Wallis

SQL POSITIONAL Join (DuckDB, ClickHouse)

Bill Wallis

SQL SEMI and ANTI Joins

Bill Wallis

SQL ASOF Join (DuckDB, Snowflake)

Bill Wallis

SQL Join Fundamentals

Bill Wallis

From Excel to SQL - Introduction and setting the context

Bill Wallis

From Excel to SQL - Getting Data (SELECT and FROM)

Bill Wallis

From Excel to SQL - Final Notes

Bill Wallis

From Excel to SQL - Window Functions (OVER)

Bill Wallis

From Excel to SQL - Subqueries

Bill Wallis

From Excel to SQL - Unions (UNION)

Bill Wallis

From Excel to SQL - Joins (JOIN)

Bill Wallis

From Excel to SQL - Pivot Tables (ROLLUP)

Bill Wallis

From Excel to SQL - Aggregations (GROUP BY)

Bill Wallis

From Excel to SQL - Date Formatting (FORMAT)

Bill Wallis

From Excel to SQL - Conditionals (IIF and CASE)

Bill Wallis

From Excel to SQL - Operators (+, -, , )

Bill Wallis

From Excel to SQL - Data Types (CHAR, INT, DATE)

Bill Wallis

From Excel to SQL - Top Rows, Distinct Rows (TOP and DISTINCT)

Bill Wallis

From Excel to SQL - Filtering Data (WHERE)

Bill Wallis

From Excel to SQL - Comments (-- and )

Bill Wallis

From Excel to SQL - Sorting Data (ORDER BY)

Bill Wallis