This information refers to the course of A.Y. 2017/2018

Syllabus

  • 1 Requirements analysis. Conceptual databases design. The Entity-Relationship diagrams.
  • 2 Logical database design. Restructuring and optimization of ER diagrams. Switching from conceptual model to logical model.
  • 3 Data types in SQL. Operators and expressions in SQL. User management and permissions in a DBMS. Creating and editing tables in SQL. Table constraints. Referential integrity constraints.
  • 4 Inserting data with SQL. Deleting data with SQL. Updating data with SQL.
  • 5 Basic SQL queries. Advanced queries: internal and external joins between tables. Advanced queries: subqueries. Advanced queries: grouping. Advanced queries: union, intersection, difference.
  • 6 Advanced SQL Concepts: views. Advanced SQL Concepts: procedures. Advanced SQL Concepts: triggers. Interfacing with programming languages: Java /JDBC. Interfacing with programming languages: PHP.

Textbooks

  • Atzeni, Ceri, Paraboschi, Torlone, Database Systems - Concepts, Languages and Architectures, McGraw-Hill
    This book, published by McGraw Hill, is out of print; authors decided to make it available in PDF format at no cost. Slides and exercises can be found on the same book website. The arguments from this book addressed the course are listed in the 'instructions for foreign students' below.
  • Garcia-Molina, Ullman, Widom, Database Systems: The Complete Book, McGraw-Hill
    The book is also available in PDF format. Slides based on the book can be found on the book website. The arguments from this book addressed the course are listed in the 'instructions for foreign students' below.

Lectures

Schedule
  • Wednesday, 11.30 - 13.30, A1.6
  • Friday, 9.30 - 12.30, A1.6
Log
Last lecture : 8 June 2018
Total lectures : 24 lectures (60 hours )
Read the lectures log

Examination Dates

  • Appello n. 1 sessione II 2018
    Oral : 20 June 2018, 10.00
  • Appello n. 2 sessione II 2018
    Oral : 4 July 2018, 10.00
  • Appello n. 3 sessione II 2018
    Oral : 18 July 2018, 10.00
  • Appello n. 1 sessione III 2018
    Oral : 11 September 2018, 10.00
  • Appello n. 1 sessione III (prolungamento) 2019
    Oral : 23 January 2019, 10.00
  • Appello n. 2 sessione III (prolungamento) 2019
    Oral : 6 February 2019, 10.00
  • Appello n. 3 sessione III (prolungamento) 2019
    Oral : 20 February 2019, 10.00

Contacts

Office hours
  • Wednesday, 15 - 17
Teacher email
giuseppe.dellapenna@univaq.it

Resources

Projects