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

Name: MCDBA SQL Server 2000 Database Design Study Guide (Exam 70-229)
Availability: OutOfStock
ISBN: 9780072126945

ISBN-10: 0072126949

ISBN-13: 9780072126945

Edition: 2001 (Student Manual, Study Guide, etc.)

Authors: Anil F. Desai, Jeffrey Bane, Craig Robinson

List price: $49.99

30 day, 100% satisfaction guarantee!

Out of stock

We're sorry. This item is currently unavailable.

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Book details

List price: $49.99
Copyright year: 2001
Publisher: McGraw-Hill Osborne
Publication date: 10/18/2001
Binding: Mixed Media
Pages: 608
Size: 7.50" wide x 9.25" long x 1.75" tall
Weight: 2.882
Language: English

Anil Desai, MCSE, MCSD, MCDBA, is Technical Architect for QuickArrow, Inc., in Austin, Texas. He has consulted for several companies, ranging from small startups to multinational organizations. Anil is the author of Windows NT Network Management: Reducing Total Cost of Ownership and MCSE: Windows 2000 Directory Services Implementation Exam Guide, and co-author of MCSE Fast Track: SQL Server 7 Administration.

Foreword	p. v
About the Contributors	p. ix
Acknowledgments	p. xi
Preface	p. xxiii
Introduction	p. xxix
An Overview of SQL Server 2000	p. 1
Understanding Relational Databases	p. 3
SQL Server Architecture	p. 14
Working with SQL Server 2000	p. 35
Developing SQL Server Applications	p. 42
SQL Server 2000 Analysis Services	p. 45
QandA
Developing a Logical Database Design	p. 55
Defining Entities and Attributes	p. 57
Entity Composition and Normalization	p. 66
Designing for Referential Integrity	p. 82
Managing Entity Relationships	p. 88
Attribute and Domain Integrity	p. 100
QandA
Implementing a Database	p. 129
Planning for Storage Management	p. 130
Implementing the Physical Database	p. 135
Ensuring Data Integrity	p. 149
QandA	p. 160
Programming Business Logic	p. 169
Implementing Advanced Database Objects	p. 170
Implementing Advanced Database Features	p. 188
QandA	p. 207
Manipulating Data Using Transact-SQL	p. 217
Overview of Coding SQL Queries	p. 218
Retrieving Data Using Transact-SQL	p. 243
QandA	p. 274
Tuning and Optimizing Database Performance	p. 285
Monitoring and Optimizing Server Performance	p. 287
Monitoring Database Activity with SQL Profiler	p. 298
Designing and Implementing Indexing	p. 307
Optimizing Queries with SQL Query Analyzer	p. 318
QandA	p. 334
Transferring Data Between Systems	p. 345
Importing and Exporting Data	p. 346
Working with External Servers	p. 365
XML Functionality	p. 372
QandA	p. 399
Designing and Implementing Database Security	p. 409
Understanding and Implementing SQL Server Security	p. 410
Implementing Database-Level Security	p. 420
Implementing Object-Level Security	p. 430
Controlling Data Access	p. 437
QandA	p. 450
About the CD	p. 459
Installing CertTrainer	p. 460
CertTrainer	p. 460
ExamSim	p. 461
E-Book	p. 461
CertCam	p. 461
Help	p. 462
Upgrading	p. 462
About the Web Site	p. 463
Get What You Want When You Want It	p. 464
Glossary	p. 465
Index	p. 493
Table of Contents provided by Syndetics. All Rights Reserved.