Home

All courses

Data Warehousing for beginners.

Development

Data Warehouse

Database Design & Development

Data Warehousing for beginners.

Learn to implement a Data Warehouse Solution from scratch

4.0

(149)

14205 enrolled on this course

Last updated 11/2021

None

₹ 799.0

₹ 2299.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

This course is a beginners course that will show you how to implement enterprise data warehouse solution using Microsoft SQL Server ,Microsoft SQL Server Integration Services SSIS and Microsoft SQL Server Data Tools -SSDT.

You will learn how to implement ETL ( Extract,Transform, Load) process using SQL Server Integration services .

This course will show you how to design fact and dimension tables which are the two main types of table used in data warehouse . You will learn the star and starflake techniques used to design dimension tables.

What You will learn includes:

••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

By the end of this course you would have acquired enough skills to implement a data warehouse solution.
Who this course is for:
Beginner Database Administrator
Beginner Data warehouse administrator
Beginner Data Analyst
Beginner Data Scientist
Network Adminstrators

What you'll learn

Deploy and Configure SSIS packages.

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 data cleansing by using Microsoft Data Quality Services.

Implement Master Data Services to enforce data integrity

Extract and load modified data

Consume data in a data warehouse

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Data Warehousing Concepts

1.1-Introduction

1.2-What is Data Warehouse

1.3-What is ETL

1.4-EDW Vs DW

1.5-Database vs Data Warehouse

2-Lab Setup

2.1-Download and Install SQL Server Enterprise Edition

2.2-Attaching AdventureworksDW2014 Database

2.3-Testing AdventureworksDW2014

2.4-Enabling SQL Server Agent

2.5-Download and Install SQL Server Data Tools -SSDT

2.6-Adjusting Database settings for Data Warehouse implementation

2.7-Download and Install Visual studio

2.8-Completing Visual studio installation

3-Designing and Implementing a Data Warehouse

3.1-Planning Data Warehouse Hardware

3.2-FTDW Sizing Tool

3.3-Designing Dimension Tables

3.4-Logical Design of a Data Warehouse

3.5-Physical design of a Data Warehouse

3.6-Physical design of a Data Warehouse -Continued

4-Creating an ETL Solution with SSIS

4.1-Introduction to ETL with SSIS

4.2-Exploring data source - part 1

4.3-Exploring data source - part 2

4.4-Introduction to control flow - part 1

4.5-Introduction to control flow - part 2

4.6-Implementing data flow - part 1

4.7-Implementing data flow - part 2

5-Debugging and Troubleshooting SSIS Packages

5.1-Debugging SSIS Package - Part 1

5.2-Debugging SSIS Package - Part 2

5.3-Logging SSIS package events

5.4-Handling errors in an SSIS Package

6-Data Extraction and Loading Data

6.1-Introduction to incremental ETL

6.2-Extracting modified data - Part 1

6.3-Extracting modified data - Part 2

6.4-Extracting modified data - Part 3

6.5-Extracting modified data - Part 4

6.6-Loading modified data - Part 1

6.7-Loading modified data - Part 2

7-Configuring

Deploying and Executing SSIS Package

7.1-Introduction to Integration Services Catalogs;7.2-Deploying an SSIS Solution;7.3-Executing a package with SQL Server Agent;7.4-Configuring advanced SSIS settings

8-Enforcing Data Quality

8.1-Installing Data Quality Services;8.2-Cleansing Data with Data Quality Services;8.3-Using Data Quality Services to detect duplicates -Part 1;8.4-Using Data Quality Services to detect duplicates -Part 2;8.5-Using Data Quality services in an SSIS Data flow

9-Business Intelligence and Consuming Data in a Data Warehouse

9.1-Business Intelligence - Introduction;9.2-Using Reporting Services in a Data Warehouse - Part 1;9.3-Using Reporting Services in a Data Warehouse - Part 2;9.4-Using Analysis Services with a Data Warehouse -Part 1;9.5-Using Analysis Services with a Data Warehouse -Part 2;9.6-Thank You

Course Categories

Popular Courses

Data Warehousing for beginners.

Description

What you'll learn

Requirements

Course Content

You May Like