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.
More series
Additional paths that do not fit a section yet.
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…
