SQL/ETL/Data Warehouse Developer -(MS-SQL, SSIS, SSRS, SSAS)

Course Curriculum

Chapter 1: Microsoft SQL Server Setup

Lecture 1: Introduction

Lecture 2: What is a data warehouse

Lecture 3: Databases vs Data warehouse

Lecture 4: What is SQL Server

Lecture 5: SQL Server Editions

Lecture 6: SQL Server Installation Requirements

Lecture 7: Download SQL Server

Lecture 8: Install SQL Server

Lecture 9: Install SSMS

Lecture 10: Connect SSMS to SQL Server

Lecture 11: Install sample database

Lecture 12: Install sample data warehouse database

Lecture 13: Enable SQL Server Agent

Lecture 14: Enable Database settings for data warehouse

Chapter 2: Install SQL Server Data Tools (SSDT)

Lecture 1: What is Visual Studio

Lecture 2: Installing Visual Studio

Lecture 3: Installing SQL Server Data Tools (SSDT)

Lecture 4: Install SSDT BI Templates

Chapter 3: Designing a Data Warehouse

Lecture 1: Hardware Requirements for data warehouse

Lecture 2: Using FTDW Sizing Tool

Lecture 3: Logical design

Lecture 4: Physical design : Part 1

Lecture 5: Physical design : Part 2

Lecture 6: Designing Dimension Tables

Chapter 4: Implementing ETL & SSIS

Lecture 1: What is ETL

Lecture 2: What is SSIS

Lecture 3: introduction to ETL & SSIS

Lecture 4: Creating a new SSIS Project

Lecture 5: Exploring data source: : Part 1

Lecture 6: Exploring data source: : Part 2

Lecture 7: Introduction to control flow: Part 1

Lecture 8: Introduction to control flow: Part 2

Lecture 9: Implementing data flow : Part 1

Lecture 10: Implementing data flow : Part 2

Chapter 5: Debugging & Troubleshooting SSIS Package

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 SSIS Package

Chapter 6: Implementing Incremental ETL

Lecture 1: Introduction

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

Lecture 8: Working with slowly changing dimensions

Chapter 7: Deploying & Configuring SSIS

Lecture 1: Integration services catalogs

Lecture 2: Deploying SSIS Solutions

Lecture 3: Executing a package with SQL Server

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: Finding duplicate data with data quality services : Part 1

Lecture 4: Finding duplicate data with data quality services : Part 2

Lecture 5: Using data quality services in SSIS Data Flow

Chapter 9: Creating Reports with SQL Server Reporting Services

Lecture 1: What is SSRS

Lecture 2: Create a report server project

Lecture 3: Create a report definition file

Lecture 4: Configure a data source for the report

Lecture 5: Define a dataset for report

Lecture 6: Add a table to report

Lecture 7: Format report

Lecture 8: Grouping data in report

Lecture 9: Adding totals to the report

Lecture 10: Previewing report

Lecture 11: Exporting report

Chapter 10: Create & Analyze Model with SQL Server Analysis Services – SSAS

Lecture 1: What is SSAS

Lecture 2: Installing SSAS

Lecture 3: Connecting to SSAS

Lecture 4: Create a tabular model project

Lecture 5: Explore tabular model authoring

Lecture 6: Create a connection to data source

Lecture 7: Transform & import data

Lecture 8: Mark as data table

Lecture 9: Create table relationships

Lecture 10: Create calculated columns : Part 1

Lecture 11: Create calculated columns : Part 2

Lecture 12: Creating measures : Part 1

Lecture 13: Creating measures : Part 2

Lecture 14: Creating measures : Part 3

Lecture 15: Create Key Performance Indicators

Lecture 16: Create Perspectives

Lecture 17: Create Hierarchies : Part 1

Lecture 18: Create Hierarchies : Part 2

Lecture 19: What are partitions

Lecture 20: Creating Partitions

Lecture 21: Creating roles

Lecture 22: Analyze in Excel

Lecture 23: Deploy your model

Lecture 24: Analyze Model