Table of Contents

MCTS 70-431: Implementing and Maintaining Microsoft® SQL Server 2005
By Thomas Moore
...............................................
Publisher: Que
Pub Date: July 31, 2006
Print ISBN-10: 0-7897-3588-1
Print ISBN-13: 978-0-7897-3588-1
Pages: 456

Table of Contents  | Index

		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
			Question 8
			Question 9
			Question 10
			Question 11
			Question 12
			Question 13
			Question 14
			Question 15
			Question 16
			Question 17
			Question 18
			Question 19
			Question 20
			Question 21
			Question 22
			Question 23
			Question 24
			Question 25
			Question 26
			Question 27
			Question 28
			Question 29
			Question 30
			Question 31
			Question 32
			Question 33
			Question 34
			Question 35
			Question 36
			Question 37
			Question 38
			Question 39
			Question 40
		Chapter 12.  Practice Exam 2
			Exam Questions
		Chapter 13.  Answers to Practice Exam 2
			Question 1
			Question 2
			Question 3
			Question 4
			Question 5
			Question 6
			Question 7
			Question 8
			Question 9
			Question 10
			Question 11
			Question 12
			Question 13
			Question 14
			Question 15
			Question 16
			Question 17
			Question 18
			Question 19
			Question 20
			Question 21
			Question 22
			Question 23
			Question 24
			Question 25
			Question 26
			Question 27
			Question 28
			Question 29
			Question 30
			Question 31
			Question 32
			Question 33
			Question 34
			Question 35
			Question 36
			Question 37
			Question 38
			Question 39
			Question 40
		Appendix A.  Suggested Readings and Resources
			Chapter 1: Installing and Configuring SQL Server 2005
			Chapter 2: Creating Database Objects
			Chapter 3: Implementing Database Objects
			Chapter 4: Supporting the XML Framework
			Chapter 5: Data Consumption and Throughput
			Chapter 6: Database Maintenance
			Chapter 7: Monitoring SQL Server Performance
			Chapter 8: Troubleshooting and Optimizing SQL Server
			Chapter 9: Implementing High Availability
		Appendix B.  Accessing Your Free MeasureUp Practice Test
		Appendix C.  MeasureUp's Product Features
			Multiple Testing Modes
			Question Types
			Random Questions and Order of Answers
			Detailed Explanations of Correct and Incorrect Answers
			Attention to Exam Objectives
			Technical Support
		Glossary
		Index