• 2016/10/07 – Relational Algebra – Part I
  • Performing RA Queries (EN)
• 2016/10/14 – Relational Algebra – Part II. Q&A, Exercises
• 2016/10/21 – SQL query language (except “Esercizio 2” and “Esercizio 5”)
  • Slides (IT), Additional Exercises
  • Jan Van den Bussche, Stijn Vansummeren: Translating SQL into the Relational Algebra. [report, slides]
• 2016/10/28 – DBMS Architecture: Query Plans
  • Slides (IT), On Join Algorithms(*)
  • Jens Dittrich – Patterns in Data Management [Book, Slides+Video]
• 2016/11/04 – DBMS Architecture: Indexing: B+ Trees – Part I
  • Slides (IT)
• 2016/11/18 – DBMS Architecture: Indexing: Hashing – Part II
  • Slides (EN)
• 2016/11/25 – DBMS Architecture: Transactions
  • Slides (EN), Exercises
• 2016/11/30 – The Lab Sessions: Conceptual Data Modelling
  • A project example (ITA)
• 2016/12/02 – The Lab Sessions: RDBMS vs. Querying and Programming Languages
  • Please see this link for all the details!
• 2016/12/07 – Final Exam: A Demo. Final Q&A
  • Some examples