Data Warehousing and Data Mining

General information

Schedule

Type Day of the week Time Classroom
Lecture Monday 14:30-17:30 10
Lecture Thursday 13:00-16:00 10
Practice Friday 8:30-10:00 LABINF

Announcements

Results for written exam of September 7st, 2012

Materials

Data warehousing

  1. Introduction (2 slides per page, 6 slides per page)
  2. Conceptual design (2 slides per page, 6 slides per page)
  3. Logical design (2 slides per page, 6 slides per page)
  4. OLAP analysis (2 slides per page, 6 slides per page)
  5. Physical design (2 slides per page, 6 slides per page)
  6. ETL process (2 slides per page, 6 slides per page)

Oracle

  1. Extended SQL (2 slides per page, 6 slides per page)

Data mining

  1. Introduction to data mining (2 slides per page, 6 slides per page)
  2. Data (2 slides per page, 6 slides per page) NEW Additional slides on data preparation (2 slides per page, 6 slides per page)
  3. Clustering (2 slides per page, 6 slides per page)
  4. Association Rules Fundamentals (2 slides per page, 6 slides per page)
  5. Classification I (2 slides per page, 6 slides per page)
  6. Classification II ( 2 slides per page, 6 slides per page)
  7. Classification III (2 slides per page, 6 slides per page)

Additional material (prerequisites)

  1. Introduction
  2. The Relation Model
  3. Relational algebra and calculus
  4. SQL language fundamentals (2 slides per page, 6 slides per page)
  5. Basic SQL language exercises

Exercises

Exercises from written exams

 


 Parent page 

 Menu 

 © 2024 - DataBase and Data Mining Group