Exam Ref 70-761 Querying Data with Transact-SQL



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

Price$31.99 - $37.62
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. (3 books)



4 5 39

Similar Books


Exam Ref 70-774 Perform Cloud Data Science with Azure Machine Learning

Exam Ref 70-774 Perform Cloud Data Science with Azure Machine Learning

by Ginger Grant, Julio Granados, Guillermo Fernandez, Pau Sempere, Javier Torrenteras, Paco Gonzalez, Tamanaco Francisquez

Prepare for Microsoft Exam 70-774 - and help demonstrate your real-world mastery of performing key data science activities with Azure Machine Learning services. 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....

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

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-745 Implementing a Software-Defined DataCenter

Exam Ref 70-745 Implementing a Software-Defined DataCenter

by Jeff Graves, Joel Stidley

Prepare for Microsoft Exam 70-745 - and help demonstrate your real-world mastery of skills needed to build and manage software-defined infrastructure with Windows Server 2016 and System Center 2016 Virtual Machine Manager (SC VMM). Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical th...

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

Exam Ref 70-762 Developing SQL Databases

Exam Ref 70-762 Developing SQL Databases

by Louis Davidson, Stacia Varga

Prepare for Microsoft Exam 70-762, Developing SQL Databases - and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, Exam Ref focuses on t...

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

Exam Ref 70-768 Developing SQL Data Models

Exam Ref 70-768 Developing SQL Data Models

by Stacia Varga

Prepare for Microsoft Exam 70-768 - and help demonstrate your real-world mastery of Business Intelligence (BI) solutions development with SQL Server 2016 Analysis Services (SSAS), including modeling and queries. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-...

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

Exam Ref 70-767 Implementing a SQL Data Warehouse

Exam Ref 70-767 Implementing a SQL Data Warehouse

by Jose Chinchilla, Raj Uchhana

Prepare for Microsoft Exam 70-767 - and help demonstrate your real-world mastery of skills for managing data warehouses. This exam is intended for Extract, Transform, Load (ETL) data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing as well as ETL and data warehouse impleme...

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

Exam Ref 70-741 Networking with Windows Server 2016

Exam Ref 70-741 Networking with Windows Server 2016

by Andrew Warren

Microsoft Exam 70-741 is for IT Pros interested in enhancing their skills for the latest version of Windows Server. This exam validates skills and knowledge for configuring advanced tasks required to deploy, manage, and maintain a Windows Server 2016 infrastructure, such as fault tolerance, certificate services, and identity federation. P...

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

Exam Ref 70-742 Identity with Windows Server 2016

Exam Ref 70-742 Identity with Windows Server 2016

by Andrew Warren

Prepare for Microsoft Exam 70-742 - and help demonstrate your real-world mastery of Windows Server 2016 identity features and functionality. 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 experti...

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