Data Warehouse For Beginners

Data Warehouse For Beginners, available at $39.99, has an average rating of 3.95, with 39 lectures, based on 37 reviews, and has 344 subscribers.

You will learn about 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 ideal for individuals who are Anyone who has a basic knowledge of databases or Anyone interested in learning something new It is particularly useful for Anyone who has a basic knowledge of databases or Anyone interested in learning something new.

Enroll now: Data Warehouse For Beginners

Summary

Title: Data Warehouse For Beginners

Price: $39.99

Average Rating: 3.95

Number of Lectures: 39

Number of Published Lectures: 39

Number of Curriculum Items: 39

Number of Published Curriculum Objects: 39

Original Price: $84.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Anyone who has a basic knowledge of databases
Anyone interested in learning something new

Target Audiences

Anyone who has a basic knowledge of databases
Anyone interested in learning something new

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 🙂

Course Curriculum

Chapter 1: Introduction and Setting up Virtual Environment

Lecture 1: Introduction

Lecture 2: PLEASE READ

Lecture 3: MSDN Virtual Lab Requirements

Lecture 4: MSDN Virtual Labs

Lecture 5: MSDN Virtual Lab: Pros and Cons

Lecture 6: Differences between Database and Data Warehouse

Lecture 7: Testing Sample Data

Chapter 2: Microsoft SQL Server

Lecture 1: What is SQL Server

Lecture 2: Hardware and software requirements

Lecture 3: SQL Server Editions

Lecture 4: Download SQL Server

Lecture 5: Install SQL Server

Lecture 6: Install SSMS

Lecture 7: Connecting to SQL Server with SSMS

Lecture 8: Install Adventureworks 2016 Database

Lecture 9: Install AdventureworksDW 2016 Database

Lecture 10: Enable SQL Server Agent

Lecture 11: Enable Database Server for data warehouse

Chapter 3: Microsoft Visual Studio Setup

Lecture 1: What is Visual Studio

Lecture 2: Minimum installation requirements for visual studio

Lecture 3: Installing Visual Studio

Lecture 4: Installing SQL Server Data Tools- SSDT

Lecture 5: Installing Designer Templates

Chapter 4: Designing A Data Warehouse

Lecture 1: What is Data Warehouse

Lecture 2: Designing Data warehouse

Lecture 3: Logical Data warehouse design

Lecture 4: Techniques for designing dimension tables

Lecture 5: Physical Data warehouse design using views

Chapter 5: Implementing A Data Warehouse

Lecture 1: Introduction to Implementing DataWarehouse

Lecture 2: SSIS and SSDT

Lecture 3: What is ETL

Lecture 4: Developing ETL Process using SSIS and SSDT

Chapter 6: Big Data Concepts

Lecture 1: What is big data

Lecture 2: What is High Volume Data

Lecture 3: What is High Variety data

Lecture 4: What is high Velocity Data

Lecture 5: What is a Cluster

Lecture 6: What is a Node

Lecture 7: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 2 votes
2 stars: 5 votes
3 stars: 12 votes
4 stars: 7 votes
5 stars: 11 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu