Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Best Books of the Year | December 9, 2014

    Aubrey: IMG Best YA Fiction of 2014



    So what is with all the hullabaloo about young adult literature these days? Do we have John Green to blame for getting us sucked in to the tragic... Continue »

    spacer
Qualifying orders ship free.
$12.00
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Local Warehouse COMP- LANG A- Z

McTs 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam (Exam Cram)

by

McTs 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam (Exam Cram) Cover

 

Synopses & Reviews

Publisher Comments:

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

Book News Annotation:

This study guide for Microsoft SQL Server implementation and maintenance exam # 70-431 reviews procedures for configuring an enterprise server, creating database objects, managing XML data, importing data, backing up and restoring databases, monitoring performance, tuning the database structure, and increasing availability. Two practice tests round out the book.
Annotation 2006 Book News, Inc., Portland, OR (booknews.com)

Book News Annotation:

This study guide for Microsoft SQL Server implementation and maintenance exam # 70-431 reviews procedures for configuring an enterprise server, creating database objects, managing XML data, importing data, backing up and restoring databases, monitoring performance, tuning the database structure, and increasing availability. Two practice tests round out the book. Annotation ©2006 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

This study guide is a must-have resource for MCTS 70-431 exam preparation, focusing on exactly what candidates need to know to get certified. It includes coverage of all 70-431 exam objectives, exam alerts, practice questions (including two full practice exams in the book and another on CD), notes, tips, sidebars, cautions, test-taking strategies, and timesaving tips.

Synopsis:

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

About the Author

Thomas R. Moore, MCITP, MCTS, MCSE, MCSA, MCSD, MCDBA, MCP, MCT, CSE, CTT+, has been in the computer industry for more than 25 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, of course, however, is database programming,” he says. Thomas is comfortable in any programming language environment. He achieved his MCSD and MCDBA certifications from their inception; completed the Microsoft CSE certification as a certified software engineer with Dexterity and Microsoft Business Solutions products; and, most recently, completed the new Microsoft Certifications for MCITP and MCTS on SQL Server 2005. Over the past 20 years, he has been working for a variety of Microsoft partners, and he is currently an intermediate developer/technical consultant with Diamond Municipal Solutions in Paris, Ontario, where he has been for the past four years. Among his myriad IT certifications, Thomas also holds certifications in English and business/technical writing. 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.

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

 

0789735881  TOC   7/13/2006

Product Details

ISBN:
9780789735881
Author:
Moore, Thomas
Publisher:
Que
Subject:
Examinations
Subject:
Database Management - SQL Server
Subject:
Database design
Subject:
Certification Guides - General
Subject:
Technical Skills
Subject:
Electronic data processing personnel
Subject:
Microsoft software - Examinations
Subject:
Computers-Reference - General
Copyright:
Edition Description:
Trade paper
Series:
Exam Cram 2
Publication Date:
20060731
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Y
Pages:
456
Dimensions:
9.00x6.06x.80 in. .96 lbs.

Other books you might like

  1. MCTS Self-Paced Training Kit (Exam... Used Hardcover $2.50

Related Subjects


Computers and Internet » Computer Languages » The Attic
Computers and Internet » Computers Reference » General
Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management

McTs 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam (Exam Cram) Used Trade Paper
0 stars - 0 reviews
$12.00 In Stock
Product details 456 pages Que - English 9780789735881 Reviews:
"Synopsis" by , This study guide is a must-have resource for MCTS 70-431 exam preparation, focusing on exactly what candidates need to know to get certified. It includes coverage of all 70-431 exam objectives, exam alerts, practice questions (including two full practice exams in the book and another on CD), notes, tips, sidebars, cautions, test-taking strategies, and timesaving tips.
"Synopsis" by , 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
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.