[Free] Data Warehouse Express Guide

Basic concepts for beginners – Free Course

What you’ll learn

  • Data Warehouse
  • Star Schema
  • Slowly Changing Dimension
  • Data Modeling
  • Dimension table
  • Fact Table

Requirements

  • Database concepts
  • Entity relationship model

Description

In this course you can learn the fundamental concepts to start your way to the world of data warehousing.

It is not necessary to be an expert in SQL or Database but it is recommended to have a previous basic knowledge to understand the terminology more quickly.

Topics integrated into the course include:

What is the concept of a Data Warehouse

What is the method by which a Data Warehouse is modeled

What are the types of tables that make up a Data Warehouse

What is the data model for the best performance of a Data Warehouse

How does denormalization work in a Data Warehouse?

What rules are followed to build the tables that make up a Data Warehouse

How changes or modifications of the transactional system of origin are handled

What are the default rows in dimensions for?

How to handle primary keys

The special dimensions that a Data Warehouse can have

What are the facts or events

How many types of fact table can we have in a Data Warehouse?

What kind of numerical data is stored in a fact table

What questions should a dimension answer?

This is an express course that will allow you to have a general idea of ​​the necessary concepts to start the development of your own Data Warehouse.

Author(s): Melissa Castilla
Coupon Scorpion
Coupon Scorpion

The Coupon Scorpion team has over ten years of experience finding free and 100%-off Udemy Coupons. We add over 200 coupons daily and verify them constantly to ensure that we only offer fully working coupon codes. We are experts in finding new offers as soon as they become available. They're usually only offered for a limited usage period, so you must act quickly.

Coupon Scorpion
Logo