2.02 Structured Query Language

Structured Query Language

a high-level computer language for storing, manipulating, and retrieving data.

standard language for relational databases, commonly supported in non-relational databases.

Strings

must be surrounded by single quotes or double quotes, e.g. ‘string’ or “string”

numeric values

123

Binary values

represented with x’0’ where the 0 is any hex value, e.g. x’ofa2’

Data Definition Language

defines the structure of the database.

• CREATE, ALTER, DROP

Data Manipulation Language

manipulates data stored in a database.

• INSERT, UPDATE, DELETE

Data Query Language

retrieves data from the database.

• SELECT

Data Control Language

controls database user access.

• GRANT, REVOKE

Data Transaction Language

• manages database transactions.

• SAVEPOINT, ROLLBACK, COMMIT