|
MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443 and 70-444)
A complete study tool and on-the-job reference for the MCITP SQL Server 2005 Database Administration exams
This comprehensive guide offers complete coverage of the material on all three of the new Microsoft Certified IT Professional exams for SQL Server 2005. You will find details on database configuration,T-SQL, security, high availability,
and more. Filled with case studies, checklists, technical sidebars, and real-world examples, this book serves as both an exam preparation tool as well as an essential on-the-job reference.The CD-ROM includes practice exam software featuring hundreds of questions, and an electronic book.
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 CD
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
|
