Programming Books C Java PHP Python Learn more Browse Programming Books
  • List Price: $69.99
  • Save: $40.89 (58%)
Rented from RentU
To Rent, select Shipping State from options above
Due Date: Dec 23, 2014
FREE return shipping at the end of the semester. Access codes and supplements are not guaranteed with rentals.
Qty:1
  • List Price: $69.99
  • Save: $25.51 (36%)
Usually ships within 1 to 3 weeks.
Ships from and sold by Amazon.com.
Gift-wrap available.
Training Kit (Exam 70-461... has been added to your Cart
Trade in your item
Get a $22.29
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.48
Rent
Price: $29.10
39 New from $44.48 15 Used from $34.74
Rent from Amazon Price New from Used from
Paperback
"Please retry"
$29.10
$44.48
$44.48 $34.74
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.54

Some of these items ship sooner than the others.

Buy the selected items together

Customers Who Bought This Item Also Bought

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > 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 (92 customer reviews)
  • Amazon Best Sellers Rank: #6,360 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

26 of 26 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
28 of 29 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
15 of 15 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
8 of 9 people found the following review helpful By Matt Akers on November 10, 2013
Format: Paperback Verified Purchase
Let me preface by saying this. I am currently a senior SQL Developer for a fortune 500 company. I have been in and around IT for the last 10+ years.

I recently went and took my 70-461 and failed it. Actually quite miserably. I've read this book cover to cover. I've read certain more challenging chapters more than once. I've done all the examples. I've worked through the practice test included from Measure Up at least a dozen times. On topics requiring a bit more depth (i.e. format number memorization for CONVERT, Transaction Isolation Level details, Physical Storage topics/techniques, and Indexing) I spent a healthy amount of time on the MSDN libraries expanding on the book. All with confidence in my understanding and a rehearsed command of the knowledge in my work environment.

This book is written expertly. Hands down. The authors are extremely knowledgeable and the book is well written.

Given that the title of this book is a training kit and targets specifically knowledge geared towards passing the 70-461, and the fact that I could not pass the test on this content alone I cannot rate this book more than a 3. The test examples included on the CD-ROM are lightyears less complicated than the test questions. And the test itself goes into nuance memorization that departs from recommended standards.

To me Microsoft has really missed the mark on this exam and the book doesn't do what it suggests it might.

As my title suggests... Be prepared to be much much better at your job and real life application. But don't buy this book thinking you will pass the exam. I am proof.
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

Most Recent Customer Reviews