Overview
EXAM PREP GUIDES Ace your preparation for the skills measured by three core MCITP exams—and 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 answers—including 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 2005—Implementation 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.
Synopsis
Get in-depth training and practice with the skills measured by the core exams for Microsoft Certified IT Professional: Database Administrator certification-all in one box! Covering Exams 70-431, 70-443, and 70-444, these three training kits include exam prep and practice tests to help you maximize your performance. You get official Microsoft study guides, plus practice tests on CD to help you assess your skills. They come packed with the tools and features that exam candidates want most-including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and customizable testing options. They also provide real-world case scenarios and practice exercises for skills and expertise you can apply to the job.
Work at your own pace through the lessons and hands-on exercises. The study guides focus on installing and configuring Microsoft SQL Server ; designing a database server infrastructure; designing a database solution for high availability; monitoring and troubleshooting; backing up, archiving, and restoring a database; and designing a strategy to manage and maintain databases and database security.
Then assess yourself by using more than 900 practice and review questions on the CD, featuring multiple, customizable testing options to meet your specific needs. Choose timed or untimed testing mode, generate random tests, or focus on discrete objectives or chapters. You get detailed explanations for right and wrong answers-including pointers back to the book for further study. You also get a 180-day evaluation version of Microsoft SQL Server 2005 Enterprise edition and an exam discount voucher-making this kit an exceptional value and a great career investment.