Description
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 warehouseUnderstanding Star and Snowflakes techniques for schema designsIntroduction to big data conceptsImplementing ETL processDeveloping ETL process using SSIS and SSDTPhysical data warehouse design using SQL viewsDesigning a data warehouseImplementing 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 warehouseImplement Data warehouseDevelop ETL process. Implement ETL process using SSIS packages. Thank you and a warm welcome to the course:-)
