Bill Wallis

Howdy, I’m Bill 👋 I'm a Data professional in the UK, specialising in SQL and Python. If you're looking to improve your SQL skills, hit that subscribe button: I have a lot of handy SQL knowledge to share!

SQL POSITIONAL Join (DuckDB, ClickHouse)
SQL POSITIONAL Join (DuckDB, ClickHouse)
SQL SEMI and ANTI Joins
SQL SEMI and ANTI Joins
SQL ASOF Join (DuckDB, Snowflake)
SQL ASOF Join (DuckDB, Snowflake)
SQL Join Fundamentals
SQL Join Fundamentals
From Excel to SQL - Introduction and setting the context
From Excel to SQL - Introduction and setting the context
From Excel to SQL - Getting Data (SELECT and FROM)
From Excel to SQL - Getting Data (SELECT and FROM)
From Excel to SQL - Final Notes
From Excel to SQL - Final Notes
From Excel to SQL - Window Functions (OVER)
From Excel to SQL - Window Functions (OVER)
From Excel to SQL - Subqueries
From Excel to SQL - Subqueries
From Excel to SQL - Unions (UNION)
From Excel to SQL - Unions (UNION)
From Excel to SQL - Joins (JOIN)
From Excel to SQL - Joins (JOIN)
From Excel to SQL - Pivot Tables (ROLLUP)
From Excel to SQL - Pivot Tables (ROLLUP)
From Excel to SQL - Aggregations (GROUP BY)
From Excel to SQL - Aggregations (GROUP BY)
From Excel to SQL - Date Formatting (FORMAT)
From Excel to SQL - Date Formatting (FORMAT)
From Excel to SQL - Conditionals (IIF and CASE)
From Excel to SQL - Conditionals (IIF and CASE)
From Excel to SQL - Operators (+, -, *, /)
From Excel to SQL - Operators (+, -, *, /)
From Excel to SQL - Data Types (CHAR, INT, DATE)
From Excel to SQL - Data Types (CHAR, INT, DATE)
From Excel to SQL - Top Rows, Distinct Rows (TOP and DISTINCT)
From Excel to SQL - Top Rows, Distinct Rows (TOP and DISTINCT)
From Excel to SQL - Filtering Data (WHERE)
From Excel to SQL - Filtering Data (WHERE)
From Excel to SQL - Comments (-- and /**/)
From Excel to SQL - Comments (-- and /**/)
From Excel to SQL - Sorting Data (ORDER BY)
From Excel to SQL - Sorting Data (ORDER BY)