- 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: 7.4 x 1.7 x 8.9 inches
- Shipping Weight: 2.6 pounds (View shipping rates and policies)
- Average Customer Review: 199 customer reviews
- Amazon Best Sellers Rank: #67,071 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Training Kit (Exam 70-461) Querying Microsoft SQL Server 2012 (MCSA) (Microsoft Press Training Kit) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
"Enlightenment Now: The Case for Reason, Science, Humanism, and Progress"
Is the world really falling apart? Is the ideal of progress obsolete? Cognitive scientist and public intellectual Steven Pinker urges us to step back from the gory headlines and prophecies of doom, and instead, follow the data: In seventy-five jaw-dropping graphs, Pinker shows that life, health, prosperity, safety, peace, knowledge, and happiness are on the rise. Learn more
Frequently bought together
Customers who bought this item also bought
Customers who viewed this item also viewed
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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
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.
Buy this training kit for the well-written, well organized, occasionally-flawed text and use it as a guide as you also include other sources from other books or the web, especially the MSDN site. Regard the worthless test as practice but beware of wrong answers. And, of course, good luck on your exam.
The author knows the subject but can't relate to folks who are not already completely familiar with SQL. This is not a good choice if you are just okay with the basics of T SQL. You have to be quite good at T SQL already in order to understand this book which is odd because you wouldn't need this book to pass the Microsoft Exam then.
I'm giving it 2 stars because I have been able to use this book as a topic guide. For example I can google the topics covered in each chapter, figure things out by much more clearly written and organized descriptions online, and then if I can actually follow what the author is trying to say in this book then I must know the topic pretty well.
Currently about half-way through the book and initial thoughts are that it's generally well-written, easy to follow, and comprehensive.
My one complaint: I feel that the included practice exams are far too simple compared to the actual exam. While I haven't taken the official MSCA exam yet, everything I've read, including official study guides from MS, suggests that the real exams cover much more than what I saw on the (one) practice test I've done so far. The practice test seemed to have the majority (e.g. 3/4) of questions as multiple choice on very very easy questions around basic SELECT queries, aggregate functions, etc.
I would be interested to hear from someone who has taken the real MSCA 401 exam how this books' practice tests compare? Maybe my opinion is unfounded and I will update my review at that point in time. Either way, I will certainly keep the book as a reference guide.
But the book content was very helpful. It is not a beginners book, if you already good at a subject you can easily just use this to review it, but if you find something unfamiliar then you need to find other resources to study that specific subject, generally the book gives you a path to study for the exam and it also is good to review and improve your skills.
The book has a CD which has the e-book version which is very useful if you like to read it on a tablet and also there are some sets of questions but I did not find them useful (for me), too easy and very different than the real exam.
I have rated the book 5star only based on its content I believe it is what is says Training Kit for 70-461. but I got very disappointment by publisher 1- because of the invalid coupon 2- low binding quality