Learn SQLBeginner · 11–30 minutes of video per day

Learn SQL from YouTube in 7 days

SQL clicks when every day produces a query you can reuse at work. This week starts with aggregate functions and filters, works through a small analysis project and a portfolio-style project, covers joins, and ends with window functions, using YouTube instructors who teach with real tables. You finish able to answer common business questions without waiting on an analyst. You leave with queries for aggregates, filters and joins, a small written project, and one window function to reuse at work.

Free. No credit card.

What you’ll have at the end

  • A set of queries on a sample table: aggregates, filters and joins.
  • A small project with a short written summary of what the data says.
  • One query that uses a window function.

Sponsored

One place on this page.

Get a quote

The problem this week fixes

Tutorials watched, no query you can reuse.

Who it is for

For: Analysts, marketers and operators who work with data tables.

Not for: People who need database administration or performance tuning.

Your 7-day program

One video a day, about 130 minutes of video in total, and one thing to make after each.

  1. 1

    Day 1 — What do aggregate functions do?

    Aggregate functions summarize many rows into one number. Run COUNT, SUM and AVG on a small table, and write down in a sentence what each result tells you.

    Aggregate Functions in SQLNeso Academy · 11:41

  2. 2

    Day 2 — How do you filter rows with WHERE?

    WHERE decides which rows a query keeps. Write three queries that filter a table by a number, a text value and a date, and save them.

    How to Filter with the WHERE clause in SQLBecoming a Data Scientist · 11:14

  3. 3

    Day 3 — How does a small analysis project work?

    A longer example of an analysis done with SQL. Follow the first part, then write a query of your own that answers one question on a sample table.

    Watch me Do a Data Analyst Project in minutes with SQLLore So What · 29:30

  4. 4

    Day 4 — How do you build a portfolio project?

    A step-by-step portfolio project, over half an hour. Choose a dataset, write the question you will answer, and run your first three queries on it.

    Build SQL Data Analyst Portfolio Project Step-by-Step Guide with Real Zepto DataAmlan Mohanty · Watch 9:00–32:10 (23:10)

  5. 5

    Day 5 — How do joins connect tables?

    A joins tutorial with practice queries. Write an inner join and a left join between two tables, and explain the difference in one line.

    Complete SQL Joins Tutorial | Practice SQL Query using Joins (2026) | IntellipaatIntellipaat · 14:00

  6. 6

    Day 6 — How does a real project come together?

    A long project walkthrough, so use it as a reference. Finish your own project with a short summary of findings, and save the queries as a file.

    SQL Data Analyst Portfolio Project | Like I Do in My Real ProjectsData with Baraa · Watch 6:39–22:32 (15:53)

  7. 7

    Day 7 — What are window functions?

    A look at window functions for ranking and running totals. Add one to your project, for example a ranking or a running total, and note what you can answer now that you could not before.

    Master Window Functions in SQL (Beginner to Pro) | The Most Asked Interview Topic | IntellipaatIntellipaat · 24:33

Creators you will learn from

11–30 minutes of video per day. Level: Beginner.

FAQ

Which SQL dialect do I need?

The week sticks to portable syntax that works in PostgreSQL, BigQuery, and most warehouse SQL with tiny tweaks.

Do I need a local database installed?

A free sandbox or sample dataset is enough. Challenges ask for queries and results, not a production setup.

I already know SELECT. Can I start later?

Start on Day 5 if joins are the gap. The later days assume you can filter and aggregate confidently.

Will this cover window functions?

Briefly. Day 7 introduces window functions for ranking and running totals. It is a first look, not a full treatment.

Some videos are long. Do I need to watch them all?

Two days use project walkthroughs. Use them as reference: follow the part that matches the day's task and write your own queries.

Related paths

See all learning paths

Your move

Your first result, today, on a ready path.

Try a ready path free

Free. No credit card.