Data Warehouse For Beginners
3.3 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
254 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Warehouse For Beginners to your Wishlist.

Add to Wishlist

Data Warehouse For Beginners

Learn to design and implement data warehouse from scratch
3.3 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
254 students enrolled
Last updated 7/2016
English
Current price: $10 Original price: $95 Discount: 89% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Basic understanding of database concepts
  • Basic understanding of T-SQL
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 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 :-)

Who is the target audience?
  • Anyone who has a basic knowledge of databases
  • Anyone interested in learning something new
Students Who Viewed This Course Also Viewed
Curriculum For This Course
21 Lectures
01:20:02
+
Introduction and Setting up Virtual Environment
6 Lectures 19:09




Differences between Database and Data Warehouse
03:14

Testing Sample Data
04:10
+
Designing A Data Warehouse
5 Lectures 24:11
What is Data Warehouse
02:08

Designing Data warehouse
00:55

Logical Data warehouse design
06:15

Techniques for designing dimension tables
06:50

Physical Data warehouse design using views
08:03
+
Implementing A Data Warehouse
4 Lectures 21:59
Introduction to Implementing DataWarehouse
05:28

SSIS and SSDT
04:29

What is ETL
02:57

Developing ETL Process using SSIS and SSDT
09:05
+
Big Data Concepts
6 Lectures 14:43
What is big data
02:43

What is High Volume Data
03:03

What is High Variety data
03:22

What is high Velocity Data
03:10

What is a Cluster
00:56

What is a Node
01:29
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,746 Reviews
38,688 Students
91 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.