What Is SQL & Why Learn It

An IPL season produces a mountain of data: every ball bowled, every run scored, every ticket sold, every fantasy-team pick and every live score update. One season can easily create tens of millions of rows. You cannot open that in Excel and scroll. To answer a simple question like "total runs by team?" you need a way to ask the data a question and get the answer back in a second. That way is SQL.

Definition

SQL (Structured Query Language) is a standard, declarative language used to create, read, update and delete data stored in a relational database. You describe what result you want, and the database engine works out how to get it.

Let us unpack every word of that definition:

• Structured — the data lives in organised tables made of rows and columns, not in loose text files.
• Query — a query is a question you ask the database (for example, "who scored more than 500 runs?"). The database replies with a result set (a small table of answers).
• Language — SQL is a fixed set of commands and rules (SELECT, INSERT, CREATE …) that every relational database understands.
• Declarative — you do not write loops or step-by-step instructions. You say what you want; the database's query optimizer decides the fastest way to fetch it.

Note: You can pronounce it "S-Q-L" (ess-cue-el) or "sequel". Both are correct and both are used in interviews.

One question, one answer

Imagine the IPL data is stored in a table called players. You want to know "Who scored over 500 runs?". In SQL you write:

SELECT name, runs
FROM players
WHERE runs > 500;

The database returns:

Read it almost like English: "select the name and runs from the players table where runs is greater than 500." That readability is a big reason SQL has survived for more than 50 years.

One language, many databases

SQL is an ANSI/ISO standard, so the same core language works across many database products:

About 90% of everyday SQL is identical everywhere. Each product adds a few extras of its own (for example, SQL Server writes SELECT TOP 3 while MySQL writes LIMIT 3). Learn one dialect well and switching to another takes a few hours, not months.

Why learn SQL?

Even if you become a Python developer or a data scientist, the data you work with will almost always come out of a database — and SQL is the key to that door.

What you can do with SQL

• Read data — "show me all MI players" (SELECT)
• Add data — "a new player joined RCB" (INSERT)
• Change data — "update Kohli's runs after today's match" (UPDATE)
• Remove data — "delete a cancelled match" (DELETE)
• Build structure — "create a new table for ticket sales" (CREATE TABLE)
• Control access — "let the analyst read but not delete" (GRANT)

Common mistakes

• ❌ Thinking SQL is a database. ✅ SQL is the language; SQL Server, MySQL and PostgreSQL are the database software that understands it.
• ❌ Thinking SQL runs top-to-bottom like Python. ✅ SQL is declarative — the engine decides the order (you will learn the real execution order in Chapter 2).
• ❌ Learning "MySQL" and "SQL Server" as two separate languages. ✅ Learn standard SQL first; the dialect differences are small.

Interview tip

Q: Is SQL a programming language? A: SQL is a declarative query language, not a general-purpose programming language like Python or Java. You describe the result you want and the database decides how to produce it. Vendor extensions such as T-SQL and PL/SQL add procedural features (variables, loops, IF), which is why people sometimes call them programming languages.