Learn to read data from a database — the skill everything else in SQL builds on. By the end you will know how to write any single-table query with confidence.
What you'll learn
SELECTspecific columns (or*for all)- Filter rows with
WHEREand comparison operators (=,<>,<,>,BETWEEN) - Sort results with
ORDER BY— ascending and descending - Limit output with
LIMITand skip rows withOFFSET - Remove duplicate rows with
DISTINCT - Rename columns and expressions with
AS
What you'll practice on
All exercises run against the HR database — a company with employees, departments, jobs, and salary history. You'll answer questions like "list the five highest-paid employees" and "find everyone hired before 2010."
Prerequisites
None. This is the starting point — no SQL experience required.