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)
Anyone who wants to start learning Data warehousing
If you are not comfortable in English, please do not take course, captions are not good enough to understand course.
Database and BI developers
Data Analyst or similar profiles
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.
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