Data Science and Database Technology


This page has hierarchy - Parent page: Teaching

Table of content

General information

Announcements

  • [17-10-2018] The first laboratory will be held on week October 21 2018 – October 25, 2019. The text of Practice #1 (Extended SQL) is now available in Section “Practices”.
    • LAB SCHEDULE. To fit LabInf capacity students must attend all the course labs according to the following schedule (students are sorted in alphabetic order by surname):
      TEAM A (FROM A TO K) on Monday from 8.30 am to 10am
      TEAM B (FROM L TO Z) on Friday from 16pm to 17.30pm
      The compliance to the schedule above is necessary to guarantee the feasibility of the lab.



Material

  • Course introduction (slides)

Part I

    • Introduction to Big Data (slides)
    • Data warehouse: introduction (slides)
    • Data warehouse: design (slides)
    • Data warehouse: analysis (slides)
    • Data mining: introduction (slides)
    • Data mining: data preprocessing (slides)
    • Data mining: Association rules (slides). New, updated on 17/10/2019
    • Data mining: classification (slides, slidesNew)
    • [NEW] Data mining: classification, neural networks (slides)
    • Data mining: clustering (slides)
Oracle
  1. Extended SQL (2 slides per page, 6 slides per page)

Part II

Oracle
  1. Oracle Optimizer
    1. Baseline version (2 slides per page6 slides per page)
    2. Extended version with examples (2 slides per page,6 slides per page)
  2. Hints (2 slides per page6 slides per page)
  3. Documentation

 


Exercises

Data warehouse

Exercise  Text Draft solution
Extended SQL (Customer ) text
Extended SQL (Rental ) text
Data warehouse design (Italian household) exercise
Data warehouse design (SearchingYourHouse) exercise
Data warehouse design (Hotel chain) exercise
Data warehouse design (Parcels service) exercise

 


 

Practices

Topic Team A Team B Lab Assistance
Practice #1: Extended SQL in Oracle  21/10/2018  25/10/2018 assistant lecturer

LAB SCHEDULE. To fit LabInf capacity students must attend all the course labs according to the following schedule (students are sorted in alphabetic order by surname):

  • TEAM A (SURNAME STARTING WITH A TO K) on Monday from 8.30 pm to 10pm
  • TEAM B (SURNAME STARTING WITH L TO Z) on Friday from 16pm to 17.30pm

The compliance to the schedule above is necessary to guarantee the feasibility of the lab.

LAB ACCOUNT. Please make sure to have an account on the LABINF PCs before the beginning of the lab practice (the accounts used to log in to the PCs of the other LAIBs are *not* valid). To register an account at LABINF, please visit the Labinf  website for further information.

 

Lab 1: Extended SQL

    • Text (pdf)
    • Data warehouse tables in csv format (zip)
    •        FOR STUDENTS WHO WANT TO PRACTICE AT HOME WITH EXTENDED SQL:
      • to import tables using Oracle SQL Developer: Import data (right click on “Tables” of “Connection” Tab)
      • (alternatively) to import tables from the Oracle XE Web interface: select Home>Utilities>Data Load/Unload>Load>Load Text Data->)
  • Installing Oracle 11g Express Edition at home