This information refers to the course of A.Y. 2019/2020
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.
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.
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.
Wednesday, 9.30 - 11.30, A1.6
Friday, 8.30 - 11.30, A1.6
Team code (online)
n. 1 sessione II 2020
: 24 June 2020, 9.30
n. 2 sessione II 2020
: 8 July 2020, 9.30
n. 3 sessione II 2020
: 23 July 2020, 9.30
n. 1 sessione III 2020
: 15 September 2020, 9.30
n. 1 sessione IV 2021
: 26 January 2021, 10.00
n. 2 sessione IV 2021
: 9 February 2021, 10.00
n. 3 sessione IV 2021
: 23 February 2021, 10.00
Resources for Foreign Students
This section contains didactic material for English-speaking students.
This section contains links to (free) applications used in the course
Each group can freely choose which project to implement