Upcoming workshop
Advanced SQL Skills for the Age of AI: Beyond the "Big 6"
SQL
Data Analysis
AI
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.
register for live workshop
If you already have a Maven Pro account, login to access all workshops
If you're new and want to register for this workshop, sign up for Maven Pro below to access
Don't miss out! Workshop starts in
d
h
m
s
Upcoming
Building AI-Fluent Data Teams: A Leader's Playbook
Jun 23, 2026, 12:00 PM
A practical framework for assessing your data team's real AI capabilities and coaching them on what matters: delegation, evaluation, and safe use.
60 min
Basic
AI
Business
Leadership
Upcoming
Data Viz Foundations and AI Frameworks for Effective Charts
Jun 16, 2026, 12:00 PM
Learn the foundations of communicating data with charts and graphs, and use repeatable AI frameworks to build effective visuals.
90 min
Basic
Data Visualization
AI
