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
Published:November 29, 2006Language:English
Author:Solid Quality Learning, J.C. Mackin, Mike Hotek, Orin Thomas, et alTechnology:Microsoft SQL Server 2005
Length:2544 PagesISBN 13:9780735623774

List Price:

$ 139.99
About The BookYour all-in-one kit for the required MCITP Database Administrator exams.

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.

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.
  • About Solid Quality Learning, J.C. Mackin, Mike Hotek, Orin Thomas, et alThe 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.

    J.C. Mackin, MCSA, MCSE, MCT, is a writer, editor, consultant, and trainer whose books include the Self-Paced Training Kit for Microsoft Windows Server 2003 network infrastructure (Exam 70-291).

    Mike Hotek, MCITP–Database Administrator, is a consultant, writer, and trainer. He has coauthored four books on SQL Server, as well as several training courses, seminars, and articles.

    Orin Thomas, MCSE, CCNA, CCDA, and Linux+ certified, is an author and a systems administrator. He is the coauthor of several Self-Paced Training Kits and a contributing editor for Windows IT Pro magazine.

    Ian McLean, MCITP, MCDBA, MCT, has 40 years of experience in both the commercial and academic sectors. He’s written 18 books plus many technical articles and papers, and runs his own consulting company.
    Other Books By Ian McLeanOther Books By Orin ThomasOther Books By Solid Quality LearningOther Books By J.C. Mackin
    Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community. Preparing for an exam now? Find your Microsoft Certification Study Group. Talk to us on these social networks:
    What do you think of this book? Your feedback is important in helping us create books that serve your needs and meet your expectations.Please take our survey at

    Note: You will need this book's 13-digit International Standard Book Number (ISBN) to take the survey.The ISBN 13 can be found above.
    To report or search for corrections in this book or its companion content,
    search for the title in our online store and then check the Errata & Updates tab. To report errors, please go to our Submit errata page.