Lecture Log

Basics of SQL: the language, writing simple queries, how these are executed.

One language to describe what data you want to see; another to formulate how to find it. Also, the unsettling capabilities of Facebook Graph Search.

Mathematical operations for slicing and dicing relational tables. Plus, some big databases.

Translating high-level visual plans for organising data into the linked tables of a relational database.

Capturing some high-level concepts in ER diagrams; and the classic “relational” model of linked tables making up a database.

Ways to talk about highly structured data: entities, attributes, keys, relationships, and the language of ER diagrams.

Brief overview of the course and its content.