MCITP SQL Server 2005 Database Administration Exam Guide: (Exams 70-431, 70-443, and 70-444) [With CDROM]

Erscheinungsjahr 2007
ISBN: 978-0-07-149609-4
Verlag: OSBORNE

Buch, Englisch, 752 Seiten, CDROM, Format (B × H): 199 mm x 239 mm, Gewicht: 1532 g

Reihe: All-In-One

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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

The CD-ROM 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

- Complete electronic book

Autoren/Hrsg.

Gibson, Darril

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung SQL Server/MS SQL

Inhaltsverzeichnis

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

Über Autor(innen)

Darril Gibson, MCITP, MCDBA, MCSE, is a professional trainer specializing in Microsoft Technologies. He has created several video training courses for Keystone learning.