SQL
Structured Query Language
ELI5 — The Vibe Check
SQL is the language you use to talk to a database. You ask it things like 'give me all users who signed up this week' and it actually does it. It looks scary at first but AI writes most of it for you anyway.
Real Talk
SQL is a domain-specific language for managing and querying relational databases. It includes commands for data definition (DDL), data manipulation (DML), and data control (DCL). Standard SQL is defined by ISO/ANSI but each database vendor adds extensions.
Show Me The Code
SELECT name, email FROM users WHERE created_at > '2024-01-01';
When You'll Hear This
"Write a SQL query to get all orders over $100." / "I don't know SQL, I just ask the AI to write it."
Related Terms
DELETE
DELETE removes rows from a table. It is the 'Delete' in CRUD. Like UPDATE, you MUST use a WHERE clause — without it, you delete everything in the table.
INSERT
INSERT is how you add new data to a database. It is the 'Create' in CRUD. You tell it which table, which columns, and what values to put in.
MySQL
MySQL is the OG popular kid of databases. Half the internet runs on it (WordPress, Facebook originally).
PostgreSQL
PostgreSQL (just say 'Postgres') is the Swiss Army knife of databases.
SELECT
SELECT is how you ask a database to give you data. It is the 'Read' in CRUD.
UPDATE
UPDATE changes existing data in a table. It is the 'Update' in CRUD.