Development Online Course by Udemy, On Sale Here
Learn to design and implement data warehouse from scratch
An excellent training about Database Design & Development
Data Warehouse For Beginners
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 warehouseThis 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: -)
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.