MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Data Warehousing

Course Summary

An introductory course about understanding data warehousing, its architecture, flow, applications and modeling.


  • +

    Course Syllabus

    • Introduction to Data Warehousing
      • Introduction and Objectives
      • Definition of Data Warehousing
      • History of Data Warehousing
      • Advantages of Data Warehousing
      • Disadvantages of Data Warehousing
      • Benefits of Data Warehousing
      • Concepts of Data Warehousing
      • Section 1 - Quiz
      • Reading Assignment Section 1
    • OLTP, OLAP and Other Terminologies
      • Introduction and Objectives
      • Online Transaction Processing
      • Data Store
      • Data Mart
      • Design Schemas
      • Meta Data
      • Data Webhouse and Data Warehousing Queries
      • Extract, Transform, Load
      • Section 2 - Quiz
      • Reading Assignment Section 2
    • Lifecycle and Rules of Data Warehouse
      • Introduction and Objectives
      • Data Warehouse Lifecycle
      • Design
      • Prototype
      • Deploy
      • Operate
      • Enhance
      • Data Warehouse Cycle of Cycles
      • First Loop
      • Second Loop
      • Third Loop
      • Fourth Loop
      • Related Factors
      • Rules of Data Warehouse
      • Section 3 - Quiz
      • Reading Assignment Section 3
    • Data Warehouse Architecture and Flow
      • Introduction and Objectives
      • Introduction to Data Warehouse Architecture
      • Key Components
      • Benefits of Data Warehouse Architecture
      • Typical Architecture of Data Warehousing
      • Common Architecture
      • Data Warehouse Information Flow
      • Section 4 - Quiz
      • Reading Assignment Section 4
    • Data Warehouse Modeling
      • Introduction and Objectives
      • Importance of Data Modeling
      • Introduction to Data Modeling Techniques
      • Entity-Relationship Modeling
      • Limitations of ER
      • Dimensional Modeling
      • Benefits of Dimensional Modeling
      • Section 5 - Quiz
      • Reading Assignment Section 5
    • Data Warehouse Applications
      • Introduction and Objectives
      • Introduction to Data Warehouse Application
      • Retail Industry
      • Manufacturing and Distribution
      • Bank
      • Insurance Company
      • Health Care Providers
      • Government Agencies
      • Internet Companies
      • Telecommunications
      • Sports
      • Section 6 - Quiz
      • Reading Assignment Section 6
    • Challenges and Future of Data Warehouse
      • Introduction and Objectives
      • Challenges to Data Warehousing
      • Ensuring Data Quality
      • Ensuring Performance
      • Testing the Data Warehouse
      • Reconciliation of Data
      • User Acceptance
      • Future of Data Warehouse
      • Section 7 - Quiz
      • Reading Assignment Section 7
    • Course Resources
      • Data Warehousing Complete Certification Kit Book
      • Data Warehousing Glossary of Terms
      • Quiz Answer Sheet
    • Data Warehousing Certification
      • Final Exam
      • Evaluation Form
      • Conclusion - Final Lecture


Course Fee:
USD 149

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top