SQL Exercises

Hands-on SQL practice exercises that follow along with the Amigoscode SQL courses. Work through them against your own local PostgreSQL database so you actually write and run the SQL.

Courses covered

#	Course	Sections	Exercises
01	Up and Running with SQL	2	27 + 6 bonus
02	SQL Fundamentals	8	132 + 24 bonus
03	Database Design	4	55 + 16 bonus
04	Advanced Databases	20	288 + 60 bonus

How to use this repo

1. Read SETUP.md once to install PostgreSQL and create a practice database.
2. Pick a course, then a section inside it.
3. Open the section's exercises.md and work through each question in psql.
4. Some sections ship with a schema.sql / seed.sql — load them first (instructions in the section README).
5. Stuck? Peek at solutions/ — but try on your own first.

Repo layout

sql-exercise/
├── README.md              <- you are here
├── SETUP.md               <- one-time Postgres setup
├── 01-up-and-running-with-sql/
│   ├── README.md
│   ├── 01-databases/
│   │   └── exercises.md
│   └── 02-working-with-tables/
│       ├── schema.sql     (target schema for reference)
│       └── exercises.md
└── solutions/             <- will move to a `solutions` git branch later
    └── 01-up-and-running-with-sql/
        ├── 01-databases/solutions.sql
        └── 02-working-with-tables/solutions.sql

A note on solutions

Solutions currently live in a top-level solutions/ directory so they're easy to find while this repo is still local. Once the repo is initialized with git, they will be moved onto a dedicated solutions branch and removed from main, so students can't accidentally stumble on answers.