Home > Store > Certification > Microsoft Certification

Exam Ref 70-761 Querying Data with Transact-SQL

Register your product to gain access to bonus material or receive a coupon.

Exam Ref 70-761 Querying Data with Transact-SQL

Best Value Purchase

Book + eBook Bundle

  • Your Price: $43.19
  • List Price: $71.98
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

More Purchase Options

Book

  • Your Price: $31.99
  • List Price: $39.99
  • Estimated Release: Apr 10, 2017

eBook (Watermarked)

  • Your Price: $25.59
  • List Price: $31.99
  • Estimated Release: Apr 10, 2017
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Description

  • Copyright 2017
  • Dimensions: 7-3/8 X 9
  • Pages: 352
  • Edition: 1st
  • Book
  • ISBN-10: 1-5093-0433-9
  • ISBN-13: 978-1-5093-0433-2

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

Downloads

Downloads

Follow the instructions to download this book's lesson files.

  1. Click the Download button below to start the download.
  2. If prompted, click Save.
  3. Locate the .zip file on your computer. Right-click the file, click Extract All, and then follow the instructions.
Download

Sample Content

Table of Contents

1. Manage Data with Transact-SQL
2. Query Data with Advanced Transact-SQL Components
3. Program Databases by using Transact-SQL

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership