Implementing a Data Warehouse with Microsoft SQL Server (Udemy.com)

Design and implement a data warehouse

( 41 Reviews )

Created by: Bluelime Learning Solutions

Produced in 2021

What you will learn

Describe how to consume data from the data warehouse.
Create ETL Solution
Design a data warehouse
Troubleshoot and Debug SSIS package
Sort out duplicates
Extract Data
Load Data
Deploy SSIS
Enforce Data Quality
Cleanse data
Analysis data
Generate reports

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 68 / 100

Course 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 professionalswho 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 2014Download and attaching Adventureworks2014 databaseDownload and installing SSDTDownload and installing Visual studioDescribe 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 warehousesChoose between star and snowflake design schemasExplore source dataImplement data flowDebug an SSIS packageExtract and load modified dataEnforce data qualityConsume data in a data warehouse

Who this course is for:
Database professionalsData AnalystNovice data warehouse administrator

Time: 7.5h

Instructor Details

Bluelime Learning Solutions

3.4 Rating
41 Reviews

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.

Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW)

Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW) (2021)
3.7 (260 Reviews)

- Provider: Udemy
- Time: 17h

$11.99

17 Beginner C# Walkthrough Projects step by step

17 Beginner C# Walkthrough Projects step by step (2021)
3.9 (189 Reviews)

- Provider: Udemy
- Time: 17h

$11.99

Coding for beginners (2021)
4.0 (117 Reviews)

- Provider: Udemy
- Time: 22h

$11.99

PostgreSQL Database Administration (DBA) for Beginners

PostgreSQL Database Administration (DBA) for Beginners (2018)
3.2 (93 Reviews)

- Provider: Udemy
- Time: 11.5h

$11.99

Python and Django Full-Stack Web Development for beginners

Python and Django Full-Stack Web Development for beginners (2021)
4.3 (58 Reviews)

- Provider: Udemy
- Time: 34.5h

$11.99

Learn Java by building 17 projects step by step

Learn Java by building 17 projects step by step (2018)
3.6 (52 Reviews)

- Provider: Udemy
- Time: 10.5h

$11.99

All courses by Bluelime Learning Solutions

More sql courses

SQL Server - zapytania. Querying. Exam 70-761

SQL Server - zapytania. Querying. Exam 70-761 (2021)
4.8 (99 Reviews)

- Provider: Udemy
- Time: 5h

$11.99

Oracle Database 12c SQL Certified Associate 1Z0-071

Oracle Database 12c SQL Certified Associate 1Z0-071 (2021)
4.7 (336 Reviews)

- Provider: Udemy
- Time: 20h

$11.99

Introduction to Structured Query Language (SQL)

Introduction to Structured Query Language (SQL) (2017)
4.7 (313 Reviews)

- Provider: Coursera
- Time: 3h

Free

Learn C# With Windows Forms and SQL Server

Learn C# With Windows Forms and SQL Server (2021)
4.7 (269 Reviews)

- Provider: Udemy
- Time: 12.5h

$11.99

Microsoft Access SQL: SQL for Non-Programmers

Microsoft Access SQL: SQL for Non-Programmers (2021)
4.7 (240 Reviews)

- Provider: Udemy
- Time: 3.5h

$11.99

The Ultimate Oracle SQL Course (2021)
4.7 (237 Reviews)

- Provider: Udemy
- Time: 11.5h

$11.99

All sql courses

Reviews

3.4

41 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Hussain M Ibrahim on 10/16/2020

it is very informative

By RobertoM on 10/11/2020

In linea con aspettative, esauriente e dettagliato nel navigare le interfacce.

By Konga Suman on 9/6/2020

yeah its helping me to get knowledge on sql server different editions so far

By Alexander Azhogin on 8/8/2020

Good match, relevant course.

By Georgi Marinov on 7/4/2020

My overall feeling after this course is that it was just patched up from a much older one. There were some things that were not actual and others that were not quite well explained.
The idea of a paid course in my opinion is that the student should get relatively actual impression of the matter, relatively easy access to troubleshooting and a meaningful thorough and complete understanding of the overall meaning and function of the different modules and the combination of them. Otherwise he/she could just gather the knowledge from youtube. I lost lots of time searching for solution of issues I faced during some of the modules.
I did not get this experience in a satisfactory way. Despite, I am thankful for the opportunity.
All the best
Georgi

By Titus Warui Njoroge on 6/4/2020

So far so good

By Kim Beck on 4/22/2020

Tries to cover too many topics in too short time. Does not actually teach you to implement a DWH.

By Katie Efird on 3/12/2020

It would be helpful if this tutorial would guide you through dimensional modeling and fact modeling. It only gives an overview of the existing tables in adventure works. I did not really get anything from this course other than learning more about star and snowflake schemas.

By Mark Kateeb on 2/27/2020