- Published 1/22/2018
- 1st Edition
About the Book
Prepare for Microsoft Exam 70-761 and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level.
Focus on the expertise measured by these objectives:
- Filter, sort, join, aggregate, and modify data
- Use subqueries, table expressions, grouping sets, and pivoting
- Query temporal and non-relational data, and output XML or JSON
- Create views, user-defined functions, and stored procedures
- Implement error handling, transactions, data types, and nulls
This Microsoft Exam Ref:
- Organizes its coverage by exam objectives
- Features strategic, what-if scenarios to challenge you
- Assumes you have experience working with SQL Server as a database administrator, system engineer, or developer
- Includes downloadable sample database and code for SQL Server 2016 SP1 (or later) and Azure SQL Database
About the Practice Test
This Microsoft Official Practice Test is powered by MeasureUp
This test contains 153 questions and covers the following objectives:
- Manage data with Transact-SQL - 58 questions
- Query data with advanced Transact-SQL components - 47 questions
- Program databases by using Transact-SQL - 48 questions
Why Choose the Microsoft Official Practice Test powered by MeasureUp?
Their quality content and innovative technology have earned the prestigious credential of Microsoft Certified Practice Test Provider.
•Online performance-based simulations give hands on work environment experience
•Questions are similar to exam questions so you test your knowledge of exam objectives
•Detailed explanations for both correct and distractor answers reinforce the material
•Study Mode covers all objectives ensuring topics are covered
•Certification Mode (timed) prepares students for exam taking conditions
•Instant, drill-down score reports tell you exactly the areas to focus on.
How to obtain the Practice Test
The Official Microsoft Practice Test offered with this book is fulfilled by MeasureUp.com. With your order, you will receive a product key on your Account Page. Registering the product key at MeasureUp.com will give you access to a downloadable practice test which does not expire as well as 30-day access to the online version.
Before accessing your practice test, you will be required to create an account at MeasureUp.com if you don’t already have one.
The downloadable practice test is licensed by MeasureUp for a single user and can be downloaded on up to three different devices. Downloading practice tests to virtual machines is prohibited.
Table of Contents
Table of Contents
CHAPTER 1 Manage data with Transact-SQL
CHAPTER 2 Query data with advanced Transact-SQL components
CHAPTER 3 Program databases by using Transact-SQL