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

Private Data and SQL lessons with AI

Data and SQL 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
  • 35 lessons · about 20 hours of lessons

Data and SQL

Data and SQL 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

  • What Data Looks Like
  • First SQL Queries
  • Excel for Data Analysis
  • Summarizing Data: Aggregates and Groups
  • Combining Tables: JOINs
  • Data Cleaning
  • Visualization: Presenting the Answer
  • Complex Queries: Subqueries and CTEs
  • Window Functions
  • Data Modeling and Performance
  • Product Metrics in SQL
  • A/B Testing

What's included

  • Live 1:1 lessons with an AI tutor on a shared board
  • 20 hours of live one-on-one lessons
  • 35 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 · 12 modules · 35 lessons · 19 hr 30 min total

BeginnersBeginner: Asking Questions of Data3 modules • 11 lessons • 5 hr 55 min
  1. What Data Looks Like2 lessons • 1 hr
    1. 1Tables: Rows, Columns and Primary KeyTrial lessonabout 30 min
    2. 2Data Types and NULLabout 30 min
  2. First SQL Queries6 lessons • 3 hr 10 min
    1. 3SELECT and FROM: Retrieving Columnsabout 30 min
    2. 4WHERE: Filtering Rowsabout 30 min
    3. 5Combining Conditions: AND, OR, NOT, IN, BETWEENabout 35 min
    4. 6Text Search with LIKE and Handling NULLabout 30 min
    5. 7Sorting and Uniqueness: ORDER BY, LIMIT, DISTINCTabout 30 min
    6. 8Computed Columns and Query Execution Orderabout 35 min
  3. Excel for Data Analysis3 lessons • 1 hr 45 min
    1. 9Excel as a Data Table: Sort and Filterabout 30 min
    2. 10Excel Formulas: References, IF and COUNTIFabout 35 min
    3. 11From a Plain-Words Question to a Query: Capstoneabout 40 min
IntermediateIntermediate: Join, Aggregate, Clean and Visualize Data4 modules • 12 lessons • 6 hr 35 min
  1. Summarizing Data: Aggregates and Groups3 lessons • 1 hr 35 min
    1. 1Aggregate Functions: COUNT, SUM, AVG, MIN, MAXabout 30 min
    2. 2GROUP BY: Split Into Groups and Summarizeabout 35 min
    3. 3HAVING vs WHERE and Full Query Orderabout 30 min
  2. Combining Tables: JOINs3 lessons • 1 hr 40 min
    1. 4Foreign Keys and INNER JOINabout 35 min
    2. 5LEFT JOIN: Keeping Unmatched Rowsabout 30 min
    3. 6JOIN with GROUP BY and the Fan-Out Trapabout 35 min
  3. Data Cleaning3 lessons • 1 hr 35 min
    1. 7CASE WHEN and COALESCE: Categorize and Fill Inabout 30 min
    2. 8Cleaning in SQL: Text, Types, Dates and Duplicatesabout 35 min
    3. 9Cleaning Data in Spreadsheetsabout 30 min
  4. Visualization: Presenting the Answer3 lessons • 1 hr 45 min
    1. 10Pivot Tables: GROUP BY in a Spreadsheetabout 30 min
    2. 11Choosing the Right Chart Without Misleadingabout 35 min
    3. 12Project: Question to Query to Chart to Insightabout 40 min
AdvancedAdvanced (Professional): Complex Queries, Modeling, Product Metrics and Experiments5 modules • 12 lessons • 7 hr
  1. Complex Queries: Subqueries and CTEs2 lessons • 1 hr 10 min
    1. 1Subqueries: Scalar, IN, EXISTS and Correlatedabout 35 min
    2. 2CTEs with WITH: Breaking a Query into Stepsabout 35 min
  2. Window Functions2 lessons • 1 hr 10 min
    1. 3OVER and PARTITION BY: Ranking Within Groupsabout 35 min
    2. 4LAG, LEAD, Running Totals and Framesabout 35 min
  3. Data Modeling and Performance4 lessons • 2 hr 15 min
    1. 5Normalization: 1NF to 3NFabout 35 min
    2. 6Relationships, ERD and Constraintsabout 35 min
    3. 7Analytics Modeling: Star Schema, Facts and Dimensionsabout 35 min
    4. 8Indexes and EXPLAIN: Why Is My Query Slowabout 30 min
  4. Product Metrics in SQL2 lessons • 1 hr 10 min
    1. 9Event Data, DAU/MAU and Conversion Funnelsabout 35 min
    2. 10Retention and Cohort Analysisabout 35 min
  5. A/B Testing2 lessons • 1 hr 15 min
    1. 11Designing an A/B Test: Hypothesis, Metrics and Sample Sizeabout 35 min
    2. 12Analyzing an A/B Test: Significance, Confidence Intervals and Pitfallsabout 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
  • 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
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 Data and SQL lesson work?
Pick Data and SQL 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 Data and SQL course take?
11 lessons of about 32 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

Data and SQLThe first 45 minutes are free

Private lessonStart free