3.6  32 reviews on Udemy

Data Warehouse For Beginners

Learn to design and implement data warehouse from scratch
Course from Udemy
 313 students enrolled
 en
Design a data warehouse
Implement a data warehouse
Develop ETL process
Implement ETL process
Know how to use SSIS
Know how to use SSDT
Understand Big Data concepts
Explore MSDN Virtual Labs

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 :-)

Data Warehouse For Beginners
$ 94.99
per course
Also check at

FAQs About "Data Warehouse For Beginners"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

SOCIAL NETWORK