MCITP Selfpaced Training Kit (Exams 70-431, 70-443, 70-444) SQL Server 2005 Database Administrator Core Requirements

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. MS SQL Sever 2005 Core Requirement Staff is the author of 'MCITP Selfpaced Training Kit (Exams 70-431, 70-443, 70-444) SQL Server 2005 Database Administrator Core Requirements', published 2006 under ISBN 9780735623774 and ISBN 0735623775.