FREIGHT DELAYS IN AND OUT: MORE INFO

Close Notification

Your cart does not contain any items

Exam Ref 70-761 Querying Data with Transact-SQL

Itzik Ben-Gan

$49.95

Paperback

We can order this in for you
How long will it take?

QTY:

Microsoft Press
31 March 2017
Database programming; SQL Server & MS SQL; Computer certification: Microsoft (eg MCSE)
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
By:   Itzik Ben-Gan
Imprint:   Microsoft Press
Country of Publication:   United States
Dimensions:   Height: 225mm,  Width: 190mm,  Spine: 20mm
Weight:   599g
ISBN:   9781509304332
ISBN 10:   1509304339
Pages:   352
Publication Date:   31 March 2017
Audience:   Professional and scholarly ,  Undergraduate
Format:   Paperback
Publisher's Status:   Active
CHAPTER 1 Manage data with Transact-SQL CHAPTER 2 Query data with advanced Transact-SQL components CHAPTER 3 Program databases by using Transact-SQL

Itzik Ben-Gan, mentor and cofounder of SolidQ, authored its Advanced T-SQL and T-SQL Fundamentals courses. A Microsoft Data Platform MVP since 1999, he has delivered T-SQL querying, tuning, and programming training worldwide. His books include T-SQL Querying and T-SQL Fundamentals.

See Also