CIS429
Preview: CIS429 Data Warehouse Planning :
Course Guide
Prerequisites
Course Description
Instructional Materials
Course Learning Outcomes
Weekly Course Schedule
Week 1 - To Do List
Introductions: Introduce yourself to your peers and professor.
Learn: Read Exam
Ref
70-767
Implementing
a
SQL
Data
Warehouse,
Chapter 1, Skill 1.1.
Learn: View CBT Nuggets videos.
Assignment: Complete CBT Nuggets Virtual Labs 4 and 6.
CIS111
This course covers the principles, approaches and critical issues in planning, designing and deploying data warehouses. Topics include data extraction,
data cleansing, data transformation, architecture and infrastructure. Students will examine recent trends in data warehousing, metadata and
architectural components.
Required Resources
Jose Chinchilla; 2018. Exam
Ref
70-767
Implementing
a
SQL
Data
Warehouse. Pearson Education.
CBT Nuggets. No date. Microsoft SQL Data Warehouse Implementation (70-767) . https://www.cbtnuggets.com
Note: A student code is required and must be purchased through the Strayer Bookstore. The will distribute this code to each Strayer Bookstore
registered student’s email address. Students should check their junk mail folder as well as their inbox folder for the email.
Design, implement, and maintain data warehouse infrastructure. a
1
Design extract, transform, and load (ETL) solutions for data warehouse. a
2
Build data quality solutions using best practices.
3
NOTE: The links in this document do not function. Please refer to your course to view/download linked content.
Week - To Do List 1
Quiz: Complete the weekly quiz.
Discussion: Participate in the weekly debriefing discussion.
Week - To Do List 2
Learn: Read Exam
Ref
70-767
Implementing
a
SQL
Data
Warehouse, Chapter 1, Skills 1.2 and 1.3.
Learn: View CBT Nuggets videos.
Assignment: Complete CBT Nuggets Virtual Labs 12 and 13.
Quiz: Complete the weekly quiz.
Discussion: Participate in the weekly debriefing discussion.
Week - To Do List 3
Learn: Read Exam
Ref
