This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
teaching:infoh419 [2018/08/30 15:08] ezimanyi [Course Slides] |
teaching:infoh419 [2018/08/30 15:17] ezimanyi [Grading] |
||
|---|---|---|---|
| Line 20: | Line 20: | ||
| ===== Grading ===== | ===== Grading ===== | ||
| - | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/description.pdf|Group project]] (30%) | + | * Group project (30%) |
| * Written exam (70%) | * Written exam (70%) | ||
| * the exam is open book; notes and books can be used. Laptops and other electronic devices are not allowed. | * the exam is open book; notes and books can be used. Laptops and other electronic devices are not allowed. | ||
| Line 47: | Line 47: | ||
| * Building the Data Warehouse. 4th edition. Inmon, Wiley, 2005 | * Building the Data Warehouse. 4th edition. Inmon, Wiley, 2005 | ||
| * Data Warehousing Fundamentals For IT Professionals. 2nd edition. Paulraj Ponniah, Wiley, 2010 | * Data Warehousing Fundamentals For IT Professionals. 2nd edition. Paulraj Ponniah, Wiley, 2010 | ||
| + | |||
| + | === Extra Resources === | ||
| + | [[http://www.teradatauniversitynetwork.com/|Teradata University Network]] For the 2013-2014 academic year, the student password is 'UnifiedDataArchitecture' | ||
| ==== Prerequisites ==== | ==== Prerequisites ==== | ||
| Line 53: | Line 56: | ||
| * Keys and functional dependencies: Section 8.3.1 | * Keys and functional dependencies: Section 8.3.1 | ||
| * BCNF: 8.3.2 | * BCNF: 8.3.2 | ||
| + | |||
| ===== Course Slides ===== | ===== Course Slides ===== | ||
| Line 66: | Line 70: | ||
| * {{teaching:infoh419:dw08-indexing.pdf|Indexing}} | * {{teaching:infoh419:dw08-indexing.pdf|Indexing}} | ||
| * {{teaching:infoh419:dw09-aggregatecomputation.pdf|Aggregate Computation}} | * {{teaching:infoh419:dw09-aggregatecomputation.pdf|Aggregate Computation}} | ||
| + | * {{teaching:infoh419:dw10-conclusion.pdf|Conclusion}} | ||
| Line 73: | Line 78: | ||
| * 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\\ | ||
| - | === Extra Resources === | + | |
| - | [[http://www.teradatauniversitynetwork.com/|Teradata University Network]] For the 2013-2014 academic year, the student password is 'UnifiedDataArchitecture' | + | |