SelectFromData
AnalyticsLesson 1 of 4 · 10 min

What Is SQL, and Why Does Every Company Want It?

You don't need any technical background for this lesson. If you've ever used a spreadsheet, or even just a list on paper, you already have the right instincts.

Companies run on stored facts

Every business writes things down. A coffee shop records each sale. A bank records each transfer. A hospital records each appointment. A web shop records each order, each click, each return.

These recorded facts pile up fast. A small shop produces thousands of rows a year; a bank produces millions a day. They're stored in a database: software whose whole job is to keep huge amounts of recorded facts safe, organised, and ready to be questioned.

A database is not mysterious. Picture a collection of very large, very strict spreadsheets that never get tired. That picture will carry you a long way.

SQL is how you ask the database a question

The facts are in there. The problem is getting answers out.

"How much did we sell last month?" "Which product is the best seller?" "Which customers stopped ordering?" Someone has to turn each of those into an answer, and pointing and scrolling stops working at about ten thousand rows.

SQL (say "sequel" or "ess-cue-ell") is the language for asking those questions. It's short, readable, and built from plain English words. Here's a complete, real SQL query:

SELECT product, quantity
FROM orders
WHERE status = 'completed'

Read it out loud: select the product and quantity, from the orders table, where the status is completed. That's the whole trick. You describe what you want; the database figures out how to fetch it, even across a billion rows.

Key idea

SQL is not programming in the build-an-app sense. It's a question language. You describe the answer you want, in something close to English, and the database does the work.

Why it's worth your time

Three practical reasons, no hype:

  1. It's everywhere. SQL has been the standard way to question data since the 1980s, and every serious data tool speaks it: Excel's bigger cousins, Power BI, Tableau, Snowflake, BigQuery, Fabric. Learn it once, use it everywhere, for decades.
  2. It's the front door to data jobs. Data analyst, business analyst, data engineer, marketing analyst, finance roles: SQL is the single most common hard-skill requirement in their job listings. It's usually the first interview test, too.
  3. It makes you the person with answers. In most teams, the person who can pull the real number in five minutes (instead of filing a request and waiting a week) becomes quietly indispensable. That's the actual career superpower.

What it looks like in a real job

A stakeholder walks up (or emails) with a fuzzy question: "Are the new customers actually coming back?" The analyst translates the fuzzy question into precise SQL questions, runs them against the database, checks the data isn't lying (it often is, in small ways), and walks back with an answer the business can act on.

Notice the shape of that job: a little typing, a lot of thinking. That's why this platform won't just teach you syntax — it makes you practise the whole loop, with fictional clients who brief you like real ones.

One common mix-up, before you move on: SQL is not "Excel with extra steps." A spreadsheet is something you scroll and edit by hand; with SQL you write a short question and the database finds the answer — in any amount of data. That difference is why SQL keeps working at millions of rows, where scrolling and pivoting fall over.

Up next

Before writing any SQL, you need one mental model: how the data actually sits inside the database. That's tables, rows, and columns — and it takes ten minutes.