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 the kinds of problems analysts face on the job rarely stop there. Real work means transforming messy data, debugging mismatched joins, restructuring complex queries, and figuring out when to use which tool, and most SQL training stops short of that next layer.
In this session, you'll work through advanced SQL techniques (functions, joins and unions, window functions, subqueries, and CTEs), and you'll see how AI tools fit into a real analyst's workflow as a working partner for writing, debugging, and optimizing your queries.
What you'll learn
Apply SQL functions to transform raw data into the format you actually need
Date, numeric, and string functions are the building blocks that turn raw source data into something you can analyze, and most analysts only use a fraction of what's available.
Use joins and unions to combine tables and explore data quality issues
Joins aren't just for combining tables. Used carefully, they're one of the fastest ways to surface mismatched rows, missing values, and the kinds of data issues that quietly break analyses.
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.
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 dive deeper
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 debug, optimize, and structure 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 equivalent MySQL environment) 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 has taught numerous courses in Python, SQL, and R as a data science instructor at Maven Analytics and Metis, and as a co-founder of Best Fit Analytics.
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
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.
Starts in
d
h
m
s
90 min
Basic
Data Visualization
AI
Upcoming
Build Your Personal AI Data Analyst with Claude Cowork
Jun 4, 2026, 12:00 PM
Build your own Claude Cowork plugin for data analysis, shaped around your role, your industry, and the stakeholders you deliver insights to.
Starts in
d
h
m
s
90 min
Intermediate
AI
Data Analysis
Claude
