SQL - The Structured Query Language

Our next 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 will follow the academic quarter convention and start at 8:15. Zoom link Links to an external site.

 

In this lecture will 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 (2021) here Ladda ner here.

Live lecture video (2021) here Links to an external site..

Pre-recorded (condensed) video on SQL (2020):