SQL
SQL stands for Structured Query Language, which is the standard language used to work with relational databases. It is not a database itself, because naming things clearly would have ruined the whole industry. If you type "SQL" into a search box, you usually mean the language, not SQL Server or some cloud product trying very hard to borrow its name.
What SQL actually is
SQL is a database language, not a database engine, not a storage format, and not a magical folder where data behaves itself. It lets you ask a relational database for rows, change rows, create tables, and generally keep the data from turning into a small apocalypse.
In practice, SQL is the common grammar behind systems like MySQL, PostgreSQL, SQL Server, and Oracle Database. Each product has its own personality, because apparently even databases need branding.
What you do with it
Most SQL work falls into a few big moves, which is comforting if you enjoy making computers do simple things after fifty lines of syntax.
- SELECT - retrieve data
- INSERT - add new data
- UPDATE - change existing data
- DELETE - remove data
- CREATE / ALTER / DROP - define or reshape database objects
That mix is why SQL shows up everywhere in data work, reporting, apps, dashboards, and the occasional spreadsheet hero who has discovered joins and will not recover.
Why everyone pretends they know it
SQL looks simple at first, which is exactly how it gets you. A basic query is easy, then joins arrive, then grouping, then window functions, and suddenly you are reading documentation at 1:13 a.m. like it insulted your family.
The language is standardized, but each database has quirks. So yes, the same query can behave slightly differently depending on whether you are speaking to PostgreSQL or Oracle Database. The databases, naturally, insist this is a feature.
SQL vs the lookalikes
The term SQL often gets mixed up with product names, which is a classic software industry move: take the useful thing and name a product so close to it that people stop seeing the difference.
- SQL is the language
- SQL Server is Microsoft’s database product
- Cloud SQL is a Google Cloud service
- MySQL and PostgreSQL are database systems that understand SQL, with their own dialects
So if someone says they "know SQL," they might mean anything from "I can write a join" to "I once survived a reporting deadline." Both are technically valid.
Riferimenti
- Microsoft Support, Access SQL: basic concepts, vocabulary, and syntax
- MDN Web Docs, SQL - Glossary
- Oracle Database 19c, SQL Language Reference
- Microsoft Learn, SQL documentation