Hi! I'm Anitha. This repository contains my beginner SQL practice projects. I learned SQL step by step using SQLite in GitHub Codespaces.
| File | What I Learned |
|---|---|
library.sql |
Level 1 โ Creating tables, inserting data, SELECT |
level2.sql |
Level 2 โ UPDATE, DELETE, WHERE |
level3.sql |
Level 3 โ JOIN (connecting two tables) |
level4.sql |
Level 4 โ Math: SUM, COUNT, MAX, GROUP BY |
boss.sql |
Level 5 โ Final Boss Battle (used everything!) |
- Open this repo in GitHub Codespaces.
- Open the terminal (the black box).
- Run any file like this:
sqlite3 boss.db < boss.sql- Create tables
- Insert, update, and delete data
- Filter with WHERE
- Join two tables
- Do math with SUM, COUNT, MAX, and GROUP BY
- SQLite
- GitHub Codespaces