MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation,9780789729972

MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation

by ;
Edition: CD
ISBN13: 9780789729972
ISBN10: 0789729970
Format: Paperback w/CD
Pub. Date: 2003-01-01
Publisher(s): Que
List Price: $59.99

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $99.08

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

This self-study Training Guide is organized according to the actual 70-229 objectives, equipping you with the knowledge you need to pass this exam, which measures your ability to complete the tasks required by a database professional by concentrating on subjects such as database normalization and denormalization; SQL Server data types; heterogeneous database connectivity; replication; user-defined data types and functions; Transact-SQL; XML; stored procedures and extended stored procedures; trigger rules; constraints; defaults; and performance tuning. All of these subjects are applicable to the exam and the tasks of the SQL Server database designer or administrator. Book jacket.

Table of Contents

Exam Preparation
Introducing SQL Server 2000p. 11
Introductionp. 14
Getting to Know SQL Server 2000p. 14
Structured Query Language (SQL)p. 19
The Complete SQL Server 2000 Softwarep. 23
Books Onlinep. 35
SQL Server 2000 Limitationsp. 40
SQL Server 2000 Versionsp. 41
Database Design for SQL Server 2000p. 53
Introductionp. 56
A Case Scenario Approachp. 57
Entity Relationship Modelingp. 59
Designing Entity Keysp. 68
Understanding Database Normalizationp. 75
Maintaining Data Integrityp. 80
The Client/Server Modelp. 91
Physical Database Design and Implementationp. 107
Introductionp. 110
Creating and Altering Databasesp. 111
Creating and Altering Database Objectsp. 129
Multiple Server Implementationsp. 158
Troubleshooting SQL Server Objectsp. 161
Querying and Modifying Datap. 191
Introductionp. 193
Data Retrievalp. 193
Filtering and Formatting Datap. 203
Data Summaryp. 217
Making Data Modificationsp. 231
Advanced Data Retrieval and Modificationp. 249
Retrieve and Filter Data Using Transact-SQLp. 252
Grouping Data with Transact-SQLp. 271
Summarizing Data with Transact-SQLp. 280
Manipulating Heterogeneous Data with OPENQUERY, OPENROWSET, and Linked Serversp. 285
Extracting Data into XMLp. 293
Using OPENXML to Read XML Datap. 299
Importing and Exporting Datap. 304
Programming SQL Server 2000p. 329
Introductionp. 332
Scripts, Batches, and Transactionsp. 332
Working with Variablesp. 334
Commentsp. 343
Statement Blocks with BEGIN...ENDp. 345
Conditional Statements and Branching with IF...THEN...ELSEp. 346
WHILE loopsp. 349
Managing Result Sets by Using Cursors and Transact-SQLp. 351
Concurrency and Lockingp. 360
Enforcing Procedural Business Logic Using Transactionsp. 364
Managing Data Manipulation Using Transactionsp. 370
Implementing Securityp. 372
Working with Viewsp. 389
Introductionp. 392
Understanding Viewsp. 393
Create and Alter Viewsp. 396
Modifying Data Through Viewsp. 414
Alter Database Objects to Support Partitioned Viewsp. 424
Control Data Access by Using Viewsp. 429
Triggersp. 445
Introductionp. 448
Constraining Data Modificationsp. 449
Triggersp. 454
Trigger Actions and Orderp. 468
Security Implications with Triggersp. 483
Troubleshooting Triggersp. 487
Stored Procedures and User-Defined Functionsp. 505
Introductionp. 508
Managing Data Manipulation Using Stored Proceduresp. 508
Calling Stored Procedures; Passing and Returning Parameters To and From Stored Proceduresp. 516
Enforcing Procedural Business Logic with Stored Proceduresp. 524
Filtering Data Using Stored Proceduresp. 527
Implementing Error Handling in Stored Proceduresp. 529
Managing Data Manipulation with User-Defined Functionsp. 532
Passing and Returning Parameters To and From User-Defined Functionsp. 541
Enforcing Procedural Business Logic Using User-Defined Functionsp. 542
Filtering Data with User-Defined Functionsp. 543
Implementing Error Handling in User-Defined Functionsp. 544
Boosting Performance with Indexesp. 557
Introductionp. 560
Overview of Indexingp. 560
Creating and Altering Indexesp. 571
Index Maintenancep. 579
Indexed Viewsp. 591
Full-Text Searchesp. 596
Implementing and Understanding Replication Methodologiesp. 617
Introductionp. 620
Replicationp. 620
Benefits of Replicationp. 621
Understanding Replication Components: The Publisher/Subscriber Metaphorp. 622
Replication Configurationsp. 626
Types of Replicationp. 632
Replication Agentsp. 640
Replication Internalsp. 644
Updating Subscribersp. 649
Heterogeneous Interoperabilityp. 652
Enabling Replication in Your Applicationp. 653
Configuring the Distribution Serverp. 654
Monitoring and Tuning SQL Server Databasesp. 673
Introductionp. 676
Tools Available for Monitoring and Tuningp. 677
Optimizing the OS Configurationp. 694
Optimizing SQL Server Configurationp. 704
Monitor Activity with the Profilerp. 714
Trace Playback and Diagnosisp. 723
SQL Server Optimizerp. 727
Securing Objectsp. 743
Final Review
Fast Factsp. 757
SQL Server 2000 Requirementsp. 759
Database Design for SQL Server 2000p. 760
Physical Database Design and Implementationp. 763
Querying and Modifying Datap. 767
Advanced Data Retrieval and Modificationp. 769
Programming SQL Server 2000p. 772
Working with Viewsp. 777
Use of Triggersp. 778
Stored Procedures and User-Defined Functionsp. 779
Boosting Performance with Indexesp. 780
Implementing and Understanding Replication Methodologiesp. 781
Study and Exam Prep Tipsp. 785
Learning Stylesp. 785
Study Tipsp. 786
Exam Prep Tipsp. 787
Final Considerationsp. 798
Practice Examp. 799
Exam Questionsp. 800
Answers to Exam Questionsp. 815
Appendixes
Glossaryp. 825
Overview of the Certification Processp. 837
Types of Certificationp. 837
Certification Requirementsp. 838
What's on the CD-ROMp. 843
PrepLogic Practice Tests, Preview Editionp. 843
Using the PrepLogic Practice Tests, Preview Edition Softwarep. 845
Exam Simulationp. 845
Question Qualityp. 845
Interface Designp. 845
Effective Learning Environmentp. 845
Software Requirementsp. 846
Installing PrepLogic Practice Tests, Preview Editionp. 846
Using PrepLogic Practice Tests, Preview Editionp. 846
Get More Examsp. 848
Customer Servicep. 849
Indexp. 851
Table of Contents provided by Rittenhouse. All Rights Reserved.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.