Introduction to Data Warehouse and SSIS for Beginners

Introduction to Data Warehouse and SSIS for Beginners, available at $49.99, has an average rating of 3.9, with 60 lectures, based on 43 reviews, and has 1905 subscribers.

You will learn about Design a Data Warehouse Solution Desig Dimension Tables Create ETL Solution Explore Data source Implement control flow Implement data flow Debug SSIS Packages Handle errors Log SSIS Package Events Extract and modify data Load data Configure SSIS Deploy SSIS Execute package with Server Agent Enforce data quality Cleanse data Remove duplicates Consume data in the data warehouse This course is ideal for individuals who are Beginner DBA or Beginner Data Analyst or Beginners to Data Warehouse or Beginners to SSIS It is particularly useful for Beginner DBA or Beginner Data Analyst or Beginners to Data Warehouse or Beginners to SSIS.

Enroll now: Introduction to Data Warehouse and SSIS for Beginners

Summary

Title: Introduction to Data Warehouse and SSIS for Beginners

Price: $49.99

Average Rating: 3.9

Number of Lectures: 60

Number of Published Lectures: 60

Number of Curriculum Items: 60

Number of Published Curriculum Objects: 60

Original Price: $119.99

Quality Status: approved

Status: Live

What You Will Learn

Design a Data Warehouse Solution

Desig Dimension Tables

Create ETL Solution

Explore Data source

Implement control flow

Implement data flow

Debug SSIS Packages

Handle errors

Log SSIS Package Events

Extract and modify data

Load data

Configure SSIS

Deploy SSIS

Execute package with Server Agent

Enforce data quality

Cleanse data

Remove duplicates

Consume data in the data warehouse

Who Should Attend

Beginner DBA

Beginner Data Analyst

Beginners to Data Warehouse

Beginners to SSIS

Target Audiences

Beginner DBA

Beginner Data Analyst

Beginners to Data Warehouse

Beginners to SSIS

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 .

Students will learn how to :

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

After completing this course you will be? able to :

Understand the components of a data warehousing solution

Implement a logical and physical design to create a data warehouse

Implement a physical design for a data warehouse

Understand SSIS for implementing data flows

Create dynamic packages using parameters and variables

Implement Data Quality Services and Master Data Services

Implement custom components for extending SSIS

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

Instructors

247 Learning
An investment in knowledge pays the best interest

Rating Distribution

1 stars: 2 votes

2 stars: 4 votes

3 stars: 15 votes

4 stars: 11 votes

5 stars: 11 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!