EXERCISE
1A database is an organised collection of data stored so it can be quickly found, updated, and queried. SQL is the language you use to communicate with it.
The spreadsheet analogy:
Most people start with spreadsheets — but databases are built for something spreadsheets cannot handle well:
| Spreadsheet | Database |
|---|---|
| One flat file | Many related tables |
| No rules on data | Strict types and constraints |
| Breaks at millions of rows | Handles billions of rows |
| No simultaneous users | Hundreds of users at once |
| Manual relationships | Foreign keys enforce links |
What SQL actually does:
SQL (Structured Query Language) is a language for talking to a . It is not a programming language like Python — it is a query language. You describe what you want, and the database figures out how to get it.
-- Plain English: "Show me the names of all customers in Mumbai"
SELECT name
FROM customers
WHERE city = 'Mumbai';
What is MySQL?
MySQL is a management system — the software that stores your data and understands SQL. Other systems (PostgreSQL, SQLite, SQL ) also use SQL, but with small dialect differences. This course uses MySQL.
Pro Tip: SQL has been around since 1974 and is still the most-used data skill in job listings. Learning it once gives you leverage across almost every industry.