Free Training Kit (Exam 70-461) Querying Microsoft SQL Server 2012 (MCSA) (Microsoft Press Training Kit) Ebooks Online
Ace your preparation for Microsoft Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD–featuring multiple, customizable testing options. Maximize your performance on the exam by learning how to: Create database objects Work with data Modify data Troubleshoot and optimize queries For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
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.3 x 1.6 x 8.7 inches
Shipping Weight: 2.6 pounds (View shipping rates and policies)
Average Customer Review: 4.1 out of 5 stars See all reviews (174 customer reviews)
Best Sellers Rank: #26,063 in Books (See Top 100 in Books) #2 in Books > Computers & Technology > Programming > Microsoft Programming > SQL Server #4 in Books > Computers & Technology > Networking & Cloud Computing > Network Administration > Storage & Retrieval #9 in Books > Computers & Technology > Databases & Big Data > SQL
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.
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.
Training Kit (Exam 70-461) Querying Microsoft SQL Server 2012 (MCSA) (Microsoft Press Training Kit) Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 Beginning SQL 2012 Joes 2 Pros Volume 1: The SQL Queries 2012 Hands-On Tutorial for Beginners (SQL Exam Prep Series 70-461 Volume 1 Of 5) (SQL Queries 2012 Joes 2 Pros) Training Kit (Exam 70-462) Administering Microsoft SQL Server 2012 Databases (MCSA) (Microsoft Press Training Kit) Training Kit (Exam 70-463) Implementing a Data Warehouse with Microsoft SQL Server 2012 (MCSA) (Microsoft Press Training Kit) Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012 MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 - Implementation and Maintenance: Microsoft SQL Server 2008--Implementation and Maintenance (Microsoft Press Training Kit) Training Guide Installing and Configuring Windows Server 2012 R2 (MCSA): MCSA 70-410 (Microsoft Press Training Guide) Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463) Inside Microsoft SQL Server 2008 T-SQL Querying (Developer Reference) Training Guide Installing and Configuring Windows Server 2012 R2 (MCSA) (Microsoft Press Training Guide) Training Guide Administering Windows Server 2012 R2 (MCSA) (Microsoft Press Training Guide) Training Guide Configuring Advanced Windows Server 2012 R2 Services (MCSA) (Microsoft Press Training Guide) CompTIA A+ Training Kit (Exam 220-801 and Exam 220-802) (Microsoft Press Training Kit) Self-Paced Training Kit (Exam 70-667) Configuring Microsoft SharePoint 2010 (MCTS) (Microsoft Press Training Kit) Learn SQL Server Administration in a Month of Lunches: Covers Microsoft SQL Server 2005-2014 MCSA Guide to Installing and Configuring Microsoft Windows Server 2012 /R2, Exam 70-410 MCSA Guide to Administering Microsoft Windows Server 2012/R2, Exam 70-411 Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference) MCITP Self-Paced Training Kit (Exam 70-686): Windows® 7 Desktop Administrator (Microsoft Press Training Kit)
