MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) (eBook)

MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444)
By:Gibson, Darril;
Pub Date:October 16th 2007
Format:Electronic book text 752 pages
ISBN:0071595635 / 9780071595636
Your Price:$69.99 ADD TO CART
More Information




Main description

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 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

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


Backcover

Author Information

Downloads & Resources

Downloads



Related Products

Owl Image

Date: Apr 25th, 2016
Your Price: $85.00
Owl Image

Date: Apr 19th, 2016
Your Price: $80.00
Owl Image

Date: Apr 8th, 2016
Your Price: $60.00
Owl Image

Date: Dec 29th, 2015
Your Price: $99.00
Owl Image

Date: Dec 3rd, 2015
Your Price: $70.00
Owl Image

Date: Nov 13th, 2015
Your Price: $35.00
Owl Image

Date: Oct 12th, 2015
Your Price: $60.00
Owl Image

Date: Sep 11th, 2015
Your Price: $50.00
Owl Image

Date: Sep 2nd, 2015
Your Price: $50.00
Owl Image

Date: Aug 28th, 2015
Your Price: $90.00
Owl Image

Date: Aug 24th, 2015
Your Price: $90.00
Owl Image

Date: Aug 10th, 2015
Your Price: $60.00
Owl Image

Date: Aug 3rd, 2015
Your Price: $50.00
Owl Image

Date: Jul 30th, 2015
Your Price: $60.00
Owl Image

Date: Jul 30th, 2015
Your Price: $50.00