Step-by-step guides for SQL, tools, and practical AI — skills you can use at work. Learn by doing, not by jargon.
Series
Step-by-step paths grouped by topic. Start at part 1 and work through at your pace.
Foundations
How analytics works and how everyday data becomes structured.
Core skills
SQL, Python, data quality, charts, and metrics — skills you reuse everywhere.
Data at work
Pipelines, stewardship, and how data moves through real teams.
AI fundamentals
Practical AI for everyday work — product-agnostic judgment and workflows.
AI products
One complete path per brand — first login through deep tools.
Analytics practice
Stats, experiments, customer and finance analytics, and career paths.
BI & workflow tools
Hands-on starters for Power BI, dbt, Airflow, and similar tools.
SQL Tutorial 6: Joins in SQL
Connect customers to orders with INNER and LEFT joins, using keys on purpose. Learn how join grain can explode row counts, when not to join, and how to…
SQL Tutorial 5: Aggregate Functions and Grouping Data
Turn rows into summaries with COUNT, SUM, AVG, MIN, and MAX. Group with GROUP BY, and learn when HAVING filters groups while WHERE filters rows, so your totals…
SQL Tutorial 4: Filtering and Sorting Data in SQL
Filter rows with WHERE, combine conditions with AND and OR, and use IN, BETWEEN, and careful LIKE patterns. Sort with ORDER BY and learn NULL basics so your…
SQL Tutorial 3: Retrieving Data with SELECT
Learn to retrieve exactly the columns you need with SELECT, rename them with aliases, remove duplicate rows with DISTINCT, and cap result size with LIMIT. Stop shipping SELECT…
SQL Tutorial 2: Master the Core Commands (SELECT, INSERT, UPDATE, DELETE)
Master the four core SQL commands: SELECT to read, INSERT to add, UPDATE to change, and DELETE to remove. Learn the safety habits that keep practice useful and…
SQL Tutorial 1: Setting Up Your SQL Playground
Set up a low-drama SQL playground with SQLite first, then compare common engines for later work. Create the toy customers and orders tables in your head and on…
SQL for Beginners: What is SQL and Why You Should Learn It
SQL is how you ask a database for answers instead of scrolling forever. This intro explains tables, the toy customers and orders schema, why SQL still matters at…
What are LLMs? ChatGPT, generative AI, and useful work patterns
Large language models draft text by predicting tokens at scale. Plain definitions, analytics use cases, grounding with retrieval, and a review habit so polished answers do not become…
