Expired

Introduction to Data Warehouse and SSIS for Beginners

Deal Score+1
FREE $9.99 Go To Course
Deal Score+1
FREE $9.99 Go To Course

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 .

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

What you’ll 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

Requirements

  • You should be able to use a PC at beginner level.
  • You should have some basic knowledge of SQL
  • You should some basic knowledge of Databases Systems.

Who this course is for:

  • Beginner DBA
  • Beginner Data Analyst
  • Beginners to Data Warehouse
  • Beginners to SSIS
FREE $9.99 Go To Course
×

Report Post