Microsoft Course 10777 Implementing a Data Warehouse with Microsoft® SQL Server® 2012 – in Cleveland, Ohio

Located in Beachwood off I-271, DeVore serves the Northeast Ohio Area, including Akron – Canton, Warren – Youngstown and Erie, Pa.

This course is the foundation for creating Data Warehouses utilizing Microsoft SQL Server, most commonly for reporting purposes, using the SSIS tool (SQL Server Integration Services) to load data into the warehouse, the DQS tool (Data

Quality Services, and the MDS tool (Master Data Services) to achieve data quality and consistency to optimize the accuracy of reports derived from the data.

This course provides comprehensive coverage of SQL Server Integration Services and the ETL Process (Extract, Transform, Load), and is commonly used as a starting point for formulating a custom course specifically on using SSIS.

This course will also provide an overview of the Microsoft Business Intelligence tools, SQL Server Analysis Services, SQL Server Reporting Services, and the newer “self-service BI” tools such as PowerPivot.

While more hands-on training time translates directly to better results, if the individuals are using only SQL Server 2008 or earlier in their project, with no plans to upgrade, 3-day classes are also available, Microsoft Course 6234, Implementing and Maintaining Microsoft® SQL Server® 2008 Analysis Services, and Microsoft Course 6235, Implementing and Maintaining Microsoft® SQL Server® 2008 Integration Services.

You will frequently see DeVore’s perspective — Databases are NOT a good choice for Trial-and-Error learning. The cost of training is inconsequential compared to the potential cost of errors.

This course assumes some hands-on experience with data and Microsoft SQL Server.

View DeVore’s LIVE – Instructor Led Class Schedule

View the Topic Outline for Microsoft Course 10777


Microsoft Learning would like to acknowledge and thank the following for their contribution towards developing this title. Their effort at various stages in the development has ensured that you have a good classroom experience.

Graeme Malcolm – Lead Content Developer

Graeme Malcolm is a Microsoft SQL Server subject matter expert and professional content developer at Content Master—a division of CM Group Ltd. As a Microsoft Certified Trainer, Graeme has delivered training courses on SQL Server since version 4.2; as an author, Graeme has written numerous books, articles, and training courses on SQL Server; and as a consultant, Graeme has designed and implemented business solutions based on SQL Server for customers all over the world.

Geoff Allix – Content Developer

Geoff Allix is a Microsoft SQL Server subject matter expert and professional content developer at Content Master—a division of CM Group Ltd. Geoff is a Microsoft Certified IT Professional for SQL Server with extensive experience in designing and implementing database and BI solutions on SQL Server technologies, and has provided consultancy services to organizations seeking to implement and optimize data warehousing and OLAP solutions.

Martin Ellis – Content Developer

Martin Ellis is a Microsoft SQL Server subject matter expert and professional content developer at Content Master—a division of CM Group Ltd. Martin is a Microsoft Certified Technical Specialist on SQL Server and an MCSE. He has been working with SQL Server since version 7.0, as a DBA, consultant and Microsoft Certified Trainer, and has developed a wide range of technical collateral for Microsoft Corp. and other technology enterprises.

Chris Testa-O’Neill – Technical Reviewer

Chris Testa-O’Neil is a Senior Consultant at Coeo (, a leading provider of SQL Server Managed Support and Consulting in the UK and Europe. He is also a Microsoft Certified Trainer, Microsoft Most Valuable Professional for SQL Server, and lead author of Microsoft E-Learning MCTS courses for SQL Server 2008. Chris has spoken at a range of SQL Server events in the UK, Europe, Australia and the United States. He is also one of the organizers of SQLBits, SQLServerFAQ and a UK Regional Mentor for SQLPASS. You can contact Chris at or through his blog at

This course maps to the skills and knowledge measured by Microsoft Exam 70-463, Implementing a Data Warehouse with Microsoft SQL Server 2012, and in conjunction with on-the-job experience, can help prepare you for the exam.

As a convenience to our customers, DeVore offers Information Technology Certification Testing. Microsoft tests are currently scheduled through both Pearson VUE and Prometric.

DeVore also offers the purchase of testing vouchers with a Purchase Order, credit card, company check or electronic payment as a convenience to our customers. Call the DeVore office with any questions.

To schedule this exam, visit Pearson VUE –

To read in detail what the exam covers, visit the Microsoft Learning site: