|
MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431)
The only classroom-proven test prep tool for the new Microsoft SQL Server 2005 certification exam
An integrated study system based on proven instructional
methodology, this book and CD package shows you not only what--but how--to study for the new
MCDBA SQL Server 2005 Technology Specialist exam. The book
offers
complete coverage of all official exam objectives, 250-plus
practice exam questions, step-by-step exercises, and more. The
CD-ROM contains a complete practice exam and an e-book.
CONTENTS:
1. Installing SQL Server 2005
2. Configuring SQL Server 2005
3. Creating Databases and Database Objects
4. SQL Server Security
5. Creating Views, Partitions, and linked Servers
6. Transact-SQL Programming
7. Working with Constraints, Triggers, and stored procedures
8. Backup and Restore of SQL Server with SQL Agent Jobs
9. Data Redundancy and Availability
10. Using the Service Broker
11. XML Data Support
12. SQL Server Performance Monitoring and Tuning
13. Troubleshooting Server and Database Errors
a) About the CD
b) Tables
c) SQL Server 2005 Implementation Case Studies
|
