Mcdba SQL Server 2000 Database Design Study Guide (Exam 70-229)

Mcdba SQL Server 2000 Database Design Study Guide (Exam 70-229)

Hardcover

$49.99 View All Available Formats & Editions

Temporarily Out of Stock Online

Eligible for FREE SHIPPING

Overview

Mcdba SQL Server 2000 Database Design Study Guide (Exam 70-229) by Jeffrey Bane, Craig Robinson, Anil Desai

Includes 100% complete coverage of all exam objectives, hundreds of practice questions, and hands-on exercisesThis exam is required for MCDBA certification and a popular elective for both the MCSE and MCSD certifications Previous edition sold more than XX,XXX copies CD-ROM contains CertTrainer software with interactive tutorials and lab simulations and ExamSim practice exam software

Product Details

ISBN-13: 9780072126945
Publisher: McGraw-Hill Companies, The
Publication date: 10/18/2001
Series: Microsoft Test Yourself Ser.: Mcsd/mcad/mcdba Ser.
Pages: 508
Product dimensions: 8.00(w) x 9.50(h) x 1.80(d)

Table of Contents

Forewordv
About the Contributorsix
Acknowledgmentsxi
Prefacexxiii
Introductionxxix
1An Overview of SQL Server 20001
Understanding Relational Databases3
SQL Server Architecture14
Working with SQL Server 200035
Developing SQL Server Applications42
SQL Server 2000 Analysis Services45
Q&A
2Developing a Logical Database Design55
Defining Entities and Attributes57
Entity Composition and Normalization66
Designing for Referential Integrity82
Managing Entity Relationships88
Attribute and Domain Integrity100
Q&A
3Implementing a Database129
Planning for Storage Management130
Implementing the Physical Database135
Ensuring Data Integrity149
Q&A160
4Programming Business Logic169
Implementing Advanced Database Objects170
Implementing Advanced Database Features188
Q&A207
5Manipulating Data Using Transact-SQL217
Overview of Coding SQL Queries218
Retrieving Data Using Transact-SQL243
Q&A274
6Tuning and Optimizing Database Performance285
Monitoring and Optimizing Server Performance287
Monitoring Database Activity with SQL Profiler298
Designing and Implementing Indexing307
Optimizing Queries with SQL Query Analyzer318
Q&A334
7Transferring Data Between Systems345
Importing and Exporting Data346
Working with External Servers365
XML Functionality372
Q&A399
8Designing and Implementing Database Security409
Understanding and Implementing SQL Server Security410
Implementing Database-Level Security420
Implementing Object-Level Security430
Controlling Data Access437
Q&A450
AAbout the CD459
Installing CertTrainer460
CertTrainer460
ExamSim461
E-Book461
CertCam461
Help462
Upgrading462
BAbout the Web Site463
Get What You Want When You Want It464
Glossary465
Index493

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews