Table of Contents


book cover
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



MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net