Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
teaching:infoh419 [2018/08/30 15:18]
ezimanyi [Books and other lecture material]
teaching:infoh419 [2018/09/01 10:16]
ezimanyi [Examinations from Previous Years]
Line 40: Line 40:
 ==== Extra books ==== ==== Extra books ====
 The following materials have been used to construct the course material, but are not required reading for the course: The following materials have been used to construct the course material, but are not required reading for the course:
-  * Kimball, Ralph; Margy Ross, Warren Thornthwaite,​ Joy Mundy, Bob Becker (2008). The Data Warehouse Lifecycle Toolkit (2nd ed.). Wiley.+  * [[https://​www.kimballgroup.com/​data-warehouse-business-intelligence-resources/​books/​data-warehouse-dw-toolkit/​|The Data Warehouse Lifecycle Toolkit]] (3rd ed.) by Ralph Kimball and Margy Ross. Wiley, 2013.
   * White and Research Papers ​   * White and Research Papers ​
     * Two survey papers: [[https://​dl.dropbox.com/​u/​5119252/​DW/​papers/​chaudhuri.pdf|paper 1]],  [[https://​dl.dropbox.com/​u/​5119252/​DW/​papers/​olap.pdf|paper 2]]     * Two survey papers: [[https://​dl.dropbox.com/​u/​5119252/​DW/​papers/​chaudhuri.pdf|paper 1]],  [[https://​dl.dropbox.com/​u/​5119252/​DW/​papers/​olap.pdf|paper 2]]
Line 49: Line 49:
  
 ==== Extra Resources ==== ==== Extra Resources ====
-[[http://​www.teradatauniversitynetwork.com/​|Teradata University Network]] For the 2013-2014 academic year, the student password is '​UnifiedDataArchitecture'​+  * [[http://​www.teradatauniversitynetwork.com/​|Teradata University Network]] For the 2013-2014 academic year, the student password is '​UnifiedDataArchitecture'​
  
 ===== Prerequisites ===== ===== Prerequisites =====
-  * Database System Concepts (Sixth Edition) by Silberschatz,​ Korth, and Sudarshan. McGraw-Hill (2011) ​[A copy of the book is available - ask the lecturer]+  * [[https://​www.mheducation.com/​highered/​product/​database-system-concepts-silberschatz-korth/​M0073523321.html|Database System Concepts]] (Sixth Edition) by Abraham ​Silberschatz, ​Henri Korth, and S. Sudarshan. McGraw-Hill (2011)
     * ER-modeling:​ Chapter 7     * ER-modeling:​ Chapter 7
     * Keys and functional dependencies:​ Section 8.3.1     * Keys and functional dependencies:​ Section 8.3.1
Line 76: Line 76:
  
 ===== Software ===== ===== Software =====
-  * For the exercises we use the SQLServer tools: MS SQLServer, SS Intergration Services, SS Analysis services, and SS Reporting Services\\+  * For the exercises we use the SQLServer tools: MS SQLServer, SS Intergration Services, SS Analysis services, and SS Reporting Services 
 + 
 +===== Exercises ===== 
 + 
 +  * [[teaching:​infoh419:​TP|Exercices Web page]] 
 + 
 +===== Examinations from Previous Years ===== 
 + 
 +  * Academic year 2017-2018 
 +    * {{:​teaching:​infoh419:​dw-exam-2017-january-solution.pdf|First session}} 
 +  * Academic year 2016-2017 
 +    * {{:​teaching:​infoh419:​dw-exam-2016-january.pdf|First session}} 
 +  * Academic year 2015-2016 
 +    * {{:​teaching:​infoh419:​dw-exam-2015-january.pdf|First session}} 
 +  * Academic year 2014-2015 
 +    * {{:​teaching:​infoh419:​dw-exam-2014-january-solution.pdf|First session}} 
 +    * {{:​teaching:​infoh419:​dw-exam-2014-july.pdf|Second session}} 
 +  * Academic year 2013-2014 
 +    * {{:​teaching:​infoh419:​dw-exam-2013-january-solution.pdf|First session}} 
 +    * {{:​teaching:​infoh419:​dw-exam-2013-july.pdf|Second session}}
  
  
    
  
 
teaching/infoh419.txt · Last modified: 2023/11/20 16:18 by ezimanyi