Databases
What Is SQL?
Also called: Structured Query Language
SQL (Structured Query Language) is the standard language for creating, reading, updating and deleting data in relational databases.
Definition
SQL is the language used to work with relational databases such as MySQL, PostgreSQL, SQL Server, Oracle and SQLite. You describe the data you want, and the database works out how to fetch it.
It is pronounced "S-Q-L" or "sequel", and it is a core skill for data analyst, data engineer and backend developer roles.
How it works
The core commands are SELECT (read), INSERT (add), UPDATE (change) and DELETE (remove). WHERE filters rows, JOIN combines tables, GROUP BY aggregates and ORDER BY sorts.
SQL is declarative: you state the result, not the steps. The database’s query planner chooses the steps and uses indexes where it can.