SQL looks intimidating until you write your first query — then it just makes sense. This track starts at zero: what a database and a table actually are, and how SQL lets you ask them questions in plain, structured commands. You will write your first SELECT statement, pull specific columns instead of everything, and use aliases to make results readable. You will learn LIMIT to preview large tables safely and ORDER BY to sort results by any column, ascending or descending. Along the way you will pick up good habits — formatting queries clearly and reading error messages instead of fearing them. By the end you will comfortably explore any table and pull exactly the columns and rows you need.

A table with a million rows is useless until you can narrow it down to the ones you actually care about — that is what this track teaches. You will master the WHERE clause and the comparison and logical operators (AND, OR, NOT) that combine conditions precisely. You will learn IN to match a list of values, BETWEEN for ranges, and LIKE for pattern matching text, so you can filter by date ranges, categories, or partial names. You will also handle NULLs correctly, a common source of bugs for beginners, and use DISTINCT to remove duplicate results. By the end you will confidently slice any table down to exactly the rows a real business question calls for, no matter how large the dataset.

Individual rows tell you what happened once; aggregation tells you what happens overall — and that is where real analysis begins. This track teaches the aggregate functions every analyst uses daily: COUNT to tally rows, SUM to total values, and AVG, MIN, and MAX to summarize a column. You will learn GROUP BY to break totals down by category — sales per region, orders per customer, signups per month — and HAVING to filter those grouped results, the way WHERE cannot. You will practice combining multiple aggregates in one query and reading exactly which rows each group represents. By the end you will turn any raw table into the summary numbers that show up in real reports and dashboards, answering totals, averages, and counts with confidence.

Real data never lives in one table — customers, orders, and products are always split apart, connected by keys. This track teaches you to reconnect them. You will learn what primary and foreign keys are and how they link tables together, then write INNER JOINs to combine matching rows across tables and LEFT JOINs to keep every row from one table even when there is no match — essential for finding customers with no orders or products never sold. You will practice joining three or more tables in a single query, and use self-joins to compare rows within the same table, such as employees and their managers. By the end you will confidently query across an entire database schema instead of being limited to whatever fits in one table.

This final track takes you from writing simple queries to writing the advanced SQL that powers real analytics dashboards. You will learn subqueries — queries nested inside other queries — to answer multi-step questions, and common table expressions (CTEs) to break complex logic into clean, readable steps. Then you will move into window functions, the tool behind rankings, running totals, and month-over-month comparisons, learning ROW_NUMBER, RANK, and SUM OVER to calculate results across rows without collapsing them like GROUP BY does. You will practice building a leaderboard, a running revenue total, and a rolling average, the exact patterns used in business intelligence tools. By the end you will write the same level of SQL that professional data analysts rely on every day.