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

Have a Promotion Code?

Please enter it here:

Great deals and more!

Sign up for special offers, exclusive discounts, and new product announcements from McGraw-Hill Professional.

SIGN UP TODAY


Date

May 30, 2007

Format

Mixed media product, 640 pages

Other Formats


ISBN

0072263210 / 9780072263213

$

Your Price

49.99



Overview


Main description

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


Author comments

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


Back cover copy

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





Copyright 2014 McGraw-Hill Global Education Holdings, LLC

WELCOME!

Before you can enjoy free downloads from McGraw-Hill Professional, we ask that you please provide your email address and country.



Yes, I want to receive other special offer.