Fundamentals of Data Warehousing (Coursera)

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.

Course 3 of 4 in the Key Technologies in Data Analytics Specialization

Syllabus

WEEK 1

Concepts

In the first module of the course, we'll learn about the core concepts of data warehousing, including subject-oriented, integrated, time-variant, and nonvolatile. By the end of this module, you will know how to identify these data warehousing characteristics and their use cases. So let's get started!

WEEK 2

Components

In the second module of this course, we'll learn about the primary components in data warehousing, including database structures, ETL and ELT, metadata, and tools.

WEEK 3

Design and Architecture

In the third module of this course, we'll learn about the design and architecture used in data warehousing, including design approaches, single tier architectures, two tier architectures, and three tier architectures.