DATABASE SYSTEMS
Professor: Leonid
Libkin
Class meets: Tuesdays 11:10am-1pm AT 4.12
Syllabus:
- Introduction to databases
- Relational model, algebra, calculus
- Basics of SQL programming
- Advanced SQL programming
- Database design and normalization
- Basics of query and transaction processing
- Introduction to XML (data format and query languages)
Requirements:
- Exam (75%)
- 3 assignments:
- Assignment 1: relational model, algebra, calculus, simple SQL (pencil-paper,
5%); assigned 14 October, due 21 October
- Assignment 2: SQL programming (15%), assigned 1 November, due 18
November
Using PostgreSQL on dice machines
PostgreSQL tutorial 1
PostgreSQL tutorial 2
- Assignment 3: normalization, query/transaction processing, XML (pencil-paper,
5%), assigned 20 November, due 27 November
Textbook (recommended): Ramakrishnan-Gehrke Database Management Systems
Announcements:
- Room change: starting 6 October, the class will be in AT 4.12
Lecture materials: