On-Demand workshop
Advanced SQL Skills for the Age of AI: Beyond the "Big 6"
SQL
Data Analysis
AI
Sign up Pro or Login to Watch On-Demand Workshop
You've mastered the SQL Big Six and can write a working query, but there's a lot more to SQL beyond the basics.
In this session, we'll tackle advanced techniques like window functions, CTEs, and subqueries. You'll learn how SQL actually executes your queries under the hood, and how to incorporate AI into your workflow to write and debug more efficiently.
What you'll learn
Use window functions, subqueries, and CTEs to solve complex problems step by step
Breaking a hard query into named, reviewable steps is what separates fragile one-liners from queries you can debug, hand off, and reuse.
Understand how SQL executes your queries under the hood
Knowing the order of execution helps you write cleaner queries and diagnose unexpected results, and EXPLAIN lets you see exactly how the database plans to run them.
Pair AI tools with your SQL workflow to write, debug, and optimize queries faster
Treating AI as a working partner (not a replacement for your judgment) is how experienced analysts now move from idea to working query without getting stuck on syntax.
Who should join this workshop?
Data professionals who are comfortable with basic SQL and ready to tackle more advanced techniques like window functions, CTEs, and subqueries
SQL learners who want to see how AI fits into a real analyst's workflow, not as a replacement but as a working partner
Data professionals who want to move from "I can write a basic query" to "I can read, write, and optimize complex queries with confidence"
Anyone who's hit the limits of basic SQL and wants a clear path to level up their skills
Prerequisites
Working knowledge of the SQL "Big 6" clauses (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY)
A laptop with MySQL Workbench (or another SQL editor like SQLite, SQL Server, etc.) installed
Access to a Gen AI tool (ChatGPT, Claude, etc.) recommended, but not required
This is a live, hands-on session and active participation is expected
Alice Zhao
Lead Data Science Instructor
Alice Zhao is a seasoned data scientist and author of the book, SQL Pocket Guide, 4th Edition (O'Reilly). She's an adjunct lecturer for Northwestern University's Machine Learning and Data Science program, where she teaches Python, SQL, R, data warehousing and data visualization.
