Free Udemy Courses Udemy Free Courses

Data Warehouse basics for absolute beginners in 30 mins

Data Warehouse basics for absolute beginners  in 30 mins
Data Warehouse basics for absolute beginners in 30 mins

Data Warehouse basics for absolute beginners in 30 mins

Data Warehouse basic concepts like architecture, dimensional modeling, fact vs dimension table, star vs snowflake schema

What you’ll lWarehouse basicasics for absolute beginners in 30 mins

  • Data Warehouse Basic concepts
  • Dimensional modeling
  • Facts and Dimensional tables
  • Schema and Snowflake schema

Requirements

  • Basic Database Understanding

Description

Important Note:

Please note that this is NOT a full course but a single module of the full-length course, and intended to cover very basic fundamental concepts for absolute beginners so that they can speed up the Azure Synapse SQL Data Warehouse course.

This module is NOT GOOD for you if:

  • You are already experienced in this technology
  • You are looking an intermediatadvancedvance concepts
  • You are looking for practical examplea s or demo

This module is GOOD for you if:

  • You want to understand the basic fundamental concepts of this technology.

This is a free module to help others. If you are not in the intended audience, I request you to please feel free to unenroll.

Where I can find a full-length course?

Please look at the bonus lecatre in the end.

What will students learn in this course?

  • Microsoft SQL Data Warehouse (Crash course to speed up with Cloud warehousing)

Level

  • Beginners

Intended Audience

  • Anyone who wants to start learning Data warehousing

Language

  • English
  • If you are not comfortwithle with English, please do not take the course, captions are not good enough to understand the course.

Target Students

  • Database and BI developers
  • Database Administrators
  • Data Analyst or similar profiles

Prerequisites

  • Basic T-SQL and Database concepts

Course In Detail

Data Warehouse Crash Course

  • In this module, you will learn, what iwarehouses housese, Why we ne,ed it  and ,how it is different from the traditional transactional database.
  • We will learn the concept of dimensional modeling which is a database design method optimized for data warehouse solutions.
  • Then I will explain what we mean when we say facts and their corresponding fact tables. What are the dimensions and their corresponding dimension tables?
  • how are these special kinds of tables joined together to form a star schema or snowflake schema?
  • This section will establish the foundation before you syourrt my course on Azure Synapse Analytics or formally known as Azure SQL Data Warehouse.

[Tags]

Microsoft SQL Server, Azure SQL Server, Azure SQL Data Warehouse, Data Factory, Data Lake, Azure Storage, Azure Synapse Analytics Service, PolyBase, Azure monitoring, Azure Security, Data Warehouse, SSIS

Who this course is for:

  • Database Developer
  • College Students
  • Data Analyst or similar profiles
  • Anyone interested to lthe earn Basic Data Warehousing concept
Get Course Now



Categories



Categories






Categories