MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431)

MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431)

by Tom Carpenter

NOOK Book(eBook)

$28.99 $49.99 Save 42% Current price is $28.99, Original price is $49.99. You Save 42%.
View All Available Formats & Editions

Available on Compatible NOOK Devices and the free NOOK Apps.
WANT A NOOK?  Explore Now

Overview

The Best Fully Integrated Study System Available

With hundreds of practice questions and hands-on exercises, MCTS SQL Server 2005 Implementation & Maintenance Study Guide covers what you need to know--and shows you how to prepare--for this challenging exam.

  • 100% complete coverage of all official objectives for Exam 70-431
  • Exam Readiness Checklist at the front of the book--you're ready for the exam when all objectives on the list are checked off
  • Inside the Exam sections in every chapter highlight key exam topics covered
  • Simulated exam questions match the format, tone, topics, and difficulty of the real exam

Covers all the exam topics, including:

Installing and Configuring SQL Server 2005 * Creating Databases and Database Objects * SQL Server Security * Creating Views, Partitions, and Linked Servers * Transact-SQL Programming * Working with Constraints, Triggers, and Stored Procedures * Backup and Restore of SQL Server with SQL Agent Jobs * Data Redundancy and Availability * Using the Service Broker * XML Data Support * SQL Server Performance Monitoring and Tuning * Troubleshooting Server and Database Errors

CD-ROM includes:

  • Complete MasterExam practice testing engine, featuring: One full practice exam; Detailed answers with explanations; Score Report performance assessment tool
  • Video training clips from the author
  • Electronic book for studying on the go

With free online registration:

  • One-hour LearnKey video training session
  • Bonus downloadable MasterExam practice test

Product Details

ISBN-13: 9780071706964
Publisher: McGraw-Hill Education
Publication date: 06/20/2007
Sold by: Barnes & Noble
Format: NOOK Book
Pages: 640
File size: 16 MB
Note: This product may take a few minutes to download.

About the Author

Tom Carpenter, CWNA, CWSP, MCTS is the senior consultant for SYSEDCO.

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews