Web Dev//SQL

Structured Query Language -- the standard language for interacting with relational databases. It's not a program or a database: it's the syntax that nearly all of them use.

Structured Query Language -- the standard language for interacting with relational databases. It's not a program or a database: it's the syntax that nearly all of them use.

Four basic operations (CRUD): INSERT (create), SELECT (read), UPDATE (update), DELETE (delete)

Tables, columns, rows, relations (JOIN), indexes

Dialects: PostgreSQL, MySQL, SQLite, SQL Server -- the core is the same, the extras vary

Migrations define table structure (schema): CREATE TABLE, ALTER TABLE