MCITP self-paced training kit (Exam 70-443)
Subtitle: designing a database server infrastructure using Microsoft SQL server 2005
By: J.C. Mackin, Mike Hotek.
Contributors: Hotek, Mike.; Thernström, Tobias.; Horn, Shannon.; Microsoft Corporation.
Publisher: Microsoft Press
Published: 2007
Place of publication: Redmond, Wash
Language: eng
Number of pages: 708
ISBN-13: 9780735621732
Subjects: Microsoft Windows server; SQL server; Electronic data processing personnel -- Certification; Microsoft software -- Examinations -- Study guides; Databases -- Design -- Examinations
Genres: Study guides.
Other titles: Designing a database server infrastructure using Microsoft SQL server 2005; Designing a database server infrastructure using Microsoft SQL server 2005 : a self-paced training kit; MCITP exam 70-443
Description: Microsoft SQL Server 2005 Enterprise Edition evaluation software (1 DVD-ROM (4 3/4 in.)). 180-day limit on use. This disc contains x86, x64 and Itanium-based software.

Exam prep guide. Ace your preparation for the skills measured by MCITP Exam 70-443 - 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. This official Microsoft study guide is designed to help you make the most of your study time. Maximize your performance on the exam by learning to: 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, database mirroring, and replication; and implement your plans for data archiving, data backups, and disaster recovery. - Back cover.

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. - Back cover.
Notes: Includes index.

Practice test questions on companion CD coauthored by Tobias Thernström and Shannon Horn.

Hardware requirements: Personal computer with 600 MHz Pentium III-compatible or faster processor (Pentium 4 or equivalent if you plan to use virtual machine software); 512 MB of RAM (2.0 GB if you plan to use virtual machine software); 30 GB of available hard disk space (40 GB if you plan to use virtual machine software); DVD-ROM drive; super VGA (1024 x 768) or higher resolution video adapter and monitor. The ideal hardware for a configuration using virtual machine software that enables  reasonable performance is the following: Personal computer with a 2.4 GHz Pentium 4-compatible or faster processor; and external 7200 RPM or faster disk drive connected using either FireWire or USB 2.0.

Software requirements: The following software is required to complete the practice exercises: Microsoft Windows Server 2003 with Service Pack 1 (SP1) or later; Microsoft SQL Server 2005 Enterprise Edition, SP1 or later. (A 180-day evaluation edition of SQL Server 2005 Enterprise Edition is included on the DVD that comes with this book); and the AdventureWorks database. To view the webcasts on the companion CD, you will need a media player.
Table of contents: title: 1.; title: 1. -- 2.; title: 1. -- 2. -- 3.; title: 1. -- 2. -- 3. -- 4.; title: 1. -- 2. -- 3. -- 4. -- 5.; title: 1. -- 2. -- 3. -- 4. -- 5. -- 6.; title: 1. -- 2. -- 3. -- 4. -- 5. -- 6. -- 7.; title: 1. -- 2. -- 3. -- 4. -- 5. -- 6. -- 7. -- 8.; title: 1. -- 2. -- 3. -- 4. -- 5. -- 6. -- 7. -- 8. -- 9.; title: 1. -- 2. -- 3. -- 4. -- 5. -- 6. -- 7. -- 8. -- 9. -- 10.; title: 1. -- 2. -- 3. -- 4. -- 5. -- 6. -- 7. -- 8. -- 9. -- 10. -- 11.; title: 1. -- 2. -- 3. -- 4. -- 5. -- 6. -- 7. -- 8. -- 9. -- 10. -- 11. -- 12.; title: 1. -- 2. -- 3. -- 4. -- 5. -- 6. -- 7. -- 8. -- 9. -- 10. -- 11. -- 12. -- 13.; title: 1. -- 2. -- 3. -- 4. -- 5. -- 6. -- 7. -- 8. -- 9. -- 10. -- 11. -- 12. -- 13. -- 14.; title: 1.-- 2.-- 3.-- 4.-- 5.-- 6.-- 7.-- 8.-- 9.-- 10.-- 11.-- 12.-- 13.-- 14.; title: disc 1.; title: disc 1. -- disc 2.; title: disc 1.-- disc 2.