Every big app you use—like Roblox, YouTube, or Instagram—has a database to remember things. SQL is the hero that saves and finds all that data! 🦸‍♂️

In SQL, data is stored in Tables (they look just like Excel sheets!). Let's look at a table called students. We will use this table for all our fun examples! 👇

To get data out, we use the magic word SELECT. The star * means "everything". So SELECT * FROM students; means "Give me everything from the students table!" 🌟

-- Get everything from the table
SELECT * FROM students;

-- Get only the names and ages
SELECT name, age FROM students;

--- Result 1 ---
id | name  | age | course   | grade
1  | Aarav | 13  | Robotics | A
2  | Priya | 12  | Art      | B+
3  | Rahul | 14  | Robotics | A-
4  | Neha  | 13  | Music    | B

--- Result 2 ---
name  | age
Aarav | 13
Priya | 12
Rahul | 14
Neha  | 13

What if you only want to see students who are in "Robotics"? You use the WHERE clause! It acts like a detective's magnifying glass 🔍, filtering out only the rows you want.

-- Find only the Robotics students
SELECT name, course 
FROM students 
WHERE course = 'Robotics';

name  | course
Aarav | Robotics
Rahul | Robotics

Imagine sorting your Pokemon cards by their power. ORDER BY does exactly that! You can sort from A to Z (ASC) or Z to A (DESC). 🃏

-- Sort students by age, oldest first (DESC)
SELECT name, age 
FROM students 
ORDER BY age DESC;

name  | age
Rahul | 14
Aarav | 13
Neha  | 13
Priya | 12

A new student joined the class! We need to add them to our magic notebook. We use INSERT INTO to glue a new row into the table. 📥

-- Add a new student named Vikram
INSERT INTO students (id, name, age, course, grade) 
VALUES (5, 'Vikram', 13, 'Art', 'A+');

-- Let's check if he was added!
SELECT * FROM students;

✅ 1 row added.

id | name   | age | course   | grade
1  | Aarav  | 13  | Robotics | A
2  | Priya  | 12  | Art      | B+
3  | Rahul  | 14  | Robotics | A-
4  | Neha   | 13  | Music    | B
5  | Vikram | 13  | Art      | A+

Oops! Priya just had a birthday and turned 13. We need to erase the 12 and write 13. We use UPDATE to change data that is already in the table. 📝

-- Change Priya's age to 13
UPDATE students 
SET age = 13 
WHERE name = 'Priya';

-- Let's check Priya's new age
SELECT name, age FROM students 
WHERE name = 'Priya';

✅ 1 row updated.

name | age
Priya| 13

If a student leaves the school, we need to remove them. We use DELETE to completely erase a row. It's like tearing up an old page! 🗞️

-- Remove Rahul from the table
DELETE FROM students 
WHERE name = 'Rahul';

-- Let's see who is left
SELECT name FROM students;

✅ 1 row deleted.

name
Aarav
Priya
Neha
Vikram

Let's put all the magic words together! We will add a student, update a grade, delete someone, and then look at our final list. This is how real apps are made! 🚀

-- 1. Add a new student
INSERT INTO students (id, name, age, course, grade) 
VALUES (6, 'Sneha', 14, 'Music', 'B');

-- 2. Update Aarav's grade to A+
UPDATE students 
SET grade = 'A+' 
WHERE name = 'Aarav';

-- 3. Delete Neha
DELETE FROM students 
WHERE name = 'Neha';

-- 4. Show the final class, sorted by name!
SELECT name, course, grade 
FROM students 
ORDER BY name ASC;

✅ 1 row added.
✅ 1 row updated.
✅ 1 row deleted.

--- Final Class List ---
name   | course   | grade
Aarav  | Robotics | A+
Priya  | Art      | B+
Sneha  | Music    | B
Vikram | Art      | A+

Let's see how much you learned! Pick the best answer. 🧠

Check the boxes as you finish each lesson. Watch your progress bar fill up! 🌈

Awesome job reaching here! 🎉 You just learned the basics of SQL. Here are fun things to do next:

• 💭 Try writing SQL queries for a table of your favorite movies or games!
• 🍔 Learn about "JOINs" — it's like gluing two different tables together!
• 🔢 Learn math in SQL: COUNT (how many?), AVG (average), MAX (highest).
• 💻 Download a free program like "DB Browser for SQLite" to make real databases!
• 🤝 Show your School Manager project to your friends!