SQL The SELECT statement (purpose, syntax) Set operations (union, union all, intersect, minus) Joins (inner, outer (left, right, full)) Subqueries (returning one row, many rows, many columns) DML constructions: INSERT, UPDATE, DELETE, MERGE, TRUNCATE DDL constructions: CREATE, ALTER, DROP Understanding of relationship types (1-to-1, 1-to-many, many-to-many) Understanding of the basics of relational databases Differentiating between database and DBMS Differentiating between PK, FK, and candidate keys
