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

Private SQL and Databases for Developers lessons with AI

SQL and Databases for Developers 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: Noam

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

SQL and Databases for Developers

SQL and Databases for Developers 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.

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

What you'll learn

  • Databases, Tables and Keys
  • Querying: SELECT, Filtering and Sorting
  • Changing Data: INSERT, UPDATE, DELETE
  • Combining Tables with JOIN
  • Grouping and Aggregation
  • Subqueries and CTEs
  • Normalization and Schema Design
  • Window Functions: Analytics Without Collapsing Rows
  • Indexes and Performance
  • Transactions, ACID and Concurrency
  • Production Schema Design

What's included

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

BeginnersSQL Beginner: Tables, Queries and Data Changes3 modules • 12 lessons • 6 hr 30 min

Mapped to exam: roadmap.sh SQL — Basic SQL Syntax, Data Definition, Data Manipulation

  1. Databases, Tables and Keys4 lessons • 2 hr 10 min
    1. 1What Is a Relational DatabaseTrial lessonabout 30 min
    2. 2Data Types and NULLabout 30 min
    3. 3Primary Keys and Foreign Keysabout 35 min
    4. 4CREATE TABLE and Constraintsabout 35 min
  2. Querying: SELECT, Filtering and Sorting5 lessons • 2 hr 35 min
    1. 5SELECT: Columns, Expressions and Aliasesabout 30 min
    2. 6WHERE: Conditions, AND, OR and NOTabout 35 min
    3. 7IN, BETWEEN, LIKE and IS NULLabout 30 min
    4. 8ORDER BY, LIMIT and DISTINCTabout 30 min
    5. 9Basic Aggregate Functionsabout 30 min
  3. Changing Data: INSERT, UPDATE, DELETE3 lessons • 1 hr 45 min
    1. 10INSERT: Adding Rowsabout 30 min
    2. 11UPDATE and DELETE Safelyabout 35 min
    3. 12Capstone: A Database for a Clubabout 40 min
IntermediateIntermediate: JOINs, Grouping, Subqueries and Normalization4 modules • 12 lessons • 6 hr 35 min
  1. Combining Tables with JOIN3 lessons • 1 hr 35 min
    1. 1INNER JOIN: Joining Two Tables on a Keyabout 30 min
    2. 2Outer Joins: Rows Without a Matchabout 30 min
    3. 3Multi-Table Joins, Junction Tables and Self Joinabout 35 min
  2. Grouping and Aggregation3 lessons • 1 hr 35 min
    1. 4GROUP BY: Summaries per Groupabout 30 min
    2. 5HAVING and Logical Query Orderabout 30 min
    3. 6Aggregating over Joins and Conditional CASEabout 35 min
  3. Subqueries and CTEs3 lessons • 1 hr 40 min
    1. 7Scalar Subqueries and INabout 30 min
    2. 8Correlated Subqueries, EXISTS and the NOT IN Trapabout 35 min
    3. 9Derived Tables, CTEs with WITH, and UNIONabout 35 min
  4. Normalization and Schema Design3 lessons • 1 hr 45 min
    1. 10Anomalies, 1NF and 2NFabout 30 min
    2. 113NF and Mapping ER to Tablesabout 35 min
    3. 12Project: Normalized Schema and Real Queriesabout 40 min
AdvancedAdvanced (Professional): Production-Grade SQL4 modules • 12 lessons • 6 hr 40 min
  1. Window Functions: Analytics Without Collapsing Rows3 lessons • 1 hr 35 min
    1. 1OVER and PARTITION BY: Aggregates That Keep Rowsabout 30 min
    2. 2Ranking: ROW_NUMBER, RANK and Top-N per Groupabout 30 min
    3. 3LAG, LEAD, Running Totals and Window Framesabout 35 min
  2. Indexes and Performance3 lessons • 1 hr 45 min
    1. 4How the Database Finds a Row: B-tree Indexesabout 35 min
    2. 5Composite and Covering Indexes, Sargable Queriesabout 35 min
    3. 6EXPLAIN: Reading Query Plans and Finding Bottlenecksabout 35 min
  3. Transactions, ACID and Concurrency3 lessons • 1 hr 35 min
    1. 7Transactions and ACID: All or Nothingabout 30 min
    2. 8Isolation Levels and Concurrency Anomaliesabout 35 min
    3. 9Locks, Deadlocks and Optimistic Lockingabout 30 min
  4. Production Schema Design3 lessons • 1 hr 45 min
    1. 10Schema Decisions: Keys, Types and Constraintsabout 35 min
    2. 11Security and Schema Change: SQL Injection, Privileges, Migrationsabout 30 min
    3. 12Capstone: A Production-Grade Booking Systemabout 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

  • Beginners: roadmap.sh SQL — Basic SQL Syntax, Data Definition, Data Manipulation
  • 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

NoamNoamAI 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 and Databases for Developers lesson work?
Pick SQL and Databases for Developers 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 and Databases for Developers course take?
12 lessons of about 33 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 and Databases for DevelopersThe first 45 minutes are free

Private lessonStart free