In this workshop you'll learn how to consult, filter, aggregate, join, order and project data coming from a relational database by using the following statements:
SELECTDISTINCTWHEREORDER BYGROUP BY[INNER|LEFT|OUTER] JOIN
There are 3 exercise sets, you are free to choose which one to start with.
| Set | Description |
|---|---|
| 01 - Xtreme | A dataset which is used by a sportstore. |
| 02 - Tennis | A dataset which keeps track of tennis matches. |
| 03 - Planten | Exercises from last year's Databases 1. |