MENUMENU

Implementing a Data Warehouse with Microsoft SQL Server 2012

Overview

This course describes how to implement and design a data warehouse platform. Students will learn how to create a data warehouse with Microsoft SQL Server, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. It covers the new features in SQL and also the important capabilities across the SQL Server data platform. Get knowledge on process behind implementing script tasks in Microsoft SQL Server Integration Services (SSIS) and manage the SSIS package execution task.

It also provides information on automating an ETL solution using SQL Server Integration Services. This course will help current and aspiring data professionals to prepare for exam 70-463, known as Implementing a Data Warehouse with SQL Server 2012.

Course Prerequisites

  • 10774A: Writing T-SQL Queries for Microsoft SQL Server 2012.

Course Content / Exam(s)

Schedule for Implementing a Data Warehouse with Microsoft SQL Server 2012 Training & Certification Courses

Course# Course Name Exam# Duration (days)
20740B Implementing a Data Warehouse with Microsoft SQL Server 2012 Training & Certification Courses 70-740 5

Implementing a Data Warehouse with Microsoft SQL Server 2012 Benefits

After Successful completion this course, you will be able to:-

  • Design and implement a data warehouse
  • Extract and transform data and load data
  • Design and implement dimensions
  • Implement and automate ETL solution
  • Developing SSIS packages for data extraction, transformation, and loading
  • Integrity by using Master Data Services
  • Data Quality Services
  • Debug and secure packages

Enquire Now





captcha

  • Chart With Experts
    Microsoft #1 Training Partner
    Expert Trainers
    Official Training

Enquire Now





captcha

  • 989
    Students Certified
    • Signup for Newsletter