45 free lesson minutes · Start now, no credit card needed
Shiur Prati

Private SQL for Analysts lessons with AI

SQL for Analysts with a live private lesson: the teacher talks with you out loud and explains on a shared board, moving at your pace through a clear plan, lesson after lesson.

Live 1:1 lesson with an AI teacher

Teacher: Noa

  • Course updated 11/2026
  • Hebrew, and 5 more languages
  • 3 levels
  • 34 lessons · about 18 hours of lessons

SQL for Analysts

SQL for Analysts with a live private lesson: the teacher talks with you out loud and explains on a shared board, moving at your pace through a clear plan, lesson after lesson.

11 lessons · 3 modules · Live private lesson with the teacher on the board

What you'll learn

  • Tables and the First Query
  • Filtering, NULL and Sorting
  • Aggregation and Grouped Summaries
  • Combining Tables: Every Kind of JOIN
  • Queries in Steps: Subqueries and CTEs
  • Dates and Times
  • Project: A Multi-Table Business Question
  • Window Functions
  • Cohorts, Funnels and Retention
  • Query Performance and Capstone

What's included

  • Live 1:1 lessons with an AI tutor on a shared board
  • 18 hours of live one-on-one lessons
  • 34 lessons on a shared board, each with a clear goal
  • Practice and a understanding check in every lesson
  • A summary after every lesson, saved in the history
  • A completion certificate for each level
  • Computer, tablet or phone
  • Hebrew, plus 5 more languages

Course plan

3 levels · 10 modules · 34 lessons · 18 hr 10 min total

BeginnersSQL for Analysts — Beginner: From First Query to Grouped Summaries3 modules • 11 lessons • 5 hr 45 min
  1. Tables and the First Query2 lessons • 55 min
    1. 1What a Table Is and Why Analysts Speak SQLTrial lessonabout 25 min
    2. 2SELECT: Columns, Aliases and DISTINCTabout 30 min
  2. Filtering, NULL and Sorting5 lessons • 2 hr 30 min
    1. 3WHERE: Filtering Rows with Conditionsabout 30 min
    2. 4IN, BETWEEN and LIKE: Smarter Conditionsabout 30 min
    3. 5NULL: The Missing Value That Breaks Conditionsabout 30 min
    4. 6ORDER BY, LIMIT and Calculated Columnsabout 30 min
    5. 7CASE WHEN: Bucketing Data into Categoriesabout 30 min
  3. Aggregation and Grouped Summaries4 lessons • 2 hr 20 min
    1. 8Aggregate Functions: COUNT, SUM, AVG, MIN, MAXabout 30 min
    2. 9GROUP BY: A Summary per Groupabout 35 min
    3. 10HAVING and the Logical Order of a Queryabout 35 min
    4. 11Capstone: A Business Question End to Endabout 40 min
IntermediateIntermediate: Joins, Subqueries, CTEs and Dates4 modules • 12 lessons • 6 hr 20 min
  1. Combining Tables: Every Kind of JOIN5 lessons • 2 hr 35 min
    1. 1The Data Model: Facts, Dimensions and Keysabout 30 min
    2. 2INNER JOIN: Pulling Columns from a Second Tableabout 30 min
    3. 3LEFT JOIN and Anti-Join: Who Never Did Itabout 35 min
    4. 4RIGHT, FULL OUTER, CROSS and Self Joinabout 30 min
    5. 5Join Fan-Out: Why the Total Doubledabout 30 min
  2. Queries in Steps: Subqueries and CTEs4 lessons • 2 hr
    1. 6Subqueries in WHERE: Scalar, IN and EXISTSabout 30 min
    2. 7Derived Tables and Correlated Subqueriesabout 30 min
    3. 8CTEs: Building a Query Step by Stepabout 35 min
    4. 9UNION and Set Operations: Stacking Resultsabout 25 min
  3. Dates and Times2 lessons • 1 hr 5 min
    1. 10Dates: Parts, Truncation and Intervalsabout 35 min
    2. 11Time Zones and Missing Days in Reportsabout 30 min
  4. Project: A Multi-Table Business Question1 lesson • 40 min
    1. 12Project: First-Month Purchase Rate per Signup Monthabout 40 min
