What’s on the SQL Basics poster
A 8-row table: Written · Runs · Does.
Written order on the left; the order the database actually evaluates them on the right.
- SELECT — 5th — Chooses columns
- FROM — 1st — Chooses tables
- JOIN — 2nd — Combines them
- WHERE — 3rd — Filters rows
- GROUP BY — 4th — Collapses into groups
- HAVING — 4th (after) — Filters groups
- ORDER BY — 6th — Sorts the result
- LIMIT — 7th — Caps the rows
You cannot use a SELECT alias in WHERE, because WHERE runs first. You can use it in ORDER BY, which runs later.
Questions about the SQL Basics poster
- What’s on the SQL Basics poster?
- A 8-row table: Written · Runs · Does. Written order on the left; the order the database actually evaluates them on the right. SELECT — 5th — Chooses columns; FROM — 1st — Chooses tables; JOIN — 2nd — Combines them; WHERE — 3rd — Filters rows; GROUP BY — 4th — Collapses into groups; HAVING — 4th (after) — Filters groups; ORDER BY — 6th — Sorts the result; LIMIT — 7th — Caps the rows. You cannot use a SELECT alias in WHERE, because WHERE runs first. You can use it in ORDER BY, which runs later.
- Who is the SQL Basics poster for?
- SQL Basics belongs to the Computing section rather than to a school year, because computing is not something one grade owns. Anyone learning languages can pin it up — a beginner, a student mid-course, or someone revising years later.
- When should you use the SQL Basics poster?
- SQL runs FROM first and SELECT nearly last. That explains most confusing errors. A wall chart earns its place by being glanceable from where the work is happening, so SQL Basics belongs on the wall where that computing work actually happens, within glancing distance, rather than filed away.
- What other posters go with SQL Basics?
- REST API Design, Bash Scripting and Error Handling sit alongside SQL Basics in the Computing section. Printed together they make a wall rather than a single sheet, which is how a reference set actually gets used.REST API DesignBash ScriptingError Handling
- Is the SQL Basics poster free to download and print?
- Yes. SQL Basics downloads as a free PDF with no account, no email and no watermark, like everything else in the Computing section. Print as many copies as you like for a home, a classroom, a library or a tutoring group; reselling the file is the only thing the licence rules out.Read the licence
- What size does the SQL Basics poster print at?
- SQL Basics is a vector PDF laid out for US Letter, and prints on A4 with Fit to page — the same file, no separate download. Because every mark on it is drawn rather than photographed, it stays sharp enlarged to A3, A2 or A1 at a copy shop. Colour carries emphasis only, so a greyscale print of SQL Basics loses nothing.Printing guide
Related posters
Charts that sit alongside SQL Basics on the same wall.
Browse every Computing poster, or start from the full catalogue.