₹ 2,294.00 + FREE Delivery

M.R.P.: ₹ 2,802.00
You Save: ₹ 508.00 (18%)
Inclusive of all taxes

Usually dispatched in 4 to 5 days.

Sold and fulfilled by Bookswagon (3.8 out of 5 | 1,985 ratings).

Other Sellers on Amazon

Add to Cart

₹ 2,208.00
+ ₹ 200.00 Delivery charge

Sold by: Sunrise Book store

Add to Cart

₹ 2,511.00
+ FREE Delivery

Sold by: B2A UK

Have one to sell? Sell on Amazon

Flip to back Flip to front

Listen Playing... Paused You're listening to a sample of the Audible audio edition.
Learn more.

See all 2 images

Follow the Author

Itzik Ben-Gan

Exam Ref 70-761 Querying Data with Transact-SQL Paperback – 31 Mar 2017

by Itzik Ben-Gan (Author)

1 rating

See all 2 formats and editions Hide other formats and editions

Price

New from

Kindle Edition

"Please retry"

₹ 1,551.59

—

Paperback

"Please retry"

₹ 2,294.00

₹ 2,098.00

Returns Policy

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

About the Exam

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.

About Microsoft Certification

Passing this exam earns you credit toward a Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of essential skills for building and implementing on-premises and cloud-based databases across organizations. Exam 70-762 (Developing SQL Databases) is also required for MCSA: SQL 2016 Database Development certification.

See full details at: microsoft.com/learning

Save Extra with 4 offers

Cashback: Flat Rs.50 back on minimum order of Rs.50 using Amazon Pay UPI. For Android App customers only. Applicable on 1st ever transaction on Amazon Pay UPI. Cashback within 5 days. Set up Amazon Pay UPI Here's how

No Cost EMI: Avail No Cost EMI on select cards for orders above ₹3000

Bank Offer (3): 5% Instant discount with HSBC Cashback card

10% Instant discount with HDFC PayZapp Card

Get 5% Instant Discount upto INR 1000 on SBI Credit EMI transactions

Partner Offers (2): Avail EMI on Debit Cards. Get credit up to ₹1,00,000.Check eligibility here!

Get GST invoice and save up to 28% on business purchases. Sign up for free

Frequently bought together

Customers who viewed this item also viewed

Page 1 of 1 Start overPage 1 of 1

This shopping feature will continue to load items when the Enter key is pressed. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

Stacia Varga

4

Paperback
₹ 520.00
Gan B.I

32

Paperback
₹ 727.00
Itzik Ben-Gan

11

Paperback
₹ 460.00
Ben-Gan Itzik

12

Paperback
₹ 716.00
Itzik Microsoft…

23

Paperback
₹ 3,698.00
Itzik Ben-gan

212

Paperback
₹ 4,005.00

Product description

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.

Start reading Exam Ref 70-761 Querying Data with Transact-SQL on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Product details

Paperback: 352 pages
Publisher: Microsoft Press; 1 edition (31 March 2017)
Language: English
ISBN-10: 1509304339
ISBN-13: 978-1509304332
Product Dimensions: 18.7 x 2.4 x 22.6 cm
Average Customer Review: 1 customer review
Amazon Bestsellers Rank: #35,021 in Books (See Top 100 in Books)
- #31 in IT Certification Exams
- #71 in Computer Databases (Books)
- #47 in Database Storage & Design

Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?

Customers who bought this item also bought

Page 1 of 1 Start overPage 1 of 1

Stacia Varga

4

Paperback
₹ 520.00
Gan B.I

32

Paperback
₹ 727.00
Itzik Ben-Gan

11

Paperback
₹ 460.00
Ben-Gan Itzik

12

Paperback
₹ 716.00
Kort W D

21

Paperback
2 offers from Rs. 2,299.00

Customer reviews

5 star 0% (0%)		0%
4 star		100%
3 star 0% (0%)		0%
2 star 0% (0%)		0%
1 star 0% (0%)		0%

Review this product

Write a product review

1 customer review

There was a problem filtering reviews right now. Please try again later.

Kalpesh Patel

Very useful for professionals

25 November 2018

Format: PaperbackVerified Purchase

Successfully passed with this book. It's useful to get familiar with SQL concept.

2 people found this helpful

Helpful

Comment

Most helpful customer reviews on Amazon.com

Amazon.com: 33 reviews

Clyde LeBonz

Four & a Half Stars

27 November 2018 - Published on Amazon.com

Format: PaperbackVerified Purchase

Excellent prep for the 70-761 exam, as all Ben-Gan's books have been. Passed the cert exam a couple weeks ago.

The only reason for not giving it five stars is by comparison with Ben-Gan's equivalent book for SQL 2005, which is about 50% longer and goes into more fundamental detail on topics that are still relevant, such as pivoting which was introduced in that version. In general, you can't go wrong with any of Ben-Gan's books.

Wish the prep book for the next exam, 70-762, were half as good, but the text is riddled with typo's and a few important omissions & errors.

