Lectures

References:
[0] Introduction to relational databases
[1] Slides on SQL
[2] Exercise on SQL
[3] Slides on DBMS transaction management and recovery management
[4] Slides on DBMS file organization
[5] Slides on DBMS query evaluation
[6] Exercises on DBMS file organization and query evaluation
[7] Introduction to big data and data warehouses
[8] Slides on graph databases
[9] NoSQL aggregated databases
[10]The MongoDB system

1. 6/3/2018 ([0])
   Introduction. The relational data model.
2. 12/3/2018 ([0])
   The relational data model. Relational algebra.
3. 13/3/2018 ([1])
   SQL.
4. 19/3/2018 ([1])
   SQL.
5. 20/3/2018 ([1])
   SQL.
6. 26/3/2018 ([1])
   SQL.
7. 27/3/2018 ([2])
   Exercise on SQL.
8. 9/4/2018 ([3])
   Transaction management in relational database systems. Evaluation of the first homework assignment.
9. 10/4/2018
   Evaluation of the first homework assignment.
10. 16/4/2018 ([3])
    Transaction management in relational database systems.
11. 17/4/2018 ([3])
    Recovery management in relational database systems. Second homework assignment.
12. 23/4/2018 ([4])
    File organization in relational database systems: simple organizations.
13. 24/4/2018 ([4])
    File organization in relational database systems: indexed organizations.
14. 30/4/2018
    Q&A about the second homework.
15. 7/5/2018 ([4])
    File organization in relational database systems: indexed organizations. Evaluation of the second homework.
16. 8/5/2018 ([5],[6])
    Query evaluation in relational database systems. Exercise on query evaluation.
17. 14/5/2018 ([7])
    Introduction to big data and data warehouses. Evaluation of the second homework. Third homework assignment.
18. 15/5/2018 ([8])
    Graph databases.
19. 21/5/2018 ([8])
    Graph databases. RDF databases. Linked open data.
20. 22/5/2018 ([9], [10])
    NoSQL aggregated databases. The MongoDB system.
21. 28/5/2018 ([9])
    NoSQL aggregated databases. Evaluation of the third homework.
22. 29/5/2018
    Evaluation of the third homework.