Programming Books C Java PHP Python Learn more Browse Programming Books
  • List Price: $69.99
  • Save: $39.54 (56%)
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.
Used: Very Good | Details
Condition: Used: Very Good
Comment: OVERNIGHT and 2-DAY SHIPPING AVAILABLE......Very Good condition with light wear. The item is in Amazon's warehouse and shipped to you by Amazon. You have the assurance that you will get your item in a timely manner. In the unlikely event something should go wrong with the shipping, you can contact Amazon to assist with the customer service, tracking or hassle-free return. We are very proud to be in this program as it allows us to offer the best customer experience possible.
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.03
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: $30.45
48 New from $40.03 24 Used from $35.32
Rent from Amazon Price New from Used from
Paperback
"Please retry"
$30.45
$44.03
$40.03 $35.32

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

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 (86 customer reviews)
  • Amazon Best Sellers Rank: #9,603 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
38 of 43 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
7 of 7 people found the following review helpful By Amazon Customer on December 27, 2012
Format: Paperback Verified Purchase
I really like this book. I haven't taken the test yet, so I will update with that aspect of it later.
The book is plain, simple, yet full of the information you need to get your work done. While you could probably pick this up and learn T-SQL, it is really meant to quickly address implementation and specifications. Beginners would be best with a book that covers some theory and takes more time to explain the "why" of T-SQL and RDBMS in general. As a pro, you could probably read the release notes, since it really is the basics and part of the price is for logical query processing order, select statements, joins and filters.
The book gets into more complicated subjects later though, and has good pacing and separation of topics. Exercises are clearly marked and moved away from the main material, so it is easy to read, then practice. There are several sets of practice questions that are directed toward the certification aspect of the book, but there are also more complicated scenarios. This is nice so you feel that the book is not just an exam cram - it's truly trying to give you the knowledge to succeed.
One final note is that the writing is very easy to follow. The authors usually state the complex or significant issues twice - once in technical language, and a second time in a more layman's terms, describing the goal or technique. This is really nice as it helps you to both understand the immediate material, as well as develop the vocabulary and vernacular surrounding databases.

Edit: after taking the test just a couple of suggestions. Your learning style and experience may be somewhat different, but I would recommend skipping the practice tests included on the CD and just complete the exercises and practice in the book.
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

Customer Images

Most Recent Customer Reviews

Search