| Relational model (1) |
2 Oct |
Slides |
| Relational model (2) |
3 Oct |
|
| Relational algebra (1) |
3 Oct |
Slides |
| Relational algebra (2) |
16 Oct |
|
| Relational algebra exercises (1) |
17 Oct |
Exercises: insurance, journals
|
| Relational algebra exercises (2) |
23 Oct |
|
| SQL basic concepts (1) |
24 Oct |
Slides, XAMPP
|
| SQL basic concepts (2) |
6 Nov |
|
| SQL exercises |
7 Nov |
Exercises: journals, pets, employees
|
| SQL exercises |
13 Nov |
|
| SQL aggregate operators |
14 Nov |
Slides |
| SQL exercises |
20 Nov |
Exercises: insurance, journals
|
| SQL exercises |
21 Nov |
|
| SQL transactions and views |
27 Nov |
Slides |
| SQL exercises |
28 Nov |
Exercises: catering, movies
|
| SQL exercises |
12 Dec |
Exercise: vaccines
|
| SQL exercises |
18 Dec |
|
| SQL exercises |
19 Dec |
Slides |