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

Be the first to write a review

Overview

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
Read More Show Less
... See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Hardcover)
  • All (9) from $1.99   
  • New (3) from $70.0   
  • Used (6) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$70.00
bluehouse
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$70.00
bluehouse
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$73.44
Books Revisited
Seller since Tue Oct 07 09:35:53 EDT 2014

Feedback rating:

(294)

Condition: New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

More About This Book

Overview

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
Read More Show Less

Product Details

Table of Contents

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

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)