Introduction to Data Warehouse and SSIS for Beginners

Course Curriculum

Chapter 1: Environment Setup

Lecture 1: Introduction

Lecture 2: What is SQL

Lecture 3: What is SQL Server

Lecture 4: Download and Install SQL SQL Server Enterprise

Lecture 5: Download and Load Sample Database

Lecture 6: Enable SQL Server Agent

Lecture 7: Download and Install SQL Server Express

Lecture 8: Download and Load Sample Database

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

Lecture 10: Testing Database

Lecture 11: Adjusting Database Settings

Lecture 12: Visual Studio installation requirements

Lecture 13: Download and Install Visual Studio – Part 1

Lecture 14: Download and Install Visual Studio – Part 2

Lecture 15: DW Hardware requirements

Lecture 16: FTDW Sizing Tool

Chapter 2: Introduction to Data Warehouse

Lecture 1: What is Data Warehouse

Lecture 2: What is ETL

Lecture 3: DW Vs EDW

Lecture 4: Database vs Data Warehouse

Lecture 5: Designing a Data Warehouse – Logical design

Lecture 6: Designing a Data Warehouse – Physical design

Lecture 7: Designing a Data Warehouse – Physical design part 2

Lecture 8: Designing Dimension Tables

Lecture 9: What is T-SQL

Chapter 3: Introduction to SSIS and Creating ETL Solution

Lecture 1: What is SSIS

Lecture 2: Introduction to ETL using SSIS

Lecture 3: Exploring the source data – part 1

Lecture 4: Exploring the 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

Lecture 9: Debugging SSIS package – part 1

Lecture 10: Debugging SSIS package – part 2

Lecture 11: Logging SSIS package events

Lecture 12: Handling errors in an SSIS package

Lecture 13: Introduction to Incremental ETL

Lecture 14: Extracting modified data part 1

Lecture 15: Extracting modified data part 2

Lecture 16: Extracting modified data part 3

Lecture 17: Extracting modified data part 4

Lecture 18: Loading modified data part 1

Lecture 19: Loading modified data part 2

Lecture 20: Using other slowly changing dimensions

Chapter 4: How to Deploy and Configure SSIS

Lecture 1: Introduction to Integration Services Catalogs

Lecture 2: Deploying SSIS Solutions

Lecture 3: Executing SSIS Package with SQL Server Agent

Lecture 4: Configuring advanced SSIS Settings

Chapter 5: Implementing and Enforcing Data Quality

Lecture 1: Installing Data Quality Services

Lecture 2: Cleansing Data

Lecture 3: Dealing with Duplicates

Lecture 4: Dealing with Duplicates – Part 2

Lecture 5: Checking quality of SSIS data flow

Chapter 6: How to consume Data in a Data Warehouse

Lecture 1: Business Intelligence

Lecture 2: Reporting Services

Lecture 3: Reporting Services -Part 2

Lecture 4: Data analysis -Part 1

Lecture 5: Data analysis -Part 2

Lecture 6: Thank You