Fundamentals of Data Warehousing

Overview

Class Central Tips

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.

Syllabus

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!

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.

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.