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.
Teacher: Noa
- Course updated 11/2026
- Hebrew, and 5 more languages
- 3 levels: Beginners · Intermediate · Advanced
- 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
Related topics
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
Tables and the First Query2 lessons • 55 min
- 1What a Table Is and Why Analysts Speak SQLTrial lessonabout 25 min
- 2SELECT: Columns, Aliases and DISTINCTabout 30 min
Filtering, NULL and Sorting5 lessons • 2 hr 30 min
- 3WHERE: Filtering Rows with Conditionsabout 30 min
- 4IN, BETWEEN and LIKE: Smarter Conditionsabout 30 min
- 5NULL: The Missing Value That Breaks Conditionsabout 30 min
- 6ORDER BY, LIMIT and Calculated Columnsabout 30 min
- 7CASE WHEN: Bucketing Data into Categoriesabout 30 min
Aggregation and Grouped Summaries4 lessons • 2 hr 20 min
- 8Aggregate Functions: COUNT, SUM, AVG, MIN, MAXabout 30 min
- 9GROUP BY: A Summary per Groupabout 35 min
- 10HAVING and the Logical Order of a Queryabout 35 min
- 11Capstone: A Business Question End to Endabout 40 min
IntermediateIntermediate: Joins, Subqueries, CTEs and Dates4 modules • 12 lessons • 6 hr 20 min
Combining Tables: Every Kind of JOIN5 lessons • 2 hr 35 min
- 1The Data Model: Facts, Dimensions and Keysabout 30 min
- 2INNER JOIN: Pulling Columns from a Second Tableabout 30 min
- 3LEFT JOIN and Anti-Join: Who Never Did Itabout 35 min
- 4RIGHT, FULL OUTER, CROSS and Self Joinabout 30 min
- 5Join Fan-Out: Why the Total Doubledabout 30 min
Queries in Steps: Subqueries and CTEs4 lessons • 2 hr
- 6Subqueries in WHERE: Scalar, IN and EXISTSabout 30 min
- 7Derived Tables and Correlated Subqueriesabout 30 min
- 8CTEs: Building a Query Step by Stepabout 35 min
- 9UNION and Set Operations: Stacking Resultsabout 25 min
Dates and Times2 lessons • 1 hr 5 min
- 10Dates: Parts, Truncation and Intervalsabout 35 min
- 11Time Zones and Missing Days in Reportsabout 30 min
Project: A Multi-Table Business Question1 lesson • 40 min
- 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)
Window Functions4 lessons • 2 hr 5 min
- 1OVER and PARTITION BY: Aggregates That Keep Every Rowabout 30 min
- 2ROW_NUMBER, RANK, DENSE_RANK: Ranking and Top-N per Groupabout 30 min
- 3Running Totals and Moving Averages: The Window Frameabout 35 min
- 4LAG and LEAD: Comparing to the Previous Rowabout 30 min
Cohorts, Funnels and Retention4 lessons • 2 hr 15 min
- 5Cohorts: Grouping Users by Signup Monthabout 30 min
- 6Cohort Retention Table: The Classic Triangleabout 35 min
- 7Conversion Funnel: Who Made It Through Each Stepabout 35 min
- 8DAU, MAU, Day-N Retention and Churnabout 35 min
Query Performance and Capstone3 lessons • 1 hr 45 min
- 9How the Engine Runs a Query: EXPLAIN and Indexesabout 35 min
- 10Writing Fast Queries: Filter Early, Sargable Predicatesabout 30 min
- 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)
More courses in this track
Your teacher
NoaAI private tutor, in a live lesson on a shared boardA 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 freeShiur Prati with AI: what it is and how it works







