Data Warehousing for beginners.

Course Curriculum

Chapter 1: Data Warehousing Concepts

Lecture 1: Introduction

Lecture 2: What is Data Warehouse

Lecture 3: What is ETL

Lecture 4: EDW Vs DW

Lecture 5: Database vs Data Warehouse

Chapter 2: Lab Setup

Lecture 1: Download and Install SQL Server Enterprise Edition

Lecture 2: Attaching AdventureworksDW2014 Database

Lecture 3: Testing AdventureworksDW2014

Lecture 4: Enabling SQL Server Agent

Lecture 5: Download and Install SQL Server Data Tools -SSDT

Lecture 6: Adjusting Database settings for Data Warehouse implementation

Lecture 7: Download and Install Visual studio

Lecture 8: Completing Visual studio installation

Chapter 3: Designing and Implementing a Data Warehouse

Lecture 1: Planning Data Warehouse Hardware

Lecture 2: FTDW Sizing Tool

Lecture 3: Designing Dimension Tables

Lecture 4: Logical Design of a Data Warehouse

Lecture 5: Physical design of a Data Warehouse

Lecture 6: Physical design of a Data Warehouse -Continued

Chapter 4: Creating an ETL Solution with SSIS

Lecture 1: Introduction to ETL with SSIS

Lecture 2: Exploring data source – part 1

Lecture 3: Exploring data source – part 2

Lecture 4: Introduction to control flow – part 1

Lecture 5: Introduction to control flow – part 2

Lecture 6: Implementing data flow – part 1

Lecture 7: Implementing data flow – part 2

Chapter 5: 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 6: Data Extraction and Loading Data

Lecture 1: Introduction to incremental ETL

Lecture 2: Extracting modified data – Part 1

Lecture 3: Extracting modified data – Part 2

Lecture 4: Extracting modified data – Part 3

Lecture 5: Extracting modified data – Part 4

Lecture 6: Loading modified data – Part 1

Lecture 7: Loading modified data – Part 2

Chapter 7: Configuring | Deploying and Executing SSIS Package

Lecture 1: Introduction to Integration Services Catalogs

Lecture 2: Deploying an SSIS Solution

Lecture 3: Executing a package with SQL Server Agent

Lecture 4: Configuring advanced SSIS settings

Chapter 8: Enforcing Data Quality

Lecture 1: Installing Data Quality Services

Lecture 2: Cleansing Data with Data Quality Services

Lecture 3: Using Data Quality Services to detect duplicates -Part 1

Lecture 4: Using Data Quality Services to detect duplicates -Part 2

Lecture 5: Using Data Quality services in an SSIS Data flow

Chapter 9: Business Intelligence and Consuming Data in a Data Warehouse

Lecture 1: Business Intelligence – Introduction

Lecture 2: Using Reporting Services in a Data Warehouse – Part 1

Lecture 3: Using Reporting Services in a Data Warehouse – Part 2

Lecture 4: Using Analysis Services with a Data Warehouse -Part 1

Lecture 5: Using Analysis Services with a Data Warehouse -Part 2

Lecture 6: Thank You