UDEMY [100% OFF] 2020 Data Warehouse for Absolute Beginners 1

UDEMY [100% OFF] 2020 Data Warehouse for Absolute Beginners

UDEMY [100% OFF]. Enroll for free – Data Warehouse for Absolute Beginners
Data Warehouse for Absolute Beginners
Data Warehouse for Absolute Beginners

What you’ll learn

  • 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 with Azure Synapse SQL Data Warehouse course. This module is NOT GOOD for you if: You are already experienced in this technology You are looking for an intermediate or advance concepts You are looking for practical examples 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 lecture 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 comfortable in 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 is Data Warehouse, Why we need 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 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

Who this course is for:

  • Database Developer College Students
  • Data Analyst or similar profiles
  • Anyone interested to learn Basic Data Warehousing concept

Leave a Reply

Your email address will not be published. Required fields are marked *