Introduction to Databases
Table of content
- Announcements
- Exams
- Weekly timetable
- Materials
- Exercises
- Written tests
- Demo Exercises Solution
- Practices
- Homework
General information
- ECTS: 8
- Professor: Tania Cerquitelli
- Assistant lecturer: Jacopo Fior
Announcements
Weekly timetable
Type | Day of the week | Time | Classroom |
Lecture | Monday | 11:30-13:00 | Virtual Classroom |
Lecture | Tuesday | 14:30-17:30 | Virtual Classroom |
Lecture | Wednesday | 14:30-16:00 | Virtual Classroom / In person |
Lab | Tuesday | 17:30-19:00 | Virtual Classroom |
Lab | Thursday | 08:30-10:00 | Virtual Classroom |
Materials
- Introduction to the course (pdf)
- Introduction to the databases (2 slides per page, 6 slides per page)
- Relational data model (2 slides per page, 6 slides per page)
- Relational algebra (2 slides per page, 6 slides per page)
-
SQL language:
-
Basics (2 slides per page,6 slides per page)
- The SELECT statement: basics (2 slides per page,6 slides per page)
- Nested queries (2 slides per page,6 slides per page)
- Set operators (2 slides per page, 6 slides per page)
- Update commands (2 slides per page, 6 slides per page)
- Managing tables (2 slides per page,6 slides per page)
-
- SQL language: other definitions
- Management of views (2 slides per page,6 slides per page)
- Transactions (2 slides per page,6 slides per page)
- SQL for applications (2 slides per page, 6 slides per page)
- Access control (2 slides per page, 6 slides per page)
- Index management (2 slides per page,6 slides per page)
- Database design
- Design techniques and models (1 slide per page)
- Conceptual design (1 slide per page)
- Time representation (1 slide per page)
- Logical design (1 slide per page)
- Normalization (1 slide per page)
- Web programming
- Client-server architectures (1 slide per page)
- The HTML language (1 slide per page)
- The PHP language (1 slide per page, lecture_examples)
- SQL for PHP (1 slide per page)
- Cascading Style Sheet (1 slide per page)
- PHP practice (Artworks_text, Artwork_project)
- Triggers
- Part I (1 slide per page)
- Part II (1 slides per page)