Data Warehouse DeveloperSQL ServerETLSSISSSASSSRSTSQL

Develop and Implement a Data Warehouse Solution Step by step
Data Warehouse DeveloperSQL ServerETLSSISSSASSSRSTSQL
File Size :
5.04 GB
Total length :
8h 5m

Category

Instructor

Bluelime Learning Solutions

Language

Last update

5/2023

Ratings

4.2/5

Data Warehouse DeveloperSQL ServerETLSSISSSASSSRSTSQL

What you’ll 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

Data Warehouse DeveloperSQL ServerETLSSISSSASSSRSTSQL

Requirements

A computer and internet access required
Some free software required. The course will guide you .

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 warehouseThe 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 ServerInstall SSMSBasic Database  ConceptsCreating DatabaseCreating TableCreating ViewsCreating stored proceduresReading data from a databaseUpdating database recordsBacking up databaseDeleting RecordsTruncating TableDropping TableDropping DatabaseRestore Database

Overview

Section 1: SQL Server Setup

Lecture 1 Introduction

Lecture 2 What is SQL Server

Lecture 3 Please Read

Lecture 4 Minimum SQL Server installation requirements

Lecture 5 SQL Server Download

Lecture 6 Install SQL Server

Lecture 7 Install SSMS

Lecture 8 Connecting SSMS to SQL Server

Lecture 9 Please Read

Lecture 10 Install adventureworksDW database

Section 2: Visual Studio Setup

Lecture 11 What is Visual Studio

Lecture 12 Minimum Visual Studio Installation Requirements

Lecture 13 Installing SQL Data Tools with Visual Studio

Lecture 14 Download and install Visual Studio

Lecture 15 Install SQL Server Data Tools – SSDT

Lecture 16 Install SSDT Designer Templates

Section 3: Designing a Data Warehouse

Lecture 17 What is data warehouse

Lecture 18 Database vs Data Warehouse

Lecture 19 Data Warehouse Vs Enterprise Data Warehouse

Lecture 20 Hardware requirements for Data Warehouse

Lecture 21 Enabling SQL Server Agent

Lecture 22 Configure Database Settings for Data Warehouse

Lecture 23 FTDW Sizing Tool

Lecture 24 Logical Design of Data Warehouse

Lecture 25 Physical Design of Data Warehouse: Part 1

Lecture 26 Physical Design of Data Warehouse: Part 2

Lecture 27 Designing Dimension Tables

Section 4: Creating an ETL Solution with SSIS

Lecture 28 What is ETL

Lecture 29 What is SSIS

Lecture 30 Introduction to ETL with SSIS

Lecture 31 Creating a new SSIS Project

Lecture 32 Exploring data source: Part 1

Lecture 33 Exploring data source: Part 2

Lecture 34 Introduction to control flow: Part 1

Lecture 35 Introduction to control flow: Part 2

Lecture 36 Implementing data flow: Part 1

Lecture 37 Implementing data flow: Part 2

Lecture 38 Debugging SSIS Package : Part 1

Lecture 39 Debugging SSIS Package : Part 2

Lecture 40 Logging SSIS Package Events

Lecture 41 Handling errors in an SSIS Package

Section 5: Implementing an Incremental ETL Process

Lecture 42 Introduction to incremental ETL Process

Lecture 43 Extracting modified data: Part 1

Lecture 44 Extracting modified data: Part 2

Lecture 45 Extracting modified data: Part 3

Lecture 46 Extracting modified data: Part 4

Lecture 47 Loading modified data: Part 1

Lecture 48 Loading modified data: Part 2

Lecture 49 Working with changing dimensions

Section 6: Deploying and Configuring SSIS

Lecture 50 Integration services catalogs

Lecture 51 Deploying SSIS Solutions

Lecture 52 Execute a package with SQL Server Agent

Lecture 53 Configuring advanced SSIS Settings

Section 7: Enforcing Data Quality in Data Warehouse

Lecture 54 Installing Data Quality Services

Lecture 55 Cleansing data with data quality services

Lecture 56 Find duplicate data : Part 1

Lecture 57 Find duplicate data : Part 2

Lecture 58 Using data quality services in SSIS data flow

Section 8: Consuming Data in a Data Warehouse

Lecture 59 Introduction to Business Intelligence

Lecture 60 Creating a new SSRS Project in VS 2019

Lecture 61 Using SSRS in Data Warehouse: Part1

Lecture 62 Using SSRS in Data Warehouse: Part2

Lecture 63 Creating a new SSAS Project

Lecture 64 Data Analysis with SSAS : Part 1

Lecture 65 Data Analysis with SSAS : Part 2

Section 9: Transact -SQL (T-SQL)

Lecture 66 What is T-SQL

Lecture 67 Basic Database Concepts

Lecture 68 CRUD Operations

Lecture 69 SQL Server Data Types

Lecture 70 Creating a new database

Lecture 71 Creating a new table

Lecture 72 Inserting data into table

Lecture 73 Reading data from table

Lecture 74 Creating Views

Lecture 75 Creating a stored procedure

Lecture 76 Updating Data

Lecture 77 Backing up database

Lecture 78 Deleting Data

Lecture 79 Truncating Table

Lecture 80 Dropping Table

Lecture 81 Dropping Database

Lecture 82 Restoring database

Lecture 83 Thank You

Beginner Data Analyst,Beginner Data Warehouse Engineers,Beginner Data Scientist,Beginner Data Engineers

Course Information:

Udemy | English | 8h 5m | 5.04 GB
Created by: Bluelime Learning Solutions

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top