SQL

External

• Learning SQL, 3rd Edition by Alan Beaulieu

Internal

• Relational Databases
• PrestoDB
• PostgreSQL

Overview

This article documents standard SQL. For database-specific extensions, we'll link to the databases-specific DML operations page.

SQL is a non-procedural language TODO: this

SQL Data Statements (DML)

UPDATE

UPDATE WHERE

DELETE

DELETE WHERE

SELECT

Query execution. SQL optimizer.

SQL Transaction Statements

Transactions.