When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Specialization?

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Fundamentals of Data Warehousing

4 days left! Save on skills that make you shine with 40% off 3 months of Coursera Plus. Save now

Fundamentals of Data Warehousing

This course is part of Key Technologies in Data Analytics Specialization

Instructor: LearnQuest Network

4,890 already enrolled

Included with

Learn more

3 modules

Gain insight into a topic and learn the fundamentals.

69 reviews

Beginner level

No prior experience required

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

3 modules

Gain insight into a topic and learn the fundamentals.

69 reviews

Beginner level

No prior experience required

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

15 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Key Technologies in Data Analytics Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 3 modules in this course

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.

Module details

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!

What's included

11 videos4 readings5 assignments8 discussion prompts

11 videosTotal 8 minutes

Course Introduction And Objectives2 minutes
Module Introduction And Objectives1 minute
Introduction To Subject-Oriented1 minute
Subject-Oriented In Your Reading0 minutes
Introduction To Integrated1 minute
Integrated In Your Reading0 minutes
Introduction To Time-Variant1 minute
Time-Variant In Your Reading0 minutes
Introduction To Nonvolatile1 minute
Nonvolatile In Your Reading0 minutes
Module 1 Summary0 minutes

4 readingsTotal 40 minutes

Data Warehousing - Overview10 minutes
Which Data Integration Approach Is Right For You?10 minutes
Time-Variant System10 minutes
Nonvolatile Data10 minutes

5 assignmentsTotal 150 minutes

Module 1 Graded Quiz30 minutes
Subject-Oriented30 minutes
Integrated30 minutes
Time-Variant30 minutes
Nonvolatile30 minutes

8 discussion promptsTotal 80 minutes

What's The Theme?10 minutes
Research Subject-Oriented And Share With The Group10 minutes
What's In An Integration?10 minutes
Research Integrated And Share With The Group10 minutes
What Time Is It?10 minutes
Research Time-Variant And Share With The Group10 minutes
Not Fade Away!10 minutes
Research Nonvolatile And Share With The Group10 minutes

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.

What's included

11 videos5 readings5 assignments8 discussion prompts

11 videosTotal 11 minutes

Module Introduction And Objectives0 minutes
Introduction To Database Structures2 minutes
Database Structures In Your Reading0 minutes
Introduction To ETL and ELT1 minute
ETL and ELT In Your Reading0 minutes
Introduction To Metadata1 minute
Metadata In Your Reading0 minutes
Introduction To Tools1 minute
Tools In Your Reading0 minutes
Hands-On Demonstration4 minutes
Module 2 Summary0 minutes

5 readingsTotal 50 minutes

Database Structure And Design Tutorial10 minutes
ETL vs ELT: 5 Critical Differences10 minutes
What Is Metadata (With Examples)10 minutes
Querying and Reporting Tools for Data Warehousing10 minutes
Hands-On Exercise: Add Storage To Your AWS Environment10 minutes

5 assignmentsTotal 150 minutes

Module 2 Graded Quiz30 minutes
Database Structures30 minutes
ETL and ELT30 minutes
Metadata30 minutes
Tools30 minutes

8 discussion promptsTotal 80 minutes

A Purely Transactional Relationship10 minutes
Research Database Structures and Share With The Group10 minutes
It Was a Transformational Experience10 minutes
Research ETL and ELT And Share With The Group10 minutes
Data About The Data?10 minutes
Research Metadata And Share With The Group10 minutes
It's Tool Time!10 minutes
Research Tools And Share With The Group10 minutes

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.