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

Private Databases lessons with AI

Databases 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 teacherDegree course final exam

Teacher: Noa

  • Course updated 11/2026
  • Hebrew, and 5 more languages
  • 4 levels
  • 46 lessons · about 26 hours of lessons

Databases

Databases 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

  • Foundations and the Entity-Relationship Model
  • The Relational Model
  • Relational Algebra
  • SQL Foundations: Definition, Retrieval and Joins
  • Advanced SQL: Aggregation, Nesting and Modification
  • Normalization: From Functional Dependencies to a Good Schema
  • Storage and Indexing
  • Query Processing and Optimization
  • Transactions and Schedules
  • Concurrency Control and Recovery
  • Exam Strategy
  • Modeling and Queries
  • Dependencies and Normalization — Computational Questions
  • Storage, Indexes and I/O Cost
  • Transactions and Concurrency — Schedule Questions
  • Mock Exam and Wrap-up

What's included

  • Live 1:1 lessons with an AI tutor on a shared board
  • 26 hours of live one-on-one lessons
  • 46 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
  • Preparation for the Degree course final exam
  • A completion certificate for each level
  • Computer, tablet or phone
  • Hebrew, plus 5 more languages

Course plan

4 levels · 16 modules · 46 lessons · 26 hr 10 min total

BeginnersDatabases — Beginner: ER Model, Relational Model and Relational Algebra3 modules • 11 lessons • 6 hr 15 min
  1. Foundations and the Entity-Relationship Model5 lessons • 2 hr 50 min
    1. 1Why a DBMS: From Files to DatabasesTrial lessonabout 30 min
    2. 2Entities, Attributes and Keys in ERabout 30 min
    3. 3Relationships, Cardinality and Participationabout 35 min
    4. 4Weak Entities, ISA Hierarchies and Ternary Relationshipsabout 35 min
    5. 5From a Story to an ER Diagram: Process and Pitfallsabout 40 min
  2. The Relational Model3 lessons • 1 hr 40 min
    1. 6Relations, Tuples and Keysabout 30 min
    2. 7Integrity Constraints and Foreign Keysabout 30 min
    3. 8Mapping ER to Relational Schemaabout 40 min
  3. Relational Algebra3 lessons • 1 hr 45 min
    1. 9Selection, Projection, Rename and Set Operationsabout 30 min
    2. 10Cartesian Product and Joinsabout 35 min
    3. 11Negation and 'For All' Queries: Difference and Divisionabout 40 min
IntermediateIntermediate: SQL and Normalization3 modules • 12 lessons • 6 hr 40 min

Mapped to exam: מבחן סופי באוניברסיטה

  1. SQL Foundations: Definition, Retrieval and Joins4 lessons • 2 hr
    1. 1Schema Definition in SQL: CREATE TABLE and Constraintsabout 30 min
    2. 2SELECT-FROM-WHERE and Its Link to Relational Algebraabout 30 min
    3. 3NULL and Three-Valued Logicabout 25 min
    4. 4Joins in SQL: Inner, Outer and Self Joinabout 35 min
  2. Advanced SQL: Aggregation, Nesting and Modification3 lessons • 1 hr 40 min
    1. 5Aggregation, GROUP BY and HAVINGabout 35 min
    2. 6Nested Queries: IN, EXISTS, ALL and ANYabout 35 min
    3. 7Data Modification and Viewsabout 30 min
  3. Normalization: From Functional Dependencies to a Good Schema5 lessons • 3 hr
    1. 8Anomalies and Functional Dependenciesabout 30 min
    2. 9Armstrong's Axioms, Attribute Closure and Finding Keysabout 35 min
    3. 10Minimal Cover and Lossless, Dependency-Preserving Decompositionabout 35 min
    4. 11Normal Forms 2NF, 3NF and BCNF and Decomposition Algorithmsabout 40 min
    5. 12From a Story to a Normalized Schema and Queryabout 40 min
