
MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431)
Tom Carpenter(Author)
Osborne/McGraw-Hill (Publisher)
3rd Edition
Published on 16. July 2007
Book
640 pages
978-0-07-226321-3 (ISBN)
Description
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.
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
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
More details
Edition
3rd edition
Language
English
Place of publication
New York
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Illustrations
200 Illustrations
Dimensions
Height: 229 mm
Width: 183 mm
Thickness: 33 mm
Weight
1071 gr
ISBN-13
978-0-07-226321-3 (9780072263213)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Previous edition

Joyjit Mukherjee
MCDBA Administering SQL Server 2000 Study Guide (Exam 70-228)
Book
07/2001
McGraw-Hill Inc.,US
€45.89
Article exhausted; check for reprint
Person
Tom Carpenter is a technical experts' expert. He teaches in-depth courses on Microsoft technologies, wireless networking and security, and professional development skills such as project management, team leadership and communication skills for technology professionals. Tom holds a CWNA, CSWP and Wireless# certification with the CWNP program and is also a Microsoft Certified Partner. He is married to his lovely wife, Tracy, and lives with her and their four children, Faith, Rachel, Thomas and Sarah in Ohio.