AdvancedSQL for Analysts — Advanced: Windows, Cohorts, Funnels and Performance3 modules • 11 lessons • 6 hr 5 min

Mapped to exam: ללא מבחן חיצוני — רמה של אנליסט/ית בצוות מוצר (מפת roadmap.sh Data Analyst)

  1. Window Functions4 lessons • 2 hr 5 min
    1. 1OVER and PARTITION BY: Aggregates That Keep Every Rowabout 30 min
    2. 2ROW_NUMBER, RANK, DENSE_RANK: Ranking and Top-N per Groupabout 30 min
    3. 3Running Totals and Moving Averages: The Window Frameabout 35 min
    4. 4LAG and LEAD: Comparing to the Previous Rowabout 30 min
  2. Cohorts, Funnels and Retention4 lessons • 2 hr 15 min
    1. 5Cohorts: Grouping Users by Signup Monthabout 30 min
    2. 6Cohort Retention Table: The Classic Triangleabout 35 min
    3. 7Conversion Funnel: Who Made It Through Each Stepabout 35 min
    4. 8DAU, MAU, Day-N Retention and Churnabout 35 min
  3. Query Performance and Capstone3 lessons • 1 hr 45 min
    1. 9How the Engine Runs a Query: EXPLAIN and Indexesabout 35 min
    2. 10Writing Fast Queries: Filter Early, Sargable Predicatesabout 30 min
    3. 11Capstone: Retention and Funnel Report with Row-Count Checksabout 40 min

What you need

  • No prior knowledge needed for beginner level: the teacher checks what you already know and starts from there
  • For higher levels: what you learned at the level before (you can skip it if you already know it)
  • A computer, tablet or phone with a microphone, and a browser

Who it's for

  • Teens and adults who want to understand the subject in depth

Exams and certifications

  • Advanced: ללא מבחן חיצוני — רמה של אנליסט/ית בצוות מוצר (מפת roadmap.sh Data Analyst)
  • Coding for kids

    with Noam

    Live 1:1 lesson with an AI teacher2 levels
  • Programming in Python

    with Noam

    Live 1:1 lesson with an AI teacher3 levels
  • Web Development

    with Noam

    Live 1:1 lesson with an AI teacher3 levels
  • DevOps

    with Noa

    Live 1:1 lesson with an AI teacherabout 24 hours42 lessons3 levels
  • Cloud computing

    with Noa

    Live 1:1 lesson with an AI teacher3 levels
  • Data and SQL

    with Noa

    Live 1:1 lesson with an AI teacher3 levels
See all courses in High-tech

Your teacher

NoaNoaAI private tutor, in a live lesson on a shared board

A private AI teacher who teaches in a live conversation: asks, listens, draws on the board, and lets you solve it yourself with hints. Remembers what you've learned and starts each lesson where you left off.

What's a lesson like?

  • Your child talks with the teacher out loud, like a video call, and asks about anything unclear.

  • The teacher explains, writes and draws on a shared board, and your child solves along on the same board.

  • Snap a photo of a worksheet or homework and work through it, one problem at a time.

  • Parents get a report: study time, what went well and what needs more practice.

Lesson rules

  • Just Learning

FAQ

How does a private SQL for Analysts lesson work?
Pick SQL for Analysts and a level, then talk with the teacher out loud. The teacher asks what you already know, explains, writes and draws on the board, and lets you solve on your own with hints until it's clear.
How long does the SQL for Analysts course take?
11 lessons of about 31 minutes at the first level, at your own pace. You can pause, go back, or skip what you already know.
Do I need prior knowledge?
Not for beginner level. At the start of the first lesson the teacher checks what you already know and adjusts the level, and you can jump straight to an advanced level.
How do I start for free?
Sign in with Google or a code sent to your email, enter your child's name and grade, and the lesson starts right away. Every family gets 45 free lesson minutes in any subject, counted by actual lesson time, with no credit card. Then choose a paid plan and cancel anytime.
What device do I need?
Any computer, tablet or phone with a browser and a microphone. You can also install the site as an app on your home screen.

Want to try it?

Sign in, enter your child's name and grade, and the lesson begins. 45 free lesson minutes, no credit card.

Start for free

Shiur Prati with AI: what it is and how it works

SQL for AnalystsThe first 45 minutes are free

Private lessonStart free