SQL - The Structured Query Language

This lecture (Thursday Nov 11 8am) introduces the core statements and usage of SQL as well as some of its foundations (i.e., relational calculus) . We cover data definition statements such as creating and modifying tables or views, nested queries and integrity/referential constraints as well as retrieval queries and aggregations.

The main readings of this lecture are:

  • chapters 6 and 7 from the main textbook or
  • chapter 3 and 4 (excluding 4.3, 4.6, 4.7) from the alternative (Silberschatz) textbook .

Optional readings (relational calculus) include:

You can find the slides of the live lecture (2022) here Download here.

Live lecture video (2021)

Pre-recorded (condensed version without tuple relational calculus) (2020) here Links to an external site..