Create a database (CREATE DATABASE). Create a table definition (CREATE TABLE), including the creation of attributes with appropriate data types: CHARACTER, VARCHAR(r), BOOLEAN, INTEGER, REAL, DATE, TIME. Change a table definition (ALTER TABLE). Add a primary key to a table (PRIMARY KEY (field)). Add a foreign key to a table (FOREIGN KEY (field) REFERENCES Table (Field)). Queries including SELECT... FROM, WHERE, ORDER BY, GROUP BY, INNER JOIN, SUM, COUNT, AVG. Data maintenance including. INSERT INTO, DELETE FROM, UPDATE.

Including entity, table, record, field, tuple, attribute, primary key, candidate key, secondary key, foreign key, relationship (one-to-many, one-to-one, many-to-many), referential integrity, indexing. First Normal Form (1NF), Second Normal Form (2NF) and Third Normal Form (3NF).