The Best Fully Integrated Study System AvailableWith 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
- ISBN10 0071706968
- ISBN13 9780071706964
- Publish Date 30 May 2007
- Publish Status Active
- Publish Country AU
- Publisher McGraw-Hill Education - Europe
- Imprint McGraw-Hill Education / Australia
- Edition 3rd ed.
- Format eBook
- Pages 640
- Language English