MCITP self-paced training kit (Exam 70-443) : designing a database server infrastructure using Microsoft SQL server 2005 / J.C. Mackin, Mike Hotek.
By: Mackin, J. C.
Contributor(s): Hotek, Mike | Thernström, Tobias | Horn, Shannon | Microsoft Corporation.Material type: TextPublisher: Redmond, Wash. : Microsoft Press, c2007Description: xxxii, 708 p. : ill. ; 24 cm. + 1 CD-ROM (4 3/4 in.) + 1DVD-ROM (4 3/4 in.).ISBN: 073562173X; 9780735621732.Other title: 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 [Cover title] | MCITP exam 70-443 [Spine title].Subject(s): Microsoft Windows server | SQL server | Microsoft Windows server | Electronic data processing personnel -- Certification | Microsoft software -- Examinations -- Study guides | Databases -- Design -- Examinations | Database managementDDC classification: 005.74 Online resources: Table of contents only | Publisher description | Contributor biographical information
|Item type||Current location||Call number||Copy number||Status||Date due||Barcode|
|Books||Library Collection of Informatics and Virtual Education||QA76.3 .M3224 2007 (Browse shelf)||1-2||Available||11469|
|Books||Library Collection of Informatics and Virtual Education||QA76.3 .M3224 2007 (Browse shelf)||2-2||Available||11470|
Practice test questions on companion CD coauthored by Tobias Thernström and Shannon Horn.
Book -- 1. Planning a database server infrastructure -- 2. Deploying and consolidating multiple instances -- 3. Designing SQL server security in the enterprise -- 4. Designing database server security policies -- 5. Designing SQL server endpoints -- 6. Designing database security -- 7. Planning for high availability in the enterprise -- 8. Failover clustering -- 9. Database mirroring -- 10. Log shipping -- 11. Replication -- 12. Designing the physical database -- 13. Designing a data recovery strategy -- 14. Archiving database data.
disc 1. MCITP self-paced training kit (exam 7-443) : designing a database server infrastructure using Microsoft SQL server 2005 -- disc 2. Microsoft server 2005 enterprise edition evaluation software.
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.
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.