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

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.