Microsoft SQL Server 2012: Implementing a Data Warehouse (70-463)

April 2013 with Garth Schulte

  • Intermediate
  • 22 videos
  • 12 hrs 39 mins
The exam associated with this skill has been retired. However, this skill still retains value as a training resource.

This SQL Server video training course with Garth Schulte covers Microsoft’s database management system including designing and implementing dimensions, troubleshooting data integration issues, and implementing master data services.

SQL Server business intelligence developers are rock stars in the eyes of an organization's decision makers. Managing and providing high-level data through a data warehouse helps businesses make accurate decisions that save time and money.

This course provides you with the skills you need to create and manage a data warehouse in SQL Server 2012. Learn how to design and implement a data warehouse, implement and automate an ETL solution using SQL Server Integration Services to load warehouse data, and utilize Master Data Services along with Data Quality Services to standardize, enrich, and evolve data over time.

Exam 70-463 is the final step toward attaining the Microsoft MCSA: SQL Server 2012 certification, which completes the pre-requisites toward both MCSE certifications: Data Platform and Business Intelligence. This course helps prepare you for the 70-463 exam and beyond with real-world examples and live demonstrations.

Note: The exam associated with this course was revised December 1, 2015. A large percentage of this course still maps to the current exam objectives and continues to provide value as a training resource. Furthermore, an instructional PDF has been added to the Supplemental Files for your use within the Virtual Lab.

Recommended Experience
  • Experience creating Business Intelligence solutions
  • Experience with data cleansing
  • Experience with Exact Transform Load and data warehouse implementation
Recommended Equipment
  • Microsoft SQL Server 2012
Related Certifications
  • MCSA: SQL Server 2012
  • MCSE: Data Platform
  • MCSE: Business Intelligence
  • MCSM: Data Platform
Related Job Functions
  • IT professionals
  • Database developers
  • Database analysts
  • ETL developers
  • Data warehouse developers
Garth Schulte has been a CBT Nuggets trainer since 2001 and holds a variety of Microsoft and Google certifications spanning system administration, development, databases, cloud, and big data.
Get started
Garth Schulte
Garth Schulte

Videos in this skill

Quizzes & Practice Exams

Reinforce core concepts and new skills with built-in quiz questions, and exams.

Virtual Labs

Explore new technology and apply your expertise in customized virtual labs.

Accountability Coaching

Define your goals and stick to a training plan with help from our coaches.

Learn this skill and so much more!

Get started

Gain instant access to our entire IT training library, free for your first week. Train anytime on your desktop, tablet, or mobile devices.

Not sure where to start?
Call 541-284-5522 or try our .

What is it like to train with us?

Our learners say it best.

Helps me learn the skills I need when I need them

Read Reviews
Get CBT Nuggets IT training news and resources

I have read and understood the privacy policy and am able to consent to it.

© 2023 CBT Nuggets. All rights reserved.Terms | Privacy Policy | Accessibility | Sitemap | 2850 Crescent Avenue, Eugene, OR 97408 | 541-284-5522