Loading, please wait...

product description page

Exam Ref 70-761 Querying Data with Transact-SQL (Paperback) (Itzik Ben-gan)

Exam Ref 70-761 Querying Data with Transact-SQL (Paperback) (Itzik Ben-gan) - image 1 of 1

About this item

Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-761 Querying Data with Transact-SQL certification exam, the first of two exams required for MCSA: SQL 2016 Database Development certification.


Exam Ref 70-761 Querying Data with Transact-SQL offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern database professionals need to succeed with T-SQL database queries. Coverage includes:

  • Creating Transact-SQL SELECT queries
  • Querying multiple tables with joins
  • Implementing functions and aggregating data
  • Querying temporal and non-relational data
  • Querying data with subqueries, APPLY, and table expressions
  • Grouping and pivoting data with queries
  • Creating database programmability objects through Transact-SQL
  • Implementing error handling and transactions
  • Implementing data types and NULLs

Microsoft Exam Ref publications stand apart from third-party study guides because they:

  • Provide guidance from Microsoft, the creator of Microsoft certification exams
  • Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all" content
  • Streamline study by organizing material according to the exam’s objective domain (OD), covering one functional group and its objectives in each chapter
  • Feature Thought Experiments to guide candidates through "what if?" scenarios, and prepare them for Pro-level style exam questions
  • Focus on the critical-thinking and decision-making acumen needed for success
  • Explore big picture thinking around the planning and design aspects of the IT pro’s job role
  • Link to additional in-depth material wherever readers want deeper review of specific technical tasks or concepts

For more information on Exam 70-761 and the MCSA: SQL Server 2016 certification, visit microsoft.com/learning

Number of Pages: 334
Genre: Computers + Internet
Series Title: Exam Ref
Format: Paperback
Publisher: Microsoft Pr
Author: Itzik Ben-gan
Language: English
Street Date: April 10, 2017
TCIN: 52419349
UPC: 9781509304332
Item Number (DPCI): 248-45-5479
If the item details above aren’t accurate or complete, we want to know about it. Report incorrect product info.
In stock - free standard shipping with REDcard
Not in stores

Prices, promotions, styles and availability may vary by store & online. See our price match guarantee. See how a store is chosen for you.

*See offer details. Restrictions apply. Pricing, promotions and availability may vary by location and at Target.com.