This shows you the differences between two versions of the page.
Next revision | Previous revision Next revision Both sides next revision | ||
teaching:dw2013-w9 [2013/11/13 09:24] tcalders created |
teaching:dw2013-w9 [2013/11/13 12:47] tcalders [Exercises] |
||
---|---|---|---|
Line 13: | Line 13: | ||
===== Slides ===== | ===== Slides ===== | ||
* [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW08a-TL.pdf|Slides Transform-Load]] | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW08a-TL.pdf|Slides Transform-Load]] | ||
- | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW08b-DataMining.pdf|Slides Data Mining]] | ||
===== Reading material ===== | ===== Reading material ===== | ||
Line 19: | Line 18: | ||
===== Exercises ===== | ===== Exercises ===== | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/W8-ex/SSIS%20Update%20Exercise.pdf|ETL Update Exercise]] | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/W8-ex/CreateW9database-students.dtsx|the (incomplete)ETL package]] | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/W8-ex/createtablestatements.txt|Create table statements for the data warehouse]] | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/W8-ex/changes_DB_createtables.txt|Create table statements for the updates database]] | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/W8-ex/dates.txt|The dates source text file]] |