Fundamentals of Data Warehousing (Coursera)

Offered by LearnQuest,
Fundamentals of Data Warehousing (Coursera)

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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

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.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Relational Database Support for Data Warehouses (Coursera) Coursera
University of Colorado System

Relational Database Support for Data Warehouses (Coursera)

Relational Database Support for Data Warehouses is the third course in the Data Warehousing for Business Intelligence specialization. In this course, you'll use analytical elements of SQL for answering business intelligence questions. You'll learn features of relational database management systems for managing summary data commonly used in business intelligence reporting. Because of the importance and difficulty of managing implementations of data warehouses, we'll also delve into storage architectures, scalable parallel processing, data governance, and big data impacts. In the assignments in this course, you can use either Oracle or PostgreSQL.

Aug 31st 2026
5-12 Weeks
Fundamentals of Big Data (Coursera) Coursera
LearnQuest

Fundamentals of Big Data (Coursera)

Welcome to Fundamentals of Big Data, the fourth 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 fourth 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 big data.

Aug 31st 2026
3 Weeks
Foundations for Big Data Analysis with SQL (Coursera) Coursera
Cloudera

Foundations for Big Data Analysis with SQL (Coursera)

In this course, you'll get a big-picture view of using SQL for big data, starting with an overview of data, database systems, and the common querying language (SQL). Then you'll learn the characteristics of big data and SQL tools for working on big data platforms. You'll also install an exercise environment (virtual machine) to be used through the specialization courses, and you'll have an opportunity to do some initial exploration of databases and tables in that environment.

Aug 31st 2026
5-12 Weeks
Snowflake - SnowPro Core Certification Preparation (Coursera) Coursera
Board Infinity

Snowflake - SnowPro Core Certification Preparation (Coursera)

"Snowflake - SnowPro Core Certification Preparation" is a comprehensive course meticulously crafted to guide learners through the essentials of Snowflake, preparing them for the SnowPro Core Certification. Spanning three modules, the course begins with the fundamentals of Snowflake, exploring its architecture, data loading, and modeling. The second module delves into operational and management aspects, including account management, performance optimization, and security.

Sep 14th 2026
3 Weeks
Data Warehouse Concepts, Design, and Data Integration (Coursera) Coursera
University of Colorado System

Data Warehouse Concepts, Design, and Data Integration (Coursera)

This is the second course in the Data Warehousing for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will learn exciting concepts and skills for designing data warehouses and creating data integration workflows. These are fundamental skills for data warehouse developers and administrators. You will have hands-on experience for data warehouse design and use open source products for manipulating pivot tables and creating data integration workflows.

Aug 31st 2026
5-12 Weeks
Build a Data Warehouse Using BigQuery (Coursera) Coursera
Starweaver

Build a Data Warehouse Using BigQuery (Coursera)

Unlock the power of Google BigQuery as you embark on a journey to become proficient in data warehouse building and advanced querying. In this comprehensive course, you'll learn to harness the capabilities of BigQuery, from setting up and accessing the platform to creating data warehouses using both the user interface and Python. Through hands-on lessons and practical applications, you'll develop the fundamental skills needed to manage, query, and optimize your data in this powerful cloud-based platform.

Aug 31st 2026
1 Week
Business intelligence and data warehousing (Coursera) Coursera
Universidad Nacional Autónoma de México

Business intelligence and data warehousing (Coursera)

Welcome to the specialization course Business Intelligence and Data Warehousing. This course will be completed on six weeks, it will be supported with videos and various documents that will allow you to learn in a very simple way how to identify, design and develop analytical information systems, such as Business Intelligence with a descriptive analysis on data warehouses. You will be able to understand the problem of integration and predictive analysis of high volume of unstructured data (big data) with data mining and the Hadoop framework.

Aug 24th 2026
5-12 Weeks
Business Intelligence and Visual Analytics (Coursera) Coursera
University of California, Irvine

Business Intelligence and Visual Analytics (Coursera)

Building on “Data Warehousing and Business Intelligence,” this course focuses on data visualization and visual analytics. Starting with a thorough coverage of what data visualization is and what type of visualization is good for a given purpose, the course quickly dives into development of practical skills and knowledge about visual analytics by way of using one of the most popular visual analytics tools: SAS Viya, a cloud-based analytics platform. An overview of cloud architecture, automation, and machine learning is also provided.

Aug 24th 2026
4 Weeks
Data Warehousing with Microsoft Azure Synapse Analytics (Coursera) Coursera
Microsoft

Data Warehousing with Microsoft Azure Synapse Analytics (Coursera)

In this course, you will explore the tools and techniques that can be used to work with Modern Data Warehouses productively and securely within Azure Synapse Analytics. You will learn how Azure Synapse Analytics enables you to build Data Warehouses using modern architecture patterns and how the common schema is implemented in a data warehouse. You'll learn the best practices you need to adopt to load data into a data warehouse and the techniques that you can use to optimize query performance within Azure Synapse Analytics.

Jan 13th 2025
5-12 Weeks
Advanced Data Modeling (Coursera) Coursera
Meta

Advanced Data Modeling (Coursera)

Develop a working knowledge and familiarity with advanced database concepts such as usage, modeling, automation, storage, optimization and administration. To take this course, you must have completed the previous Database courses. You must also be eager to continue your journey with coding. The Professional Certificates create opportunities so that anyone regardless of education, background or experience can learn high-quality skills to land a high-growth career—no degree or experience required to get started.

Aug 24th 2026
4 Weeks