Scroll to top button

Implementing a Data Warehouse with SQL Server 2012

ISBN : 9781616912277

Prepare for the Microsoft MCSA 70-463 certification exam with the Implementing a Data Warehouse with SQL Server 2012 course. The course focuses on the objectives of the MCSE 70-463 exam and provides the knowledge and skills required for the design and implementation of a data warehouse; extraction and transformation of data; loading data, configuration, and deployment SSIS solutions; and building data quality solutions.

The Implementing a Data Warehouse Microsoft SQL Server 2012 exam is part of the Microsft's MCSA/MCSE SQL Server 2012 certification. This certification is targeted at Extract-Transform-Load(ETL) and Data Warehouse Developers who can create Business Intelligence (BI) solutions. The MCSA 70-463 exam validates candidates' skills in software installation (IS, management tools), development box and server; and installation of specifics for remote package execution.

Glossary of terms
Pre Assessment Questions
Post Assessment Questions

Videos and How To

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Exam related FAQs
What are the prerequisites for this exam? There are no technical prerequisites for this certification.
What is the exam registration fee? USD 165
Where do I take the exam?


What is the format of the exam? The exam consists of liner, fact based, drag and drop, hot area, and multiple-choice questions.
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the exam's retake policy?

In the event that you fail your first attempt at passing the 70-463 examination, Microsoft's retake policy is:

  • If a candidate fails in their first attempt, he/she needs to wait for 24 hours to retake the exam.
  • If a candidate fails in second, third, and subsequent attempts, he/she needs to wait for 14 calendar days before rescheduling the exam.
  • If a candidate has passed an exam, he/she cannot take it again.
Where can I find more information about this exam? To know more about the 70-463, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • ETL developers
  • Data Warehouse Developers
  • Understanding Data Warehouses
  • Implementing Fact Tables
  • Implementing Dimensions
  • Summary
  • Chapter Essentials
  • Integration Issues
  • Installing SSIS
  • Configuring SSIS Security Settings
  • Deploying Packages
  • SSIS Auditing and Event Handling
  • Extracting, Transforming, and Loading Data
  • Summary
  • Lesson Essentials
  • Understanding Data Quality Concerns
  • Installing Data Quality Services
  • Using Master Data Services
  • Cleaning Data
  • Summary
  • Chapter Essentials
  • Certification Objectives Map

Customer Testimonials

Ahmed Oyelowo
I came across a couple of resources but one that struck me was uCertify. I went through their course on "Implementing a Data Warehouse with SQL Server". What did I find out? They have a pretest you can take before you commence the lessons. If you feel like jumping in straight to the lessons, you still can. And you can always come back for that same test. The content is excellently packed with everything one can think of. And they also provide links to other materials. Their explanations are so on point. They used simple English all through, no use of any ambiguous words. They also have a practice test to actually test your knowledge after the course and prepare you for the actual exams. You can obtain a certificate of completion. There are other Certifications as well. You should see for yourself on uCertify
Christian Udeochu
The uCertify Implementing a Data Warehouse Microsoft SQL Server 2012 course focuses on the objectives of the MCSE 70-463 certification exam provides competence across a spectrum of skills including implementation of the data warehouse, creating Business Intelligence (BI) solutions, and data cleansing. I highly recommend this course to everyone who is preparing for the Microsoft 70-463 exam.