computer class

Critical Path ITE 5323 Oracle Datawarehouse Fundamentals, Spring /Fall 2022

The Critical Path is the calendar, timeline, or weekly course schedule. It is an important document that lays out weekly objectives that you, the student, are responsible for to ensure academic success. You are strongly advised to print out a copy of the Critical Path and to refer to it regularly.

Modules Topics, Readings, and Activities Due Date Weight

1(September 9) Module Week 1  Course outline  Introduce course  Introduce Humber cloud server  Lab Exercise 1 Install vApp on cloud server 2%

2(September 16) Module 2  Reading: Lecture 2 Evolution of Data

Warehouse  Reading: Partitioning Concepts  Lab Exercise 2 Partitions

2%

3(September 23) Module 3  Reading Lecture 3 Multidimensional Model

Concepts  Lab Exercise 3 Create Schema

2%

4(September 30) Module 4  Reading: Lesson 4 Analytic Views  Lab exercise 4 Sequence and Analytic Views

3%

5(October 7) Module 5  Reading: Lesson 5 Modelling

 Reading: Partitioning  Lab Exercise 5 Database Sizing  Assignment 1 Partitioning

3%

5%

6(October 14) Module 6  Reading: Lesson 6 ETL  Lab Exercise 6 External Tables

3%

7(October 21) Module Week 7  Reading: Lesson 7 ODI and ADW  Lab Exercise 7 ODI  Assignment 2 External Tables

3%

5%

Break Week (October 24 – October 28)

8(November 4) Module Week 8  Midterm Exam  Modules 1, 2, 3, 4, 5, 6, and 7 

25%

9(November 11) Module Week 9  Reading: Lesson 8  Lab Exercise 8 Merge and Multitable Inserts

3%

10(November 18) Module Week 10  Reading: unit09 Lesson 9 Triggers  Lab Exercise 9 Triggers  Assignment 3 Multitable Inserts and

Merge

3%

5%

11(November 25) Module Week 11  Reading Lesson 10 Materialized Views  Lab Exercise 10 Materialized Views

3%

12(December 2) Module Week 12  Reading Lesson 11 Indexes  Lab Exercise 11 Explain Plan and Indexes  Assignment 4 MVs and Indexes

3%

5%

13(December 9) Module Week 13  Reading: Lesson 12 Metadata  Reading: Relational Model to Star

3%

14(December 16) Module Week 14  Final Exam  Modules (8, 9, 10, 11, 12, and 13)

Could also include material from the Midterm

25%

Projects or Assignments 0

Total Labs 50%

Mid Term and Final Exam 50%

TOTAL 100%