Day 1 – Getting Started with SQL
Module 1: Introduction to Databases
- What is a database and where SQL is used
- Real-life analogy: database as a digital filing cabinet
- Tables, rows, and columns explained
Module 2: SQL Basics
- What is SQL and why it’s important
- Using an online SQL editor (DB Fiddle / SQLite Studio)
- Creating your first table using
CREATE TABLE
Module 3: Inserting and Viewing Data
- Adding records with
INSERT INTO
- Viewing data with
SELECT * FROM
- Sorting data using
ORDER BY
- Filtering results using
WHERE
- Limiting results using
LIMIT
Hands-On Activity:
Create a Students table and run queries to view, sort, and filter records.
Day 2 – Aggregations and Joins