HOT

Data Warehouse Express guide

IT & Software

Rating3.7
Free Enroll Now

Data Warehouse Express guide, available at Free, has an average rating of 3.65, with 24 lectures, based on 61 reviews, and has 1425 subscribers.

You will learn about Data Warehouse Star Schema Slowly Changing Dimension Data Modeling Dimension table Fact Table This course is ideal for individuals who are SQL Developers and admins looking to enter Data Warehouse world It is particularly useful for SQL Developers and admins looking to enter Data Warehouse world.

Enroll now: Data Warehouse Express guide

Summary

Title: Data Warehouse Express guide

Price: Free

Average Rating: 3.65

Number of Lectures: 24

Number of Published Lectures: 24

Number of Curriculum Items: 24

Number of Published Curriculum Objects: 24

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

  • SQL Developers and admins looking to enter Data Warehouse world

Target Audiences

  • SQL Developers and admins looking to enter Data Warehouse world

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome

Chapter 2: Data Warehouse Concepts

Lecture 1: What is a Data Warehouse

Lecture 2: Data Warehouse Modeling

Lecture 3: What is a Dimension

Lecture 4: What is a Fact

Lecture 5: Star Schema

Chapter 3: Dimensions

Lecture 1: Introduction

Lecture 2: Denormalization

Lecture 3: Primary Key

Lecture 4: Null Data

Lecture 5: Slowly Changing Dimension

Chapter 4: Special Dimensions

Lecture 1: Introduction

Lecture 2: Date Dimension

Lecture 3: Role Playing Dimension

Lecture 4: Junk Dimension

Lecture 5: Snowflake Dimension

Chapter 5: Facts

Lecture 1: Introduction

Lecture 2: Fact Types

Lecture 3: Primary Key

Lecture 4: Measurement Types

Lecture 5: Source Changes

Chapter 6: Bonus

Lecture 1: Introduction

Lecture 2: Data Warehouse Database

Chapter 7: Greatfulness

Lecture 1: Thank you

Instructors

Rating Distribution

  • 1 stars: 5 votes
  • 2 stars: 6 votes
  • 3 stars: 19 votes
  • 4 stars: 17 votes
  • 5 stars: 14 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Digital Marketing Foundation Course

Digital Marketing Courses

Create music with Artificial Intelligence in this new market