Cover image for MCSE Microsoft SQL server 2000 database design and implementation readiness review, exam 70-229
Title:
MCSE Microsoft SQL server 2000 database design and implementation readiness review, exam 70-229
Author:
Bjeletich, Sharon.
Personal Author:
Publication Information:
Redmond, Wash. : Microsoft Press, [2001]

©2001
Physical Description:
xix, 232 pages : illustrations ; 23 cm + 1 computer optical disc (4 3/4 in.).
Language:
English
Title Subject:
Added Author:
ISBN:
9780735612518
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.9.D3 B58 2001 Book and Software Set Central Closed Stacks
Searching...

On Order

Summary

Summary

Microsoft Certified Professional (MCP) Exam 70-229 measures ability to design and implement database solutions using Microsoft SQL Server 2000 Enterprise Edition. With Readiness Review, certification candidates can sharpen their test-taking skills, save valuable time and money, and build their confidence for the real exam with the help of this exclusive MCP exam simulation on CD-ROM. The Readiness Review electronic assessment tool delivers randomly generated, 50-question practice tests covering actual MCP exam objectives. Readers can test and retest with different question sets each time. After completing practice sessions, readers can consult the companion text for helpful explanations for all responses -- right and wrong -- and to identify areas for further study.


Table of Contents

Welcome to Microsoft SQL Server 2000 Database Design and Implementationp. vii
Before You Beginp. viii
Using the MCSE Readiness Reviewp. x
Exam Objectives Summaryp. xvi
Getting More Helpp. xviii
Objective Domain 1 Developing a Logical Data Modelp. 1
Tested Skills and Suggested Practicesp. 1
Further Readingp. 3
Objective 1.1 Define entitiesp. 7
Objective 1.2 Design entity keysp. 15
Objective 1.3 Design attribute domain integrityp. 25
Objective Domain 2 Implementing the Physical Databasep. 35
Tested Skills and Suggested Practicesp. 36
Further Readingp. 37
Objective 2.1 Create and alter databasesp. 39
Objective 2.2 Create and alter database objectsp. 49
Objective 2.3 Alter database objects to support replication and partitioned viewsp. 63
Objective 2.4 Troubleshoot failed object creationp. 73
Objective Domain 3 Retrieving and Modifying Datap. 79
Tested Skills and Suggested Practicesp. 80
Further Readingp. 82
Objective 3.1 Import and export datap. 85
Objective 3.2 Manipulate heterogeneous datap. 91
Objective 3.3 Retrieve, filter, group, summarize, and modify data by using Transact-SQLp. 97
Objective 3.4 Manage result sets by using cursors and Transact-SQLp. 109
Objective 3.5 Extract data in XML formatp. 115
Objective Domain 4 Programming Business Logicp. 121
Tested Skills and Suggested Practicesp. 122
Further Readingp. 123
Objective 4.1 Manage data manipulation by using stored procedures, transactions, triggers, user-defined functions, and viewsp. 127
Objective 4.2 Enforce procedural business logic by using stored procedures, transactions, triggers, user-defined functions, and viewsp. 139
Objective 4.3 Troubleshoot and optimize programming objectsp. 149
Objective Domain 5 Tuning and Optimizing Data Accessp. 155
Tested Skills and Suggested Practicesp. 156
Further Readingp. 157
Objective 5.1 Analyze the query execution planp. 159
Objective 5.2 Capture, analyze, and replay SQL Profiler tracesp. 165
Objective 5.3 Create and implement indexing strategiesp. 171
Objective 5.4 Improve index use by using the Index Tuning Wizardp. 175
Objective 5.5 Monitor and troubleshoot database activity by using SQL Profilerp. 181
Objective Domain 6 Designing a Database Security Planp. 187
Tested Skills and Suggested Practicesp. 188
Further Readingp. 188
Objective 6.1 Control data access by using stored procedures, triggers, user-defined functions, and viewsp. 191
Objective 6.2 Define object-level security including column-level permissions by using GRANT, REVOKE, and DENYp. 197
Objective 6.3 Create and manage application rolesp. 203
Glossaryp. 209
Indexp. 225

Google Preview