Book description
All-in-One is All You NeedGet complete coverage of all three Microsoft Certified IT Professional database administration exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.
Get full details on all exam topics including how to:
- Install and configure SQL Server 2005
- Use Transact-SQL
- Manage server infrastructure design
- Optimize databases
- Secure databases and servers
- Ensure high availability
- Implement backup and recovery strategies
- Maximize the built-in administration tools
- Use Business Intelligence tools, including SSIS and SSRS
- Manage concurrency
Electronic content features:
- Six full practice exams--two for each exam: 70-431, 70-443, and 70-444
- Scripts from the step-by-step exercises in the book
- Video training clips from the author
Table of contents
- Cover Page
- All-in-One MCITP SQL Server 2005 Database Administration
- Copyright Page
- Dedication
- ABOUT THE AUTHOR
- CONTENTS
- Acknowledgments
- Introduction
- Chapter 1 Installing and Configuring SQL Server 2005
- Chapter 2 SQL Server 2005 Database Basics
- Chapter 3 Database Design
- Chapter 4 Transact-SQL Primer
- Chapter 5 Advanced Database Objects
- Chapter 6 Server Infrastructure Design
- Chapter 7 Optimizing Databases
- Chapter 8 Database Security
- Chapter 9 Server Security
- Chapter 10 High-Availability Strategies
- Chapter 11 Data Recovery Strategies
- Chapter 12 Data Access
- Chapter 13 Database Administrator Tools
- Chapter 14 Business Intelligence
- Chapter 15 Managing Concurrency
- Appendix A About the Download
- Appendix B Exam 70-431: What You Need to Know to Pass
- Appendix C Inside the Design Test
- Appendix D Exam 70-443: What You Need to Know to Pass
- Appendix E Exam 70-444: What You Need to Know to Pass
- Appendix F SQL Database Design Object Summary
- Glossary
- Index
Product information
- Title: MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444)
- Author(s):
- Release date: October 2007
- Publisher(s): McGraw-Hill
- ISBN: 9780071595636
You might also like
book
MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442)
All-in-One is All You Need Get complete coverage of all three Microsoft Certified IT Professional database …
book
MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide
This ebook does not provide access to the CD-ROM files. Covering Microsoft's brand-new SQL 2005 administrator …
book
The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit
SQL Server 2008 is the latest update to Microsoft's flagship database management system. This is the …
book
Professional Microsoft® SQL Server® 2008 Administration
SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, …