SQL

SQL (Structured Query Language) is the standard language for asking questions of data stored in tables. You describe what you want — “show me total revenue per country, sorted highest first” — and the database figures out how to fetch it. Its core verbs are SELECT (pick columns), FROM (which table), WHERE (filter rows), GROUP BY (bucket and summarize), and JOIN (combine tables).

SQL is the most important practical skill in the data stack because nearly every warehouse, lake engine, and BI tool speaks it. It is declarative: you say what result you want, not the step-by-step algorithm, which makes simple questions short and readable. A common beginner trap is that GROUP BY without understanding how rows collapse — or a JOIN that accidentally multiplies rows — can quietly produce wrong totals, so always sanity-check counts.