Data Warehouse For Beginners

Course details

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.

Thank you and a warm welcome to the course :-)