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

Terms

Table

The term comes from Codd's "A Relational Model of Data for Large Shared Data Banks" paper.

SQL Schema Statements (DDL)

• Refactor PostgreSQL DDL Operations and surface in "Standard SQL" everything that can be handled with standard SQL.
• Refactor MySQL DDL Operations and surface in "Standard SQL" everything that can be handled with standard SQL.

SQL Data Statements (DML)

Refactor PostgreSQL DML Operations and surface in "Standard SQL" everything that can be handled with standard SQL.

UPDATE

UPDATE WHERE

DELETE

DELETE WHERE

Queries with SELECT

Queries with SELECT

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.