Home | Testing | Directions | Contact

440-232-3846

DeVore Technologies

Microsoft Partner
SQL Server

Live, In Person, Instructor in the classroom

A small number of additional students can attend using distance learning tools

Microsoft Course 20461 Querying Microsoft® SQL Server® - 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 software 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.

Most recently, Microsoft has moved away from making each course version specific, and has revised the SQL content to apply to all reasonably recent versions of SQL Server, so you would not have the dilemma of your company is using 2008 now and plans to upgrade to 2012 in six months, which class should you take.

That said, IF your company is using an older version such as 2008 and does not have plans to upgrade, DeVore offers the Microsoft Official Courses for each version specifically for your group.

DeVore does accept Microsoft SATV vouchers as payment for IT Professional Technical Training.

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

Querying Microsoft® SQL Server®

Next Microsoft Course 20461 Class in Cleveland

 

February 8-12

View DeVore's LIVE - Instructor Led Microsoft Course 20461 class schedule

Acknowledgements

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.

Geoff Allix – Lead 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. As a Microsoft Certified Trainer, Geoff has delivered training courses on SQL Server since version 6.5. Geoff is a Microsoft Certified IT Professional for SQL Server and has 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 database solutions.

Certification Exams

This course maps to the skills and knowledge measured by Microsoft Exam 70-461, Querying Microsoft SQL Server 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 – www.pearsonvue.com

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

https://www.microsoft.com/learning/en-us/exam-70-461.aspx