Exam Ref 70-761 Querying Data with Transact-SQL



Bookstore > Books > Exam Ref 70-761 Querying Data with Transact-SQL

Price$34.25 - $35.04
Rating
AuthorItzik Ben-Gan
PublisherMicrosoft Press
Published2017
Pages352
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101509304339
ISBN-139781509304332
EBook Hardcover Paperback

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; Querying Data with Transact-SQL.

Exam 70-761 focuses on the skills and knowledge necessary to manage and query data and to program databases with Transact-SQL in SQL Server 2016.


  1. (4 books)


5 5 116

Similar Books


Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel

Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel

by Chris Sorensen

Prepare for Microsoft Exam 70-779 - and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. ...

Price:  $31.97  |  Publisher:  Microsoft Press  |  Release:  2018

Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI

Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI

by Daniil Maslyuk

Prepare for Microsoft Exam 70-778 - and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts 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 exp...

Price:  $31.30  |  Publisher:  Microsoft Press  |  Release:  2018

Exam Ref 70-533 Implementing Microsoft Azure Infrastructure Solutions, 2nd Edition

Exam Ref 70-533 Implementing Microsoft Azure Infrastructure Solutions, 2nd Edition

by Michael Washam, Rick Rainey, Dan Patrick, Steve Ross

Prepare for the newest versions of Microsoft Exam 70-533 - and help demonstrate your real-world mastery of implementing Microsoft Azure Infrastructure as a Service (IaaS). 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 ...

Price:  $31.61  |  Publisher:  Microsoft Press  |  Release:  2018

Exam Ref 70-483 Programming in C#, 2nd Edition

Exam Ref 70-483 Programming in C#, 2nd Edition

by Rob Miles

Prepare for the latest versions of Microsoft Exam 70-483 and help demonstrate your real-world mastery of modern C# programming. Designed for experienced C# developers 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 t...

Price:  $22.99  |  Publisher:  Microsoft Press  |  Release:  2018

Exam Ref 70-533 Implementing Microsoft Azure Infrastructure Solutions

Exam Ref 70-533 Implementing Microsoft Azure Infrastructure Solutions

by Michael Washam, Rick Rainey

Prepare for Microsoft Exam 70-533 - and help demonstrate your real-world mastery of Microsoft Azure infrastructure solution implementation. Designed for experienced IT pros ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the Microsoft Specialist level.Exam 70-533 fo...

Price:  $42.30  |  Publisher:  Microsoft Press  |  Release:  2015

Exam Ref 70-346 Managing Office 365 Identities and Requirements, 2nd Edition

Exam Ref 70-346 Managing Office 365 Identities and Requirements, 2nd Edition

by Orin Thomas

Prepare for Microsoft Exam 70-346, and demonstrate your real-world mastery of the skills needed to provision, manage, monitor, and troubleshoot Microsoft Office 365 identities and cloud services. Designed for experienced IT pros ready to advance their status, this Exam Ref focuses on the critical-thinking and decision-making acumen needed...

Price:  $28.78  |  Publisher:  Microsoft Press  |  Release:  2017

Exam Ref 70-744 Securing Windows Server 2016

Exam Ref 70-744 Securing Windows Server 2016

by Timothy L. Warner, Craig Zacker

Prepare for Microsoft Exam 70-744 - and help demonstrate your real-world mastery of securing Windows Server 2016 environments. 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 MCSE level.Focus on the expertise measured by...

Price:  $23.12  |  Publisher:  Microsoft Press  |  Release:  2016

Exam Ref 70-764 Administering a SQL Database Infrastructure

Exam Ref 70-764 Administering a SQL Database Infrastructure

by Victor Isakov

Prepare for Microsoft Exam 70-764 - and help demonstrate your real-world mastery of skills for database administration. This exam is intended for database administrators charged with installation, maintenance, and configuration tasks. Their responsibilities also include setting up database systems, making sure those systems operate effici...

Price:  $30.24  |  Publisher:  Microsoft Press  |  Release:  2017