Wrote the above on Nov 26 2018; adding this a couple months later. A subsequent comment complains that this book is written at a Ph.D. level, which is pure nonsense. It is written for the intelligent technical reader who is willing to grapple with occasionally tricky aspects of relational database and SQL syntax. Ben-Gan is one of the best technical writers you're ever going to find.

7 people found this helpful

Alex P

I passed 70-761 test yesterday.

7 February 2018 - Published on Amazon.com

Verified Purchase

I highly recommend this book if you are preparing for 70-761 exam.

I have no idea why people are complaining about this book. Yes, it is very dry, but so querying SQL server topic is. Out of all the materials I used to get ready for the test, I found the book to be the most comprehensive source of most detailed information. Yes, he has links pointing out of the book, so what? It is a ton of material, and you can't fit everything in 1 book, unless you are are OK to have a 2000 pages book. And I found all those links (for example, a link to an 1.5 hour long video about intricacies of CROSS APPLY) very helpful.

10 people found this helpful

Amazon Customer

These good reviews are completely unjustified

9 December 2018 - Published on Amazon.com

Format: PaperbackVerified Purchase

I am so frustrated after studying this book that I felt compelled to leave a review - and I never review anything.

This book is dry, all over the place, and UNNECESSIARLY WRITTEN AT THE PHD LEVEL.

Why are you using PHD Level reading for a SQL book? It makes no sense. Why???

Do you talk like this in your every day life?

You could've made this book, and this subject, much more user friendly by teaching the concepts in plain English.

Please note - I have a Masters degree, and I finished at the top of my class. Many textbooks that I was forced to drudge through during my masters program were not written as difficult as this book is.

Also note - this book is heavy on computer science. If you are not a computer science major - you will be completely lost studying this book. The author describes complex computer science concepts as if you already know in depth what he's talking about.

Unfortunately, he has a monopoly over the 70-761 exam, because there are literally no other books / courses that teach the full extent of the tested material.

I encourage anyone that has a good understanding of T-SQL to please create teaching context in plain, easy to read English.

In short, It is impressive that you are so smart Ben-Gan - but the PHD language you use to teach is completely and utterly unnecessary. Save that for the PHD literature courses.

5 people found this helpful

T. COTON

I slept on almost each paragraph of this book...

7 February 2019 - Published on Amazon.com

Format: PaperbackVerified Purchase

I don't know how and why Microsoft choose their official author or even if they try to use the books they publish but this book is difficult to read beyond comprehension. The phrasing is so boring and so dense that I surprised myself sleeping in the middle of a sentence in almost each paragraph. I don't get it, really, why starting with a soporific introduction, then explaining the very basics of SELECT then introducing functions explained 3 chapters appart, then bypassing or should I say, overlooking most of the basic features after spending a tremendous amount of time on a simple SELECT and finishing the book by what should have been at the beginning. Not to mention the links to even more complex information. In no way would you be able to pass the exam by just reading this book, this is impossible unless you have several years of practice and you can code complex SQL in your sleep. Do not misunderstand my review, there is absolutely no doubt about the knowledge and the high skills of the author about T-SQL but he is not, or at least, this book, is not pedagogical. This book is not a preparation for the Microsoft exam, rather a complement of information or maybe a concentrate of knowledge, if you are looking to prepare for the certification and are rather new to T-SQL, you will need to read more and practice more than what is in this book. This book is very hard to digest, be prepared! Now, I have to find some guided exercices to practice more...

One person found this helpful

Michael

I passed the 70-761 with the help of this book

28 March 2019 - Published on Amazon.com

Format: PaperbackVerified Purchase

I am a database specialist and had about 7 months experience with SQL Server 2016 and about 2 to 3 years with databases in general including earlier versions of SQL Server when I passed the 70-761 exam.

I am currently studying for the 70-762 and wanted to leave a review on this book as so much in it is applicable to the next test also. I did have a hard time reading and comprehending everything my first time through but I then wen through chapter by chapter, memorized and practiced key terms, syntax, and rewrote a lot of the text in my own words.

I am inspired to leave this 5 star review here and now because as I study for the next exam, I find that a lot of things I learned out of this book have given me a solid foundation. I am finding the Exam Ref 70-762 a much more difficult read but that could be because the concepts are supposed to be more advanced.

3 people found this helpful

AbeBooks Books, art & collectibles	Amazon Web Services Scalable Cloud Computing Services	Audible Download Audio Books	DPReview Digital Photography	IMDb Movies, TV & Celebrities

Shopbop Designer Fashion Brands	Amazon Business Everything For Your Business	Prime Now 2-Hour Delivery on Everyday Items	Amazon Prime Music Stream millions of songs, ad-free

Other Sellers on Amazon

Follow the Author

Similar authors to follow

Exam Ref 70-761 Querying Data with Transact-SQL Paperback – 31 Mar 2017

Save Extra with 4 offers

Frequently bought together

Customers who viewed this item also viewed

Product description

About the Author

Product details

Customers who bought this item also bought

Customer reviews

Review this product

1 customer review

There was a problem filtering reviews right now. Please try again later.

Most helpful customer reviews on Amazon.com