Implementing a Data Warehouse with Microsoft SQL Server

Implementing a Data Warehouse with Microsoft SQL Server, available at $79.99, has an average rating of 3.9, with 80 lectures, based on 342 reviews, and has 2470 subscribers.

You will learn about 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 This course is ideal for individuals who are Database professionals or Data Analyst or Novice data warehouse administrator It is particularly useful for Database professionals or Data Analyst or Novice data warehouse administrator.

Enroll now: Implementing a Data Warehouse with Microsoft SQL Server

Summary

Title: Implementing a Data Warehouse with Microsoft SQL Server

Price: $79.99

Average Rating: 3.9

Number of Lectures: 80

Number of Published Lectures: 71

Number of Curriculum Items: 80

Number of Published Curriculum Objects: 71

Original Price: $109.99

Quality Status: approved

Status: Live

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

Who Should Attend

Database professionals
Data Analyst
Novice data warehouse administrator

Target Audiences

Database professionals
Data Analyst
Novice data warehouse administrator

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

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Introduction

Lecture 2: Please Read

Chapter 2: SQL Server 2019 Setup

Lecture 1: What is SQL Server

Lecture 2: SQL Server 2019 Hardware | Software Installation Requirements

Lecture 3: SQL Server Editions

Lecture 4: Download SQL Server 2019 developer edition

Lecture 5: Installing SQL Server Developer Edition 2019

Lecture 6: Installing SQL Server Management Studio

Lecture 7: Connecting to SQL Server

Lecture 8: Installing adventureworks 2016 database

Lecture 9: Installing AdventureworksDW 2016 database

Lecture 10: Testing Adventure Works installation

Lecture 11: Enable SQL Server Agent

Lecture 12: Database settings for data warehouse implementation

Chapter 3: Setup for visual studio 2019 | SSIS |SSRS|SSAS

Lecture 1: What is Visual Studio

Lecture 2: Minimum Installation Requirements for visual studio 2019

Lecture 3: Installing Visual Studio

Lecture 4: Installing SQL Server Data Tools (SSDT)

Lecture 5: Installing Designers for SSIS,SSAS,SSRS

Chapter 4: Introduction to Data Warehousing

Lecture 1: What is a data warehouse ?

Lecture 2: What is ETL ?

Lecture 3: DW vs EDW

Lecture 4: Databases vs Data Warehouse

Chapter 5: Data Warehouse Hardware

Lecture 1: Hardware considerations

Lecture 2: FTDW Sizing Tool

Chapter 6: Designing a Data Warehouse

Lecture 1: Logical Design for a data warehouse

Lecture 2: Physical design for a data warehouse part 1

Lecture 3: Physical design for a data warehouse part 2

Lecture 4: Designing Dimension Tables

Chapter 7: Big Data Concepts

Lecture 1: What is big Data

Lecture 2: What is High Volume Dta

Lecture 3: What is High Variety Data

Lecture 4: What is High Velocity Data

Chapter 8: Creating ETL solution with SSIS

Lecture 1: Creating a new SSIS Project with Visual studio 2019

Lecture 2: Introduction to ETL with SSIS

Lecture 3: Exploring source data – Part 1

Lecture 4: Exploring source data – Part 2

Lecture 5: Introduction to Control Flow – Part 1

Lecture 6: Introduction to Control Flow – Part 2

Lecture 7: Implementing data flow – part 1

Lecture 8: Implementing data flow – part 2

Chapter 9: Debugging and Troubleshooting SSIS Packages

Lecture 1: Debugging SSIS package Part 1

Lecture 2: Debugging SSIS package Part 2

Lecture 3: Logging SSIS package events

Lecture 4: Handling errors in an SSIS Package

Chapter 10: Implementing an Incremental ETL Process

Lecture 1: Introduction to incremental ETL

Lecture 2: Extracting modified data Part 1

Lecture 3: Extracting modified data 2

Lecture 4: Extracting modified data 3

Lecture 5: Extracting modified data 4

Lecture 6: Loading modified data Part 1

Lecture 7: Loading modified data Part 2

Lecture 8: Working with other slowly changing dimensions

Chapter 11: Deploying and Configuring SSIS

Lecture 1: Integration Services Catalogs

Lecture 2: Deploying SSIS Solutions

Lecture 3: Executing a package with SQL Server agent

Lecture 4: Configuring advanced SSIS settings

Chapter 12: Enforcing Data Quality

Lecture 1: Installing Data Quality Services for SQL Server2019

Lecture 2: Installing Data Quality Services

Lecture 3: Cleansing Data with Data Quality Services

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

Lecture 5: Using Data Quality Services to find duplicate data -Part 2

Lecture 6: Using Data Quality Services in an SSIS Data flow

Chapter 13: Consuming Data in a Data Warehouse

Lecture 1: Introduction to Business Intelligence

Lecture 2: How to create SSRS Report with visual studio 2019

Lecture 3: Using Reporting Services with Data Warehouse – Part 1

Lecture 4: Using Reporting Services with Data Warehouse – Part 2

Lecture 5: Creating a new SSAS Project with visual studio 2019

Lecture 6: Introduction to data analysis with SSAS – Part 1

Lecture 7: Introduction to data analysis with SSAS – Part 2

Lecture 8: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 16 votes
2 stars: 30 votes
3 stars: 83 votes
4 stars: 98 votes
5 stars: 116 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