Programming Books C Java PHP Python Learn more Browse Programming Books
  • List Price: $69.99
  • Save: $49.30 (70%)
Rented from RentU
To Rent, select Shipping State from options above
Due Date: Dec 21, 2014
FREE return shipping at the end of the semester. Access codes and supplements are not guaranteed with rentals.
FREE Shipping on orders over $35.
Used: Good | Details
Sold by RentU
Condition: Used: Good
Comment: Fast shipping from Amazon! Qualifies for Prime Shipping and FREE standard shipping for orders over $35. Overnight, 2 day and International shipping available! Excellent Customer Service.. May not include supplements such as CD, access code or DVD.
Access codes and supplements are not guaranteed with used items.
Add to Cart
Qty:1
  • List Price: $69.99
  • Save: $25.96 (37%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $18.25
Gift Card.
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

Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 (Microsoft Press Training Kit) Paperback – December 25, 2012

ISBN-13: 978-0735666054 ISBN-10: 0735666059 Edition: 1st

Buy New
Price: $44.03
Rent
Price: $20.69
49 New from $40.03 19 Used from $30.50
Rent from Amazon Price New from Used from
Paperback
"Please retry"
$20.69
$44.03
$40.03 $34.45

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student




Frequently Bought Together

Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 (Microsoft Press Training Kit) + Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases (Microsoft Press Training Kit) + Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012 (Microsoft Press Training Kit)
Price for all three: $130.58

Buy the selected items together

Customers Who Bought This Item Also Bought

NO_CONTENT_IN_FEATURE

Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now

Product Details

  • Series: Microsoft Press Training Kit
  • Paperback: 752 pages
  • Publisher: Microsoft Press; 1 edition (December 25, 2012)
  • Language: English
  • ISBN-10: 0735666059
  • ISBN-13: 978-0735666054
  • Product Dimensions: 9 x 7.4 x 1.4 inches
  • Shipping Weight: 2.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.1 out of 5 stars  See all reviews (88 customer reviews)
  • Amazon Best Sellers Rank: #17,163 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Dejan Sarka is a mentor with SolidQ and focuses on development of database and business intelligence applications. He is a frequent speaker at international conferences such as TechEd, SqlDevCon, and PASS. He is the founder of the Slovenian SQL Server and .NET Users Group. As main author or coauthor, Dejan has written nine books about SQL Server. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.


More About the Author

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2012 T-SQL Fundamentals and Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions. He has written many articles for SQL Server Pro as well as articles and whitepapers for MSDN. Itzik's speaking activities include TechEd, DevWeek, SQLPASS, SQL Server Magazine Connections, various user groups around the world, and SolidQ's events to name a few. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.
For more details please visit http://tsql.solidq.com.

Customer Reviews

I am finding it well worth the time to read.
Amazon Customer
I used this book, Microsoft Virtual Academy and Books Online to pass the 70-461 exam.
longwaful
Book is very well written and easy for follow.
Hiren Joshi

Most Helpful Customer Reviews

25 of 25 people found the following review helpful By Rami F. El-chafei on January 4, 2013
Format: Paperback
I bought the e-book version. Very well written and easy to follow. It has excellent hands-on practice tests the end of each chapter. If you're like me somewhat new to SQL, I recommend to start with Itzik's Microsoft SQL Server 2012 T-SQL Fundamentals book. Having read both books and went over SQL syntax from Microsoft MSDN, I was able to write the 70-461 test and passed it. 70-462 is next!
7 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
26 of 27 people found the following review helpful By schmintan on April 22, 2013
Format: Paperback
The book is good. It covers everything on the exam, gives good tips, has lots on info and points to great links when it doesn't have space to give pages and pages of detail.. Content all seems accurate to me. It's a bit of a tome,but its all good and necessary info.

If your buying for the practice exam that comes on the included DVD, don't. Questions have zero representation to the actual exam. They are way too simple and short and have no resemblance to the exam in structure, content or difficult.

As the book is good, and if this review was for the book alone, I'd give full stars, but it loses 2 stars as the practice exam (a big reason I got the book) was so rubbish.

Conclusion- great book, crap sample exam.
4 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
39 of 44 people found the following review helpful By Jose on December 13, 2012
Format: Paperback Verified Purchase
1st, a small disclaimer...

At the time of this review, 12/13/12 I have not finished reading or studying this book yet; as a matter of fact, I challenge any person or reviewer saying he or she has finished the book, as frankly speaking would be difficult or impossible to believe. However, I decided to jump ahead and give my honest review from what I've read so far. I have no business relationship with any of the authors whatsoever.

Having said that, I like this book so far. It is way, way better than its previous version. It goes more in-depth and gives a more holistic approach to T-SQL. I'll explain that in a few.

So far, i've read: Chapter 1, which is an intro to what set theory is. Chapter 2, which is about SELECT statements. Chapter 15, which is about Indexes and Chapter 17, which is about optimization. All those cover the basics and more about what you need for your day to day job and to fully understand T-SQL and their proper usage. The Index and Optimization chapters have plenty of illustrations and the concepts are exposed in a clear but concise manner.

Each chapter, as the typical MS cert books, has questions an answers but there are also lot of labs with exercises and T-SQL queries to play with. You only need a SQL2012 instance (any flavor) to practice.

I consider this book a hybrid between Itzik's bestseller, T-SQL fundamentals and previous SQL query book from Microsoft. This new version keeps its simplicity while going more in detail and giving a non proprietary and holistic approach to what T-SQL is or should be.

I've been reading Itzik's books for several years now and he has improved his writing skills a lot.
Read more ›
8 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
14 of 14 people found the following review helpful By R. Sheedy on August 25, 2013
Format: Paperback Verified Purchase
I just passed the exam with a score of 831 on my first try at 62 years of age. This book was my primary study guide, but I vacillated between giving 3 or 4 stars. Here's how I arrived at four:

The book itself would have been a solid five except for numerous editing errors, which I find somewhat inexcusable especially when you take the quiz at the end of a chapter only to find that the book had some wrong answers. I'm glad I had a later edition so I didn't have to put up with scrambled chapters. I've written books myself so I am at a loss as to how so many errors could have slipped by. I'll blame it on the editors (or lack thereof) - just make sure you print out the errata page from the O'Reilly site as a reference. So for bad editing, I subtract .5 stars.

And then there's the practice exam...
This has got to be the worst practice exam out there for this test. The questions bear little resemblance to the real thing in either format or difficulty. If you barely pass this exam YOU WILL NOT PASS THE REAL THING. I was getting about 95% on the MeasureUp exam and then bought the Transcender exam after reading some of the reviews here. My 95% was worth 60% (FAIL) on the Transcender exam, which is much closer to the real exam in difficulty. I am not trying to sell you on Transcender as I feel it was over-priced considering that it too has accuracy issues.

Bottom line, I was ready to deduct two stars for the worthless exam (which another reviewer did) but decided to view it as a flawed bonus, like those coupons that print on your grocery receipt for items you just bought. So another .5 deduction - four stars seems about right. I would prefer that they didn't include the test as it could raise one's confidence unjustifiably.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
16 of 19 people found the following review helpful By Henrik on January 7, 2013
Format: Paperback
I bought this book for my 70-461 exam preparation (as a ebook)

I have not yet attended the exam but that is actually beside the point for this review, because what I found is that this book is such an excellent coverage of SQL Server 2012 querying, that I simply read the book from start to finish just to learn - not to cram.

I've been working with SQL Server since version 7 and I thought I had the querying part down pretty well. But after reading this book, I've found so many new ways of doing things - better (should have read it a long time ago...).

Best of all, even though the book is a whopping 700+ pages, I found no irrelevant or chattering passages. Everything is well written - tight and to the point.

It gets my unconditional recommendation !

/Henrik Nordtop
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews

Search