| | |  | Manager's Guides to Computing | Home » » » MCITP Self-Paced Training Kit (Exams 70-431, 70-443, 70-444): Microsoft® SQL Server 2005 Database Administrator Core Requirements (Pro Certification) | | | | | | | Description: | | EXAM PREP GUIDES Ace your preparation for the skills measured by three core MCITP examsand on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises. PRACTICE TESTS Assess your skills with practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answersincluding a customized learning path that describes how and where to focus your studies. Maximize your exam performance with preparation for: EXAM 70-431 Microsoft SQL Server 2005Implementation and Maintenance - Install and configure SQL Server
- Set up tables, indexes, columns, and constraints
- Use Transact-SQL to implement functions, stored procedures, and triggers
- Work with relational and XML data
- Monitor, troubleshoot, and tune queries
- Maintain database availability with log shipping, mirroring, and replication
- Prepare a backup strategy and restore a database
EXAM 70-443 Designing a Database Server Infrastructure Using Microsoft SQL Server 2005 - Install, consolidate, and configure multiple database instances
- Design tables, file groups, and indexes for a physical database
- Develop and implement security policies at the server, database, and object levels
- Design, implement, and configure clustering, log shipping, mirroring, and replication
- Develop plans for data archiving, backups, and disaster recovery
EXAM 70-444 Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005 - Monitor and troubleshoot queries, databases, and servers
- Manage security strategies and perform audits
- Help defend against attacks, worms, and viruses
- Detect and resolve data conflicts
- Diagnose faults and recover from database failures and disasters
- Optimize availability with failover clustering, mirroring, log shipping, and replication
- Customize maintenance and automate routine tasks
- Build, debug, and deploy SQL Server Integration Services packages
Your all-in-one kit includes: - Official self-paced study guides for the three required exams.
- Practice tests with multiple, customizable testing options and a learning plan based on your results.
- 1200+ practice and review questions.
- Case scenarios, best practices, and practice exercises.
- 15% exam discount from Microsoft; good for three exams. Offer expires 12/31/11. Voucher inside.
- 180-day evaluation version of Microsoft SQL Server 2005 Enterprise Edition.
- Fully searchable eBooks for all three guides.
| | | Product Details: | | | Paperback:
| 2544 pages | | Publisher:
| Microsoft Press | | Publication Date:
| November 29, 2006 | | Language:
| English | | ISBN:
| 0735623775 | | Product Length:
| 9.25 inches | | Product Width:
| 7.5 inches | | Product Height:
| 4.75 inches | | Product Weight:
| 8.46 pounds | | Package Length:
| 9.37 inches | | Package Width:
| 7.64 inches | | Package Height:
| 4.8 inches | | Package Weight:
| 8.69 pounds | | Average Customer Rating:
|  based on 15 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 15 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
21 of 28 found the following review helpful:
 Make sure you check for the corrections!Mar 20, 2007
By S. Solberg
I have just finished the 70-431 book. The book is fairly well written, however, it is a full of errors! 8 Pages of corrections so far. It would have been nice if the authors/editors had tried the exercises at least.
I don't believe reference books should be like OS's that need a service pack in order to get through the written practice's. A little quality control would have done wonders!
1 of 1 found the following review helpful:
 Excellent set of booksMay 03, 2010
