MCITP Self-paced Training Kit (Exams 70-431, 70-443, 70-444): Microsoft SQL Server 2005 Database Administrator Core Requirements

MCITP Self-paced Training Kit (Exams 70-431, 70-443, 70-444): Microsoft SQL Server 2005 Database Administrator Core Requirements

Mixed media product Pro Certification

By (author) Solid Quality Learning, By (author) I. McLean, By (author) J. C. Mackin, By (author) Mike Hotek, By (author) Orin Thomas

USD$127.34
List price $135.01
You save $7.67 (5%)

Free delivery worldwide
Available
Dispatched in 4 business days
When will my order arrive?

  • Publisher: Microsoft Press,U.S.
  • Format: Mixed media product | 2544 pages
  • Dimensions: 194mm x 238mm x 122mm | 3,942g
  • Publication date: 1 December 2006
  • Publication City/Country: Redmond
  • ISBN 10: 0735623775
  • ISBN 13: 9780735623774
  • Sales rank: 386,372

Product description

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.

Other books in this category

Showing items 1 to 11 of 11
Categories:

Author information

The mentors at Solid Quality Learning combine deep technical expertise and real-world implementation experience to provide advanced solutions and training for the Microsoft SQL Server database platform.

Table of contents

Box set consisting of: "MCTS SQL Server 2005 Implementation & Maintenance Training Kit" "MCITP Designing a Database Server Infrastructure using SQL Server 2005 Training Kit" "MCITP Optimizing & Maintaining a Database Administration Solution using SQL Server 2005 Training Kit" Plus on attached CDs - Practice Tests, eBooks & Trial Software