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 page6 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 page6 slides per page)
  2. Data (2 slides per page6 slides per page) NEW Additional slides on data preparation (2 slides per page, 6 slides per page)
  3. Clustering (2 slides per page6 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