Chicago area career training

MCSA: 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2014 (20463D)

Summary

* Pricing and Logistics are subject to change without notice.
 

This 5-day instructor led course is part of the MCSA SQL Server certification track. It provides students with the knowledge and skills to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

MicroTrain offers Microsoft Certified instructors, in-classroom lessons and labs, supplemental training and study materials, and the MicroTrain Exam Pass Guarantee.

Who benefits from this course?

  • Anyone pursuing MCSA SQL Server certification
  • Anyone interested in learning SQL Server 2012 or SQL Server 2014.
  • Any data professionals who need to create and support a data warehousing solution

Prerequisites

About This Course

Upon successful completion of this course, students will be able to:

  • 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 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
  • Deploy and Configure SSIS packages
  • Describe how BI solutions can consume data from the data warehouse

Prerequisites

This course requires that you meet the following prerequisites:
  • At least 2 years’ experience of working with relational databases, including:
  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Exam Details

Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

The Logistics of Your Exam

  1. The cost of the exam is an additional $165
  2. Locate a Pearson Vue testing center near you

  3. Create a Microsoft Profile and register for your exam

  4. Review Microsoft Exam Policies prior to taking your exam

Exam Information

Exam Code 70-463
Number of Questions 40-60
Passing Score 700 (on a scale of 1-1000)
Types of Questions
  • Case Studies

  • Multiple choice

  • Multiple response

  • Active screen

  • Best answer

  • Build List

  • Drag and drop

  • Hot area

  • Repeated answer choices

  • Short answer

  • Mark review

  • Review screen

Length of Test 120 minutes
Exam Results Provided within minutes of completing exam

Course Schedule

Chicago
200 W Adams Suite 410 Chicago, IL 60606
08/24/2019 - 09/28/2019 09:00 am - 05:00 pm
S M T W T F S
Lombard
720 E Butterfield Rd Suite 100 Lombard, IL 60148
06/03/2019 - 06/07/2019 09:00 am - 05:00 pm
S M T W T F S
06/29/2019 - 07/27/2019 09:00 am - 05:00 pm
S M T W T F S
09/09/2019 - 09/13/2019 09:00 am - 05:00 pm
S M T W T F S

Exam Pass Guarantee

At Microtrain we are committed to your success!
Let us show you the return you get from great tech training. We will personally guarantee that if you take our class and follow our program you will be successfully certified!

Learn More