Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
|---|---|---|---|---|---|
Searching... | 30000010252026 | QA76.3 G536 2008 | Open Access Book | Book | Searching... |
On Order
Summary
Summary
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 Need
Get 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 2005Use 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-444Scripts from the step-by-step exercises in the book
Video training clips from the author
Complete electronic book
Author Notes
Darril Gibson, MCITP, MCDBA, MCSE, is a professional trainer specializing in Microsoft Technologies. He has created several video training courses for Keystone learning.
Table of 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 |
