MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam - page 1
- MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005
- MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005
- Table of Contents
- Copyright
- About the Author
- Acknowledgments
- We Want to Hear from You
- Reader Services
- Introduction
- About the 70-431 Exam and Content Areas
- How to Prepare for the Exam
- What This Book Does
- What This Book Does Not Do
- About This Book
- Self Assessment
- SQL Server Implementation and Maintenance as an MCTS
- Chapter 1. Installing and Configuring SQL Server 2005
- Installing and Configuring SQL Server 2005
- Exam Prep Questions
- Chapter 2. Creating Database Objects
- Creating and Defining Databases
- Defining SQL Server Tables
- SQL Server Programmability Objects
- Exam Prep Questions
- Answers to Exam Prep Questions
- Chapter 3. Implementing Database Objects
- Data Querying and Reporting
- Data Querying Using Full-Text Indexes
- Using System Tables and Views
- Changing What Is Already Stored
- Removing Unwanted Data
- Exam Prep Questions
- Answers to Exam Prep Questions
- Chapter 4. Supporting the XML Framework
- Managing XML Data
- Other SQL Server XML Support
- Exam Prep Questions
- Answers to Exam Prep Questions
- Chapter 5. Data Consumption and Throughput
- Importing and Exporting Data
- Implementing Service Broker
- Exam Prep Questions
- Answers to Exam Prep Questions
- Chapter 6. Database Maintenance
- SQL Server 2005 Database Maintenance
- Performing Database Backups
- Restoring Data from a Backup
- Using Database Snapshots
- Automating Maintenance with Job Scheduling
- Exam Prep Questions
- Answers to Exam Prep Questions
- Chapter 7. Monitoring SQL Server Performance
- SQL Server Management Studio
- Monitoring and Recording Performance
- Using Windows System Monitor
- Using SQL Server Profiler
- Exam Prep Questions
- Answers to Exam Prep Questions
- Chapter 8. Troubleshooting and Optimizing SQL Server
- Data Analysis and Problem Diagnosis
- Tuning the Database Structure
- Server Configuration Maintenance
- Exam Prep Questions
- Answers to Exam Prep Questions
- Chapter 9. Implementing High Availability
- High-Availability Solutions
- Using Replication
- Microsoft Analysis Services
- Exam Prep Questions
- Answers to Exam Prep Questions
- Chapter 10. Practice Exam 1
- Exam Questions
- Chapter 11. Answers to Practice Exam 1
- Question 1
- Question 2
- Question 3
- Question 4
- Question 5
- Question 6
- Question 7
Similar products
MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431)
MCITP Administrator: MicrosoftSQL Server2005 Database Server Infrastructure Design Study Guide (Exam 70-443)
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)
MCTS Self-Paced Training Kit (Exam 70-432): Microsoftu00ae SQL Serveru00ae 2008 Implementation and Maintenance (Pro-Certification)