Implementing a Data Warehouse with Microsoft SQL Server
3.8 (15 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.
963 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Implementing a Data Warehouse with Microsoft SQL Server to your Wishlist.

Add to Wishlist

Implementing a Data Warehouse with Microsoft SQL Server

Design and implement a data warehouse
3.8 (15 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.
963 students enrolled
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $125 Discount: 92% off
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Describe how to consume data from the data warehouse.
View Curriculum
Requirements
  • Experience of working with relational databases
  • Desire to learrn
Description


This course describes how to implement a data warehouse solution.
students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Target Audience:

=>This course is intended for database professionals
 who need to create and support a data warehousing solution. Primary responsibilities include:
••Implementing a data warehouse.
••Developing SSIS packages for data extraction, transformation, and loading.
••Enforcing data integrity by using Master Data Services.
••Cleansing data by using Data Quality Services.


Prerequisites :

Experience of working with relational databases, including:
Designing a normalized database.
Creating tables and relationships.
Querying with Transact-SQL.
Some exposure to basic programming constructs (such as looping and branching).
An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.


Students will learn how to :

••Deploy and Configure SSIS packages.
••Download and installing SQL Server 2014
••Download and attaching Adventureworks2014 database
••Download and installing SSDT
••Download and installing Visual studio
••Describe data warehouse concepts and architecture considerations.
••Select an appropriate hardware platform for a data warehouse.
••Design and implement a data warehouse.
••Implement Data Flow in an SSIS Package.
••Implement Control Flow in an SSIS Package.
••Debug and Troubleshoot SSIS packages.
••Implement an ETL solution that supports incremental data extraction.
••Implement an ETL solution that supports incremental data loading.
••Implement data cleansing by using Microsoft Data Quality Services.
••Implement Master Data Services to enforce data integrity.
••Extend SSIS with custom scripts and components.
••Databases vs. Data warehouses
••Choose between star and snowflake design schemas
••Explore source data
••Implement data flow
••Debug an SSIS package
••Extract and load modified data
••Enforce data quality
••Consume data in a data warehouse


Who is the target audience?
  • Database professionals
  • Data Analyst
  • Novice data warehouse administrator
Students Who Viewed This Course Also Viewed
Curriculum For This Course
60 Lectures
06:42:50
+
Setting up Your Test Environment
13 Lectures 01:10:38

Install SQL Server Enterprise - Evaluation
11:54

Download and install AdventureworksDW2014
05:33

Enable SQL Server Agent
02:33



Download and install AdventureworksDW2014
06:39

Download and Install SQL Server Data Tools -SSDT
06:03

Testing Adventure Works installation
01:46

Database settings for data warehouse implementation
06:38

Hardware and Software Requirements for visual studio
03:08

Download and install Visual Studio
07:47

Completing Visual Studio Installation
05:09
+
Introduction to Data Warehousing
4 Lectures 10:42
What is a data warehouse ?
03:06

What is ETL ?
02:27

DW vs EDW
01:54

Databases vs Data Warehouse
03:15
+
Data Warehouse Hardware
2 Lectures 14:38
Hardware considerations
10:42

FTDW Sizing Tool
03:56
+
Designing a Data Warehouse
4 Lectures 36:05
Logical Design for a data warehouse
04:14

Physical design for a data warehouse part 1
09:55

Physical design for a data warehouse part 2
11:42

Designing Dimension Tables
10:14
+
Big Data Concepts
4 Lectures 12:18
What is big Data
02:43

What is High Volume Dta
03:03

What is High Variety Data
03:22

What is High Velocity Data
03:10
+
Creating ETL solution with SSIS
7 Lectures 53:30
Introduction to ETL with SSIS
02:41

Exploring source data - Part 1
08:41

Exploring source data - Part 2
04:36

Introduction to Control Flow - Part 1
09:55

Introduction to Control Flow - Part 2
08:21

Implementing data flow - part 1
09:44

Implementing data flow - part 2
09:32
+
Debugging and Troubleshooting SSIS Packages
4 Lectures 32:31
Debugging SSIS package Part 1
07:20

Debugging SSIS package Part 2
06:53

Logging SSIS package events
10:18

Handling errors in an SSIS Package
08:00
+
Implementing an Incremental ETL Process
8 Lectures 53:37
Introduction to incremental ETL
05:36

Extracting modified data Part 1
04:53

Extracting modified data 2
07:47

Extracting modified data 3
05:28

Extracting modified data 4
07:19

Loading modified data Part 1
07:31

Loading modified data Part 2
07:25

Working with other slowly changing dimensions
07:38
+
Deploying and Configuring SSIS
4 Lectures 36:28
Integration Services Catalogs
08:19

Deploying SSIS Solutions
11:52

Executing a package with SQL Server agent
10:58

Configuring advanced SSIS settings
05:19
+
Enforcing Data Quality
5 Lectures 48:16
Installing Data Quality Services
06:57

Cleansing Data with Data Quality Services
11:27

Using Data Quality Services to find duplicate data -Part 1
11:11

Using Data Quality Services to find duplicate data -Part 2
09:07

Using Data Quality Services in an SSIS Data flow
09:34
1 More Section
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,568 Reviews
35,161 Students
85 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.