DataBase and Data Mining Group

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

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)