Lab Materials

Course structure, evaluation breakdown, and the full lab schedule.

Entity-Relationship notation, worked examples, and mapping ER diagrams to relational tables.

Relational database technology and the anatomy of a SQL statement.

Creating tables, data types, and modifying a table.

NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK — and managing constraints on live tables.

INSERT, UPDATE, DELETE, DEFAULT values, and the MySQL upsert equivalent.

Column projection, DISTINCT, limiting rows, comparison operators, BETWEEN/IN/LIKE, NULL handling.

Operator precedence, sorting rows, group functions, GROUP BY and HAVING.

Inner, self, and outer joins; equijoin vs. cartesian product; non-equijoins.

Single-row and multi-row subqueries, IN/ANY/ALL/EXISTS, correlated subqueries.

Creating views, updatable vs. non-updatable views, and managing views.

System vs. object privileges, GRANT and REVOKE, controlling user access.

COMMIT, ROLLBACK, SAVEPOINT, triggers, and stored procedures.