Learn to design and implement data warehouse from scratch

This course is a beginners course that will show you how to implement enterprise data warehouse solution using Microsoft SQL Server ,Microsoft SQL Server Integration Services SSIS and Microsoft SQL Server Data Tools -SSDT.

You will learn how to implement ETL ( Extract,Transform, Load) process using SQL Server Integration services .

This course is unique as you will be using a fully functional and state of the art virtual lab in the cloud provided for free by microsoft. All you need to access the Microsoft virtual labs is an account on any microsoft product like hotmail and a modern web browser. There is nothing absolutely to install for this course.

This course will show you how to design fact and dimension tables which are the two main types of table used in data warehouse . You will learn the star and starflake techniques used to design dimension tables.

Topics you will learn includes:

Differences between a relational database and data warehouse
Understanding Star and Snowflakes techniques for schema designs
Introduction to big data concepts
Implementing ETL process
Developing ETL process using SSIS and SSDT
Physical data warehouse design using SQL views
Designing a data warehouse
Implementing a data warehouse
This course is completely video based and taught at a pace that makes it easy for you to follow along and understand.

After completing this course you will be able to :

Describe data warehouse .
Design a data warehouse
Implement Data warehouse
Develop ETL process.
Implement ETL process using SSIS packages.