Ask your database a question: SQL in 5 minutes

What SQL really is

SQL (say "sequel" or "S-Q-L", both fine) is just a way to ask a database questions in a structured way. A database is a set of tables — think spreadsheets, but bigger and more reliable. SQL is how you pull exactly the rows and columns you want, without exporting the whole thing.

It reads almost like English. That's not an accident — it was designed that way.

The one sentence that runs everything

SELECT columns
FROM table
WHERE condition;

Read it top to bottom: SELECT these columns FROM this table WHERE this is true. That's 90% of everyday SQL right there.

A real example

Say you have a customers table and you want the names and emails of everyone in Singapore:

SELECT name, email
FROM customers
WHERE country = 'Singapore';

The database hands you back just those two columns, just the Singapore rows. No exporting, no filtering by hand.

Summarising: the part that replaces PivotTables

Want totals per group? GROUP BY is SQL's version of a PivotTable. This gives you total sales per country:

SELECT country, SUM(sales)
FROM orders
GROUP BY country;

One line, and you've got a summary table that would take several clicks in Excel — and it re-runs instantly on fresh data.

Joining tables: the real superpower

Data usually lives in more than one table — customers in one, orders in another. JOIN stitches them together on a shared column (like a customer ID):

SELECT customers.name, orders.total
FROM orders
JOIN customers ON orders.customer_id = customers.id;

This is the same "match two sheets" job that XLOOKUP does in Excel — but SQL does it across millions of rows without breaking a sweat.

How to actually try it

You don't need to install anything to start. Free browser-based sandboxes like SQLite Online or W3Schools' "Try SQL" editor let you run these exact queries on sample data right now. Type the SELECT above, change the country, watch the results change. That loop — question, query, answer — is the whole skill.

Once it clicks, you'll stop asking colleagues to "pull the numbers" and start pulling them yourself.