Monthly Subscription Starting at AED 99 + VAT

Fundamentals of Data Warehousing
  • Level Foundation
  • Duration 14 hours
  • Course by LearnQuest
  • Offered by

About

Welcome to Fundamentals of Data Warehousing, the third course of the Key Technologies of Data Analytics specialization. By enrolling in this course, you are taking the next step in your career in data analytics. This course is the third of a series that aims to prepare you for a role working in data analytics. In this course, you will be introduced to many of the core concepts of data warehousing. You will learn about the primary components of data warehousing. We’ll go through the common data warehousing architectures. The hands-on material offers to add storage to your cloud environment and configure a database. This course covers a wide variety of topics that are critical for understanding data warehousing and are designed to give you an introduction and overview as you begin to build relevant knowledge and skills.

Modules

Subject Oriented

    • 4 Videos
    • 1 Readings
    • 2 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Subject-Oriented

2 Discussions

  • What's The Theme?
  • Research Subject-Oriented And Share With The Group

4 Videos

  • Course Introduction And Objectives
  • Module Introduction And Objectives
  • Introduction To Subject-Oriented
  • Subject-Oriented In Your Reading

1 Readings

  • Data Warehousing - Overview

Integrated

    • 2 Videos
    • 1 Readings
    • 2 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Integrated

2 Discussions

  • What's In An Integration?
  • Research Integrated And Share With The Group

2 Videos

  • Introduction To Integrated
  • Integrated In Your Reading

1 Readings

  • Which Data Integration Approach Is Right For You?

Time-Variant

    • 2 Videos
    • 1 Readings
    • 2 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Time-Variant

2 Discussions

  • What Time Is It?
  • Research Time-Variant And Share With The Group

2 Videos

  • Introduction To Time-Variant
  • Time-Variant In Your Reading

1 Readings

  • Time-Variant System

Nonvolatile

    • 3 Videos
    • 1 Readings
    • 2 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • Nonvolatile
  • Module 1 Graded Quiz

2 Discussions

  • Not Fade Away!
  • Research Nonvolatile And Share With The Group

3 Videos

  • Introduction To Nonvolatile
  • Nonvolatile In Your Reading
  • Module 1 Summary

1 Readings

  • Nonvolatile Data

Database Structures

    • 3 Videos
    • 1 Readings
    • 2 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Database Structures

2 Discussions

  • A Purely Transactional Relationship
  • Research Database Structures and Share With The Group

3 Videos

  • Module Introduction And Objectives
  • Introduction To Database Structures
  • Database Structures In Your Reading

1 Readings

  • Database Structure And Design Tutorial

ETL and ELT

    • 2 Videos
    • 1 Readings
    • 2 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • ETL and ELT

2 Discussions

  • It Was a Transformational Experience
  • Research ETL and ELT And Share With The Group

2 Videos

  • Introduction To ETL and ELT
  • ETL and ELT In Your Reading

1 Readings

  • ETL vs ELT: 5 Critical Differences

Metadata

    • 2 Videos
    • 1 Readings
    • 2 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Metadata

2 Discussions

  • Data About The Data?
  • Research Metadata And Share With The Group

2 Videos

  • Introduction To Metadata
  • Metadata In Your Reading

1 Readings

  • What Is Metadata (With Examples)

Tools

    • 2 Videos
    • 1 Readings
    • 2 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Tools

2 Discussions

  • It's Tool Time!
  • Research Tools And Share With The Group

2 Videos

  • Introduction To Tools
  • Tools In Your Reading

1 Readings

  • Querying and Reporting Tools for Data Warehousing

Hands-On: Add Storage To Your AWS Environment

    • 2 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Module 2 Graded Quiz

2 Videos

  • Hands-On Demonstration
  • Module 2 Summary

1 Readings

  • Hands-On Exercise: Add Storage To Your AWS Environment

Design Approach

    • 3 Videos
    • 1 Readings
    • 2 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Design Approach

2 Discussions

  • Designs On You
  • Research Design Approach And Share With The Group

3 Videos

  • Module Introduction And Objectives
  • Introduction To Design Approach
  • Design Approach In Your Reading

1 Readings

  • Various Data Warehouse Design Approaches:Top-Down and Bottom-Up

Single Tier Architecture

    • 2 Videos
    • 1 Readings
    • 2 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Single Tier Architecture

2 Discussions

  • Stop Repeating Yourself
  • Research Single Tier Architecture And Share With The Group

2 Videos

  • Introduction To Single Tier Architecture
  • Single Tier Architecture In Your Reading

1 Readings

  • Database Architecture in DBMS: 1-Tier, 2-Tier and 3-Tier

Two Tier Architecture

    • 2 Videos
    • 1 Readings
    • 2 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Two-Tier Architecture

2 Discussions

  • Now On Stage
  • Research Two-Tier Architecture and Share With The Group

2 Videos

  • Introduction To Two Tier Architecture
  • Two Tier Architecture In Your Reading

1 Readings

  • Two-Tier vs Three-Tier Architecture

Three Tier Architecture

    • 3 Videos
    • 1 Readings
    • 2 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • Three Tier Architecture
  • Module 3 Graded Quiz

2 Discussions

  • Built For Consumption
  • Research Three Tier Architecture And Share With The Group

3 Videos

  • Introduction To Three Tier Architecture
  • Three Tier Architecture In Your Reading
  • Module 3 Summary

1 Readings

  • 3-Tier Architecture: A Complete Overview

Auto Summary

"Fundamentals of Data Warehousing," a Coursera course in the Business & Management domain, is ideal for those starting their data analytics career. Taught by experts, it covers core concepts and architectures of data warehousing, with hands-on cloud storage and database configuration. The 840-minute foundation-level course is part of the Key Technologies of Data Analytics specialization, available through a Starter subscription. Perfect for aspiring data analysts seeking essential knowledge and skills.

Erik Herman
Instructor

Erik Herman