SQL is the closest thing computing has to a universal language: fifty years old, declarative, and still the way virtually every organisation asks questions of its data. MySQL is the open-source database server where my students put it to work.
The pairing matters because it’s real: MySQL runs a colossal share of the web - including WordPress sites like this one - so the skills transfer directly to industry.
How I use it
Querying and joins
From SELECT and WHERE through multi-table joins, aggregation, and subqueries - translating an English question into a correct, efficient query is the core skill I drill.
Schema design
Tables, keys, constraints, and normalisation - designing databases that stay consistent as systems grow, taught through realistic scenarios rather than abstract exercises.
Administration
Users, permissions, backups, and imports - the operational side of running MySQL that separates a database user from someone you’d trust with production data.
Secure application access
Connecting PHP and Python applications to MySQL with prepared statements - where database teaching meets security teaching, because SQL injection is still everywhere.
Explore: the life of a query
Between pressing Enter and seeing results, your SQL takes quite a journey. Click or tap each stage to explore it.
In the classroom
Students design and build databases for scenarios they understand - enrolment systems, shops, bookings - then interrogate them with progressively harder questions until joins and aggregation feel natural.
We read query plans together and watch an index transform a slow query, because performance intuition is built by seeing it happen, not by memorising rules.
Test yourself
Three quick questions - click an answer to check it instantly.
1. What does the WHERE clause do in a SQL query?
2. What is the purpose of a JOIN?
3. MySQL is best described as what?
Where this leads
SQL appears in more job descriptions than any single programming language - developers, analysts, testers, and administrators all need it. This skill anchors my Database Systems teaching and connects directly to Cybersecurity, where understanding queries is the first step to preventing SQL injection.
