MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam View Larger Image | Thomas Moore
Que, Paperback, Published August 2006, 448 pages, ISBN 0789735881 | List Price: $34.99
Our Price: $22.50
You Save: $12.49 (36% Off)
| | | Availability: In-Stock |
Read an excerpt:
Chapter 4: Supporting the XML Framework
Reprinted with permission from Que Publishing. Copyright © Pearson Education, Que Publishing. Written permission from the publisher is required for any use of this material.
|
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - MCTS Self-Paced Training Kit (Exam 70-236): Configuring Microsoft Exchange Server 2007; Orin Thomas, et al, $32.95, 45% Off!
- MCTS Self-Paced Training Kit: Microsoft SQL Server 2005 Implementation and Maintenance (Exam 70-431); Solid Quality Learning, $32.95, 45% Off!
- MCTS: Microsoft SQL Server 2005 Implementation and Maintenance Study Guide (70-431); Joseph L. Jorden, et al, $30.95, 38% Off!
- MCTS Self-Paced Training Kit (Exam 70-536): Microsoft .NET Framework 2.0 Application Development Foundation; Shawn Wildermuth, et al, $38.25, 45% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
The MCTS 70-431 Exam Cram is a must-have resource in your MCTS 70-431
exam preparation. The Exam Cram focuses on exactly what you need
to know to get certified. This includes features like:
- Complete coverage of all 70-431 exam objectives
- Exam alerts, practice questions, notes, tips, sidebars, cautions, test-taking
strategies, and time-saving tips
- Access to MeasureUp practice questions and innovative testing software
- The popular Cram Sheet tear card, giving you the key facts you should
review before you enter the testing center
- Insight from author Thomas Moore, a Microsoft Certified
Trainer (MCT) and SQL Server expert who has helped hundreds of students
earn their SQL Server certifications
Table of Contents
Introduction
Self Assessment
Chapter 1: Installing and Configuring SQL Server
2005
Installing and Configuring SQL Server 2005
Installation Requirements
The Installation Process
Installation Preparations
Postinstallation Procedures
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 2: Creating Database Objects
Creating and Defining Databases
Using T-SQL to Create and
Alter a Database
The Makeup of a Database
Standard Views, Indexed Views,
and Partitioned Views
Miscellaneous SQL Server
Objects
Defining SQL Server Tables
Using Types and Schemas
Using Columns with Automated
or Calculated Values
Maintaining Order by Using
Indexes
Primary/Foreign Keys and
Relationships
Using Cascading Actions
Using DML and DDL Triggers
Partitioning Tables
Creating Partitioned Tables
SQL Server Programmability Objects
Stored Procedures
Creating CHECK Constraints
Creating Your Own Functions
English Query Capabilities
with Full-Text Catalogs
Objects with Security Context
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 3: Implementing Database Objects
Data Querying and Reporting
Listing the Contents of a
Table
Making a Report More Presentable
Querying a Sampling of the
Data Stored
Relating Data from Multiple
Tables
Applying Conditional Data
Filtering
Data Querying Using Full-Text Indexes
Creating and Populating a
Catalog
Using System Tables and Views
Getting Information from
System Tables
Information Retrieval from
System Stored Procedures
Using Dynamic Management
Views and Other System Views
Inserting Data
Using UDT and the CLR to
Control Data Input
Using the CLR Within Stored
Procedures
Inserting Individual Records
Using a Query to Insert Complete
Recordsets
Disabling Functionality During
Data Insertion
Changing What Is Already Stored
Updating a Single Record
Doing Updates That Affect
Multiple Records
Performing Transaction Processing
Upgrading Data from Previous
Releases of SQL Server
Removing Unwanted Data
Directly Removing Records
from a Table
Indirectly Removing Data
from a Table
Escalating Privileges to
Allow Deletion
Controlling Privileges by
Using GRANT, DENY, and REVOKE
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 4: Supporting the XML Framework
Managing XML Data
Newly Supported XML Features
XML: The Basics
The xml Data Type and Methods
XML Method Interactions
Other SQL Server XML Support
Indexing XML Data
Creating Primary and Secondary
Indexes
Native XML Web Service Support
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 5: Data Consumption and Throughput
Importing and Exporting Data
Using the Bulk Copy Program
(BCP)
Using OPENROWSET for Importing
Data
Using SQL Server Integration
Services (SSIS)
Implementing Service Broker
Designing a Service
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 6: Database Maintenance
SQL Server 2005 Database Maintenance
What's New in SQL Server
Maintenance?
Performing Database Backups
Recovery Models and Backups
Recovery Models Using T-SQL
Backup Types and Scenarios
Setting the Options of a
Backup
Options of the T-SQL BACKUP
Statement
Restoring Data from a Backup
Using the T-SQL RESTORE Statement
Using Database Snapshots
Creating and Deleting Database
Snapshots
Automating Maintenance with Job Scheduling
Viewing Job Details and History
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 7: Monitoring SQL Server Performance
SQL Server Management Studio
Monitoring and Recording Performance
Using Activity Monitor for
the Here and Now
Management Studio: Log File
Viewer
Server-Maintained Information
Using Windows System Monitor
Using SQL Server Profiler
Defining a Profiler Trace
Using Profiler Traces to
Diagnose Locking
Trace Playback and Diagnosis
Using Profiler to Gather
a Workload
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 8: Troubleshooting and Optimizing SQL
Server
Data Analysis and Problem Diagnosis
Tuning the Operating System
and Hardware
Creating and Maintaining
Statistics
Locks, Blocks, and Deadlocks
Tuning the Database Structure
Indexing Strategies
Data Partitioning Across
Servers
Using the DTA
Server Configuration Maintenance
Using the Database Console
Command (DBCC)
Setting Alerts to Automate
Problem Identification
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 9: Implementing High Availability
High-Availability Solutions
Implementing Log Shipping
Using Database Mirroring
Using Failover Clustering
Using Replication
Replication Strategies
Types of Replication
Elements of 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
Chapter 12: Practice Exam 2
Exam Questions
Chapter 13: Answers to Practice Exam 2
Appendix A: Suggested Readings and Resources
Appendix B: Accessing Your Free MeasureUp
Practice Test
Appendix C: MeasureUp's Product Features
Glossary
About the Author
Thomas Moore, MCSE, MCSE, MCDBA, MCT, CTT, has been in
the computer industry for more than 20 years. Thomas has a wide variety of expertise
in all hardware environments and with most Microsoft Server products. "My
first and lasting love, besides my wife and family, however, is programming."
Thomas is comfortable in any programming language environment, achieving his
MCSD and MCDBA certifications from their inception. Over the past 12 years he
has been working for a variety of Microsoft partners and currently is a Systems
Analyst for TechServices Web Development Group in Fort Wayne, Indiana, where
he has been for the past three years. Thomas enjoys staying up-to-date, although
like most of us, he finds it a challenge to keep up with the pace of the industry.
Thomas's most recent certification achievements include being one of the first
Windows 2000 MCSEs in the world and achieving the same standard as a SQL Server
2000 MCDBA.
|
