SQL for Beginners: Building a Mini School Database from Scratch
If you're learning SQL, the fastest way to make it stick is to build something real not just read boring theory. In this post, I'll walk through a small project assignment I built while learning PostgreSQL over the weekend: a mini database for a fictional school called Greenwood Academy.
We'll go from an empty schema to a fully populated database with students, subjects, and exam results then run queries to answer real questions about the data. Along the way, we'll cover:
Creating tables (DDL)
Inserting, updating, and deleting data (DML)
