This information refers to the course of A.Y. 2019/2020

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, 9.30 - 11.30, A1.6
  • Friday, 8.30 - 11.30, A1.6
Team code (online)
27bzvsk
Log
Last lecture : 28 February 2020
Total lectures : 1 lectures (3 hours )
Read the lectures log

Contacts

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

Resources