Fri Dez. 1

Repetition & Retrospective

9 – 12h Teaching

Curriculum Retrospective

Today is our last day of class lectures. Let's have a look back and review how it went so far...

12 – 13.30h Lunch

Bonus Lecture

https://002.powercoders.org/matthias-hueni/curriculum/gdi-intro-databases/class4.html

SQL Exercises

Write SQL queries to answer the following questions about the Chinook data.

  • If you bought one copy of every track, how much would you spend?
  • What is the average track price in our store?
  • How many genres of music are represented by tracks sold in our store?
  • How many artists have albums in our store?