AdvancedDatabases — Advanced: Storage, Indexing, Transactions and Concurrency4 modules • 11 lessons • 6 hr 15 min
  1. Storage and Indexing3 lessons • 1 hr 40 min
    1. 1Disks, Pages and File Organization: the I/O Cost Modelabout 30 min
    2. 2B+ Trees: Search, Insert and Splitabout 35 min
    3. 3Hash Indexes, Clustered and Composite Indexesabout 35 min
  2. Query Processing and Optimization2 lessons • 1 hr 15 min
    1. 4External Sort and Join Algorithmsabout 40 min
    2. 5Query Optimization: Selectivity, Plans and EXPLAINabout 35 min
  3. Transactions and Schedules3 lessons • 1 hr 35 min
    1. 6Transactions and ACID: What Can Go Wrongabout 30 min
    2. 7Conflict Serializability and the Precedence Graphabout 35 min
    3. 8Recoverability: Recoverable, ACA and Strict Schedulesabout 30 min
  4. Concurrency Control and Recovery3 lessons • 1 hr 45 min
    1. 9Locking: 2PL, Strict 2PL and Deadlocksabout 35 min
    2. 10Timestamp Ordering, MVCC and SQL Isolation Levelsabout 35 min
    3. 11Crash Recovery: WAL, Undo/Redo and Checkpointsabout 35 min
Test prepDatabases Final Exam Preparation6 modules • 12 lessons • 7 hr

Mapped to exam: מבחן סופי באוניברסיטה (מועד א) בקורס מסדי נתונים

  1. Exam Strategy1 lesson • 30 min
    1. 1Exam Anatomy, Question Types and Time Managementabout 30 min
  2. Modeling and Queries4 lessons • 2 hr 15 min
    1. 2The ER Exam Question: Story to Diagram to Schemaabout 35 min
    2. 3Relational Algebra Exam Patterns: Only, All, At Least Twoabout 35 min
    3. 4SQL on the Exam: GROUP BY, NULL and NOT IN Trapsabout 35 min
    4. 5Query Equivalence: Algebra vs SQL in Multiple Choiceabout 30 min
  3. Dependencies and Normalization — Computational Questions2 lessons • 1 hr 10 min
    1. 6Closure, Keys and Minimal Cover — The Methodabout 35 min
    2. 7BCNF/3NF Decomposition and Lossless-Join Checkabout 35 min
  4. Storage, Indexes and I/O Cost1 lesson • 35 min
    1. 8Calculation Questions: B+ Tree Height and Join Costsabout 35 min
  5. Transactions and Concurrency — Schedule Questions2 lessons • 1 hr 10 min
    1. 9Classifying Schedules: Serializability and Recoverabilityabout 35 min
    2. 10Simulations: Locking, Timestamps and Log Recoveryabout 35 min
  6. Mock Exam and Wrap-up2 lessons • 1 hr 20 min
    1. 11Mock Past Exam: Part A Under Timeabout 40 min
    2. 12Mock Past Exam: Part B and Final-Days Planabout 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

  • Adults: for work, study, an exam, or just curiosity
  • For anyone preparing for Degree course final exam

Exams and certifications

  • Degree course final exam
  • Intermediate: מבחן סופי באוניברסיטה
  • Test prep: מבחן סופי באוניברסיטה (מועד א) בקורס מסדי נתונים
  • Calculus

    with Noam

    Live 1:1 lesson with an AI teacherabout 28 hours48 lessons4 levelsCalculus 1/2 exam
  • Linear Algebra

    with Noam

    Live 1:1 lesson with an AI teacher4 levelsLinear Algebra exam
  • Discrete Math

    with Noam

    Live 1:1 lesson with an AI teacher4 levelsDiscrete Math exam
  • Statistics and Probability

    with Noam

    Live 1:1 lesson with an AI teacher4 levelsStatistics exam
  • Physics for students

    with Noam

    Live 1:1 lesson with an AI teacher4 levelsPhysics 1/2 exam
  • General Chemistry

    with Noa

    Live 1:1 lesson with an AI teacher4 levelsGeneral Chemistry exam
  • Biology for students

    with Noam

    Live 1:1 lesson with an AI teacher4 levelsBiology exam
  • Intro to Economics

    with Noa

    Live 1:1 lesson with an AI teacher4 levelsIntro to Economics exam
See all courses in Courses for students

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 Databases lesson work?
Pick Databases 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 Databases course take?
11 lessons of about 34 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

DatabasesThe first 45 minutes are free

Private lessonStart free