Microsoft Course 10774 Querying 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 all things SQL with Microsoft SQL Server. The Microsoft T-SQL extensions are fundamental and necessary for individuals administering a Microsoft SQL Server database, individuals writing softwa

re that will connect with a Microsoft SQL Server Database, and individuals writing reports using Microsoft Tools, including SQL Server Reporting Services, SQL Server Analysis services, SQL Server Report Builder, Excel, Access, and third-party software that uses Microsoft SQL Server to store data.

This course is the flagship Official Microsoft class dealing with both SQL Queries and Microsoft’s Transact SQL implementation.

It is a good bet that with the importance of Transact SQL to all things Microsoft, that Microsoft put substantial resources into optimizing this training.

If your interests are reporting in Excel, Access, Crystal Reports and third party tools, and not from the console in Microsoft SQL Server, you may wish to consider DeVore’s two-day ANSI SQL course, SQL – Basics of Writing SQL Queries and Stored Procedures – Level 1

View Microsoft Course 10774 Course Outline


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.

Design and Development

This course was designed and developed by SolidQ. SolidQ is a global provider of consulting, mentoring and training services for Microsoft Data Management, Business Intelligence and Collaboration platforms.

Chris Randall – Author

Chris Randall is Director of Training, USA for SolidQ. He has worked with SQL Server since 1996, as a trainer, consultant and speaker. Chris has contributed content to courses on T-SQL, SSIS and BI Architecture, has taught thousands of students in classes and at conferences worldwide, including SQL PASS, SQL Saturday and several conferences for Microsoft Certified Trainers. Chris has recently consulted with a large global nonprofit enterprise on integrating with the Microsoft SharePoint and BI stack, and has guided the adoption of SQL Server Analysis Services and Reporting Services into the products of an independent software vendor. He holds the MCT and MCITP certifications for the SQL Server 2008 portfolio.

Grega Jerkic – Author

Grega Jerkic is an independent consultant, mentor and trainer working for SolidQ. For last 10 years, he has been developing, architecting and managing different projects focusing on data warehousing, MDM, data integration, analytical / planning solutions and predictive analytics mostly with Microsoft technology. He invented and was lead architect for a predefined business intelligence solution on top of ERP Microsoft Dynamics NAV – BI4Dynamics. The solution is now used worldwide by more than 150+ clients and got two awards by Microsoft for best business intelligence solution for CEE region.

Grega also manages the leading business intelligence consulting company in Slovenia called IN516HT and is a regular speaker at different SQL and business intelligence conferences.

Itzik Ben-Gan – Subject Matter Expert

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including T-SQL Fundamentals, Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions, and others. He has written many articles for SQL Server Pro as well as articles and whitepapers for MSDN. Itzik’s speaking activities include major community events around the world such as TechEd and SQL PASS. Itzik is the author of SolidQ’s Advanced T-SQL Querying, Programming and Tuning course along with being a primary resource within the company for their T-SQL related activities.

Certification Exams

This course maps to the skills and knowledge measured by Microsoft Exam 70-461, Querying Microsoft SQL Server 2012and 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: