Data Warehouse Developer-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL

Develop and Implement a Data Warehouse Solution Step by step

4.26 (1637 reviews)
Udemy
platform
English
language
Databases
category
Data Warehouse Developer-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL
26,793
students
8 hours
content
Jan 2024
last update
$79.99
regular price

What you will learn

Design a data warehouse

Implement a data warehouse

Create ETL Solution with SSIS

Troubleshoot and Debug SSIS package

Deploying SSIS Solution

Enforce Data Quality

Cleanse data

Exploring Data Sources

Extracting modified data

Loading and modifying data

Consuming data in Data Warehouse

Generate Reports using SSRS

Analyse data with SSAS

Interact with Data using T-SQL

Description

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


The Primary responsibilities of a data warehouse developer 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
••Download and attaching AdventureworksDW 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

The volume of data available is huge and increasing daily. Structured Query Language -SQL (pronounced as sequel) is the standard language used to communicate and interact with data stored in relational management database systems like Microsoft  SQL Server Oracle, PostgreSQL,MySQL etc.

Different database management systems have their own proprietary  version of the SQL language  but they all conform to using some commands in SQL the same way.   Microsoft SQL Server's version of SQL is known as Transact-SQL  (T-SQL).

You will learn the basics of the SQL language and Transact-SQL since  both use certain commands in the same way.


What You will learn includes:


  • Installing SQL Server

  • Install SSMS

  • Basic Database  Concepts

  • Creating Database

  • Creating Table

  • Creating Views

  • Creating stored procedures

  • Reading data from a database

  • Updating database records

  • Backing up database

  • Deleting Records

  • Truncating Table

  • Dropping Table

  • Dropping Database

  • Restore Database


Content

SQL Server Setup

Introduction
What is SQL Server
Please Read
Minimum SQL Server installation requirements
SQL Server Download
Install SQL Server
Install SSMS
Connecting SSMS to SQL Server
Please Read
Install adventureworksDW database

Visual Studio Setup

What is Visual Studio
Minimum Visual Studio Installation Requirements
Download and install Visual Studio
Install SQL Server Data Tools - SSDT
Install SSDT Designer Templates

Designing a Data Warehouse

What is data warehouse
Database vs Data Warehouse
Data Warehouse Vs Enterprise Data Warehouse
Hardware requirements for Data Warehouse
Enabling SQL Server Agent
Configure Database Settings for Data Warehouse
FTDW Sizing Tool
Logical Design of Data Warehouse
Physical Design of Data Warehouse: Part 1
Physical Design of Data Warehouse: Part 2
Designing Dimension Tables

Creating an ETL Solution with SSIS

What is ETL
What is SSIS
Introduction to ETL with SSIS
Creating a new SSIS Project
Exploring data source: Part 1
Exploring data source: Part 2
Introduction to control flow: Part 1
Introduction to control flow: Part 2
Implementing data flow: Part 1
Implementing data flow: Part 2
Debugging SSIS Package : Part 1
Debugging SSIS Package : Part 2
Logging SSIS Package Events
Handling errors in an SSIS Package

Implementing an Incremental ETL Process

Introduction to incremental ETL Process
Extracting modified data: Part 1
Extracting modified data: Part 2
Extracting modified data: Part 3
Extracting modified data: Part 4
Loading modified data: Part 1
Loading modified data: Part 2
Working with changing dimensions

Deploying and Configuring SSIS

Integration services catalogs
Deploying SSIS Solutions
Execute a package with SQL Server Agent
Configuring advanced SSIS Settings

Enforcing Data Quality in Data Warehouse

Installing Data Quality Services
Cleansing data with data quality services
Find duplicate data : Part 1
Find duplicate data : Part 2
Using data quality services in SSIS data flow

Consuming Data in a Data Warehouse

Introduction to Business Intelligence
Creating a new SSRS Project in VS 2019
Using SSRS in Data Warehouse: Part1
Using SSRS in Data Warehouse: Part2
Creating a new SSAS Project
Data Analysis with SSAS : Part 1
Data Analysis with SSAS : Part 2

Transact -SQL (T-SQL)

What is T-SQL
Basic Database Concepts
CRUD Operations
SQL Server Data Types
Creating a new database
Creating a new table
Inserting data into table
Reading data from table
Creating Views
Creating a stored procedure
Updating Data
Backing up database
Deleting Data
Truncating Table
Dropping Table
Dropping Database
Restoring database

Reviews

Dragana
September 13, 2023
Way too basic, good for the very beginners. I had an upcoming interview, few days to prepare and no idea what SSIS, SSRS and SSAS stand for. This course kind of help with that. Only, more explanation about the tech reasoning was missing, when doing all the installations.
Drake
August 11, 2023
Elements of the course need to be updated as links and other resources are out dated & have to be recovered in multiple ways in order to continue instruction. Due to the size of the files being downloaded uninstalls and reinstall are a headache when the student realizes the file versions don't align.
Carlos
July 12, 2023
It is a good introductory course, but rushes through some of the concepts, or lacks depth in some of them. Would recommend, but do not expect to become an expert data warehouse developer. You will need more courses to compliment what you've learned here.
Adrian
July 5, 2023
This course is amazing, is just what I was looking for. It is well structured and clear to follow about these concepts realtions with Microsoft SQL Server.
Jurgen
June 23, 2023
This is a course which introduces the student on key concepts and modules that a data warehouse developer would need to be familiar with. However, the course only touches into the respective subjects shallowly. There are no exercises or practical elements - only watch and click.
Patric
April 26, 2023
It's an okay course but more stuff could be covered even though this is a basic course. The support from the instructor is also not the best and quickest
Alex
April 26, 2023
Solid material! However: too much background noise + over-editing … otherwise, good crash course on SSIS and more. Thank you, Sir.
Julieth
March 14, 2023
EL idioma es en ingles, deberían de hacer uno en español o colocarle subtitulos porque siempre es dificil para los que no manejamos la segunda lengua
Tameem
March 3, 2023
This is a very basic course. There should be some basic things that can be described. For example, for incremental load you should also tell about the Lookup and merge join. You should also train regarding the containers in ETL. Further, multiple times you started the process be database connection in many video and I think this should not be done every time becasue it takes time to see this again. SSAS should be explained more rather to add SQL part in the course. SQL part that you have discussed is very basic that I believe is taught during degree.
Himanshu
February 14, 2023
I FEEL CONTENT IS REALLY GOOD BUT THE WAY ORDER OF LECTURE IS SOEMTIMES DOING SAME THING SHOWS ERROR. MORE FILES COULD HAVE BEEN PROVIDED FOR THAT. REST IS GOOD. aLSO ONE MORE ISSUE, THAT WHATEVER STEPS BEING TOLD, THEIR MEANING IS NOT TOLD WHAT IT DOES. SO WE HAVE TO GOOGLE WHAT THIS STEP MEANS. OR SAY THAT PERSON HAS TO KNOW THE ETL PROCESS BEFORE HAND
Debra
January 30, 2023
The course was a good match since I have worked as a SQL Server DBA for many years, but not specifically with data warehouses.
Joseph
December 1, 2022
My experience in this course was great, i knew what was sql was about. i learned how to install the said software
Sipho
November 22, 2022
So far I am gaining the better understangind of a datawarehouse as compared to a production databases.
Eduard
November 21, 2022
This is a good introductory course to the topic. The Only regret I have is that it is on the short side for the SSAS/SSRS/T-SQL topics where more depth certainly is possible.
Mustafa
September 11, 2022
Thank you for this course. I believe students as myself learn by doing. If you could add some hands on practice sections the learning experience would be much better.

Coupons

DateDiscountStatus
3/23/2021100% OFF
expired
8/17/202387% OFF
expired
9/13/202387% OFF
expired
2/26/202488% OFF
expired

Charts

Price

Data Warehouse Developer-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL - Price chart

Rating

Data Warehouse Developer-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL - Ratings chart

Enrollment distribution

Data Warehouse Developer-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL - Distribution chart

Related Topics

3901412
udemy ID
3/9/2021
course created date
3/23/2021
course indexed date
Bot
course submited by