By Jose R. Berdecia
"Jose R Berdecia"
This set of books will provide the necessary information in order to complete the certification for MCTS and MCITP for SQL Server 2005. Anyone that wants to accomplish this can use the books and the cd's included to practice test and learn the concepts that will allow to get the certification.
2 of 3 found the following review helpful:
Great deal good trainingFeb 19, 2010
By Martin Arganaraz
I loved the case and the PDF version that comes with the CDS on the books.
The content is precise and teach you exactly what you need to know for the exams.
The test exams that comes with it are a good real practice.
Did I mention that it also came with a discount for the real test when you want your certification?
Go for it!
A Decent Attempt...Jun 29, 2011
By Sean
My review focuses on the 70-431 book because that's the only one I actually read. That said, hopefully something in my review will be useful to those who are looking at similar titles by Microsoft Press and certain authors. My review has 5 main points. Here goes:
Point #1 - Errors.
There are plenty of errors in the book, but most are dealt with adequately on the errata page available via the Microsoft website. The 70-431 edition I received had the vast majority of the errors already corrected, so Microsoft Press obviously print corrected editions which many exam prep book publishers do not. I did have cause to email Microsoft Press about an error I found which was not referenced in the errata. They replied within 24 hours (and agreed with me)! That's impressive. So kudos to Microsoft for that.
Point #2 - Practice Test.
The book comes a CD which contains hundreds of practice questions. Some of these are way too simplistic compared to what's on the actual exam. Some questions reference material which isn't even in the book. Often I'd review the answer explanation which includes a chapter and lesson reference, but when I re-checked the reference, there's absolutely no mention of what the question was asking about! That's poor.
Point #3 - Superfluous Material.
The book is littered with side notes about reading sections from Books Online or someone's blog or whatever. As someone who was preparing for the exam, I grew increasingly concerned about whether or not I needed to read these external references in order to pass the exam. The book doesn't make it clear if it's useful background reading or required reading. An exam prep book should always be self contained and not rely of copious amounts of external material to cover all the necessary bases. Looking back, I felt the book was way more than an exam prep tool. It would actually serve pretty well as a SQL Server 2005 teaching aid as well as an exam prep book.
Point #4 - Real World Content.
Many chapters contain a brief real world comment on the use or implementation of the technology presented in that chapter. In the context of an exam prep book it's not strictly necessary and the authors didn't waste too much page space (or our time) with their observations. Apart from one. Michael Hotek. I have no idea who this person is though I suspect he's a 'name' within the SQL Server world. And doesn't he know it! The meandering drivel this guy writes is tedious in the extreme and really only serves to promote how great he obviously thinks he is. I cannot reproduce his egotistical tripe here, but I can do an impression. Here goes: I awoke at 6:29AM sharp, a full one minute before the alarm would welcome me into another hectic day. As I sipped my freshly squeezed orange juice, I contemplated a replication performance issue which had overshadowed the day before. An issue which would once again stretch my considerable talents. Leaving the house that morning, I caught my reflection in the hallway mirror. My hair looked magnificent. Strolling purposefully to my car my attention was taken by the ringing of my cell 'phone......and so he goes on and on and on. I found myself screaming at the page "WHAT'S YOUR POINT MICHAEL? CAN WE GET TO THE CORE ISSUE WHILE WE'RE STILL YOUNG? So what's my point? Taking out the superfluous material and the meandering writing style of Hotek would make this book thinner, concise, more focused and infinitely more manageable for the reader who really only wants to know what they need to know to pass an exam.
Point #5 - Subject Grouping and Exam Retirement.
The exam has six subject areas which draw from the 21 chapters presented in the 70-431 book. Some exam sections require the reading of 2 or 3 chapters. Others require the reading of 7 or 8 chapters. Those sections are unwieldy and very difficult to manage. Imagine having to read, understand and comprehend several hundred pages of material BEFORE you can try a practice exam on a single exam section. That's not easy. More exam sections mapping to fewer book chapters is the way to go. Microsoft needs to look at how they group exam sections and Microsoft Press needs to look at the amount of superfluous material present in their exam prep books. As I mentioned, I only read the 70-431 book because Microsoft are retiring the SQL Server 2005 exams at the end of June 2011 and I basically ran out of time to prepare for the exams covered by the other 2 books.
I don't expect Amazon or anyone else for that matter will be selling many more of these SQL Server 2005 titles since the exams, after the end of tomorrow (6/30), will no longer be available. That said, the 70-431 book is a pretty decent text for teaching SQL Server 2005 so maybe the other books are as well. In which case, they may continue to be useful to some people since SQL Server 2005 will be around for a good while yet.
I passed the 70-431 exam using this book, the included SQL Server 2005 Enterprise Edition software, referencing Books Online and using a few practice exams from some third party companies. So, did the book do its job? Yes, it did.
Happy computing!
2 of 4 found the following review helpful:
Great BooksSep 19, 2008
By Talal A. Alsubaie
It was a very helpful book.
I think it is a great book even if you are not applying for the certificate. It helped me in my work, certificate, and personal SQL Server 2005 knowledge.
I would recommend this book for every one who is looking for a SQL Server 2005 book.
See all 15 customer reviews on Amazon.com
| | |
|
