In this course we discuss principles of modern data management. We will cover the fundamentals of relational modeling and query languages (SQL, Relational Algebra, Datalog), advanced optimizations (including worst-case optimal algorithms and magic sets), the architecture of modern relational database systems (including parallel database systems and column-oriented database systems), and transactions.

Grading criteria:

Assignments: 40%
Reviews: 10%
Project: 40%
Intangibles: 10%

Administrative Information

Instructor:
Dan Suciu

Course Assistant:
Walter Cai

Please see calendar for up-to-date office hours information.

Lectures:
Mondays, Wednesdays 10am-11:20am, via zoom, see Canvas.

Non-major?
Read this.

The video of the presentations is now available here, until June 12, 2021