Free Udemy Courses and Zero Broken link.
The only website where expired courses are deleted.

Data Warehouse for Absolute Beginners

Share :

Publisher : Eshant Garg

Course Language : English

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 comfortable in English, please do not take course, captions are not good enough to understand 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 is Data Warehouse, Why we need it and how it is different from traditional transactional database.

  • We will learn 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 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 start 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