Exam Ref 70-761 Querying Data with Transact-SQL - Bookswagon
Logo1
Login & Sign up
AddBanner
Home icon Home
Account Icon Account
Wishlist Icon Wishlist
Cart Icon Cart
humburger icon Categories
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Databases > Exam Ref 70-761 Querying Data with Transact-SQL: (Exam Ref)
Exam Ref 70-761 Querying Data with Transact-SQL: (Exam Ref)
Exam Ref 70-761 Querying Data with Transact-SQL: (Exam Ref)

Exam Ref 70-761 Querying Data with Transact-SQL: (Exam Ref)


     4.4  |  5 Reviews 
5
4
3
2
1
Read 5 Reviews


International Edition


X

Exam Ref 70-761 Querying Data with Transact-SQL: (Exam Ref)
(Exam Ref)
Format: Paperback

About the Book

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



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


About the Author :

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.

Best Sellers

See All
Too Good To Be True
Quick View

Too Good To Be True Prajakta Koli

4.3 (6)

AED33

Thank You for Leaving
Quick View

Thank You for Leaving Rithvik Singh

2 (5)

AED30

Atomic Habits (EXP)
Quick View

Atomic Habits (EXP) James Clear

No Review Yet

AED74

My First Library
Quick View

My First Library

4.1 (8)

AED50

Dopamine Detox
Quick View

Dopamine Detox Thibaut Meurisse

No Review Yet

AED29

Money Myths and Mantras
Quick View

Money Myths and Mantras Devina Mehra

4.7 (3)

AED32

Meditations
Quick View

Meditations Marcus Aurelius

4.3 (6)

AED28

Harry Potter Box Set: The Complete Collection (Children’s Paperback)
Quick View

Harry Potter Box Set: The Complete Collection (Children’s Paperback) J.K. Rowling

4.3 (8)

AED203

Atomic Habits
Quick View

Atomic Habits James Clear

4.6 (5)

AED45

The Art of Being Alone
Quick View

The Art of Being Alone Renuka Gavrani

5 (6)

AED31

Animals Tales From Panchtantra
Quick View

Animals Tales From Panchtantra

4.5 (10)

AED32

My First Book of Patterns Pencil Control
Quick View

My First Book of Patterns Pencil Control No Author

4.6 (8)

AED21

Product Details
  • ISBN-13: 9781509304332
  • Publisher: Microsoft Press,U.S.
  • Publisher Imprint: Microsoft Press
  • Height: 226 mm
  • No of Pages: 352
  • Series Title: Exam Ref
  • Weight: 654 gr
  • ISBN-10: 1509304339
  • Publisher Date: 20 Apr 2017
  • Binding: Paperback
  • Language: English
  • Returnable: Y
  • Spine Width: 18 mm
  • Width: 185 mm

Similar Products

Add Photo
Add Photo

Customer Reviews

     4.4  |  5 Reviews 
out of (%) reviewers recommend this product
Top Reviews
Write A Review
Rating Snapshot
Select a row below to filter reviews.
5
4
3
2
1
Average Customer Ratings
     4.4  |  5 Reviews 
0–0 of 0 Reviews
Sort by :
Ratings
Reader Type
Contains Spoiler
Active Filters

0–0 of 0 Reviews
SEARCH RESULTS
1–2 of 2 Reviews
    BoxerLover2 - 5 Days ago
    A Thrilling But Totally Believable Murder Mystery

    Read this in one evening. I had planned to do other things with my day, but it was impossible to put down. Every time I tried, I was drawn back to it in less than 5 minutes. I sobbed my eyes out the entire last 100 pages. Highly recommend!

    BoxerLover2 - 5 Days ago
    A Thrilling But Totally Believable Murder Mystery

    Read this in one evening. I had planned to do other things with my day, but it was impossible to put down. Every time I tried, I was drawn back to it in less than 5 minutes. I sobbed my eyes out the entire last 100 pages. Highly recommend!


Sample text
Photo of
    Media Viewer

    Sample text
    Reviews
    Reader Type:
    BoxerLover2
    0–0 of 0 review

    Your review was submitted!
    Exam Ref 70-761 Querying Data with Transact-SQL: (Exam Ref)
    Microsoft Press,U.S. -
    Exam Ref 70-761 Querying Data with Transact-SQL: (Exam Ref)
    Writing guidlines
    We want to publish your review, so please:
    • keep your review on the product. Review's that defame author's character will be rejected.
    • Keep your review focused on the product.
    • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
    • Refrain from mentioning competitors or the specific price you paid for the product.
    • Do not include any personally identifiable information, such as full names.

    Exam Ref 70-761 Querying Data with Transact-SQL: (Exam Ref)

    Required fields are marked with *

    Review Title*
    Review
      Add Photo Add up to 6 photos
      Would you recommend this product to a friend?
      Tag this Book Read more
      Does your review contain spoilers?
      What type of reader best describes you?
      I agree to the terms & conditions
      You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

      CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

      These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


      By submitting any content to Bookswagon, you guarantee that:
      • You are the sole author and owner of the intellectual property rights in the content;
      • All "moral rights" that you may have in such content have been voluntarily waived by you;
      • All content that you post is accurate;
      • You are at least 13 years old;
      • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
      You further agree that you may not submit any content:
      • That is known by you to be false, inaccurate or misleading;
      • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
      • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
      • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
      • For which you were compensated or granted any consideration by any unapproved third party;
      • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
      • That contains any computer viruses, worms or other potentially damaging computer programs or files.
      You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


      For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy. 


      All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

      Accept

      See All

      Inspired by your browsing history


      Your review has been submitted!

      You've already reviewed this product!