Back to Catalog

Data Warehouse Fundamentals

Learn on

Coursera logo
BeginnerCourse

This course introduces you to designing, implementing and populating a data warehouse and analyzing its data using SQL & Business Intelligence (BI) tools. This course also covers data repositories including data marts, data lakes, data reservoirs, and Cognos Analytics for visualization.

Language

  • English

Topic

  • Database

Skills You Will Learn

  • Cubes, Data Warehousing, Data Lakes, Rollups, Data Marts

Offered By

  • IBMSkillsNetwork

Estimated Effort

  • 15 Hours

Platform

  • Coursera

Last Update

  • May 30, 2025
About this Course
In this course, you will learn how to design, deploy, load, manage, and query data warehouses and data marts. You will begin by understanding different analytics repositories including data marts, data warehouses, data lakes, data lakehouses and their functions and uses. They are designed to enable rapid business decision-making through accurate and flexible reporting and data analysis. 
 
A data warehouse is one of the most fundamental business intelligence tools in use today, and one that successful Data Engineers must understand. Additionally, you will learn to design, model, and implement data warehouses and explore data warehousing architectures such as Star and Snowflake schemas. Finally, you will learn how to populate data warehouses using Extract, Transform, and Load (ETL) and Extract, Load, Transform (ELT) processes, verify data, query data, and use Cubes, Rollups, and materialized views/tables.  

The hands-on labs in this course will enable you to apply what you learn and gain a practical knowledge of data warehousing. You will work with repositories such as PostgreSQL and IBM Db2.

Course Syllabus

  • Module 1: Data Warehouses, Data Marts, and Data Lakes
  • Module 2: Designing, Modeling, and Implementing Data Warehouses
  • Module 3: Final Assignment and Final Quiz
  • Module 4 (Optional): IBM Db2

What you'll learn

  • Discuss the fundamentals of data warehouses, data marts, and data lakes by analyzing their features and advantages.
  • Examine organizations' decision-making processes to select specific data warehouse systems and vendors.    
  • Design and populate a data warehouse, and model and query data using Cubes, Rollups, and materialized views.
  • Design and load data into a data warehouse, write aggregation queries, create materialized query tables, and create an analytics dashboard.

Prerequisites

To succeed in this course, it is recommended that you should have a fundamental knowledge of Relational Database Management Systems (RDBMS) and a working knowledge of Structured Query Language (SQL).

Instructors

IBM Skills Network

IBM Skills Network Team

At IBM Skills Network, we know how crucial it is for businesses, professionals, and students to build hands-on, job-ready skills quickly to stay competitive. Our courses are designed by experts who work at the forefront of technological innovation. With years of experience in fields like AI, software development, cybersecurity, data science, business management, and more, our instructors bring real-world insights and practical, hands-on learning to every module. Whether you're upskilling yourself or your team, we will equip you with the practical experience and future focused technical and business knowledge you need to succeed in today’s ever-evolving world.

Read more