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. Subqueries.

SQL Transaction Statements

Transactions.

Data Types

• SQL data types
• Database-specific data types
• Working with different data types
• Conversion functions

SQL NULL

NULL in conditions.