MCSE/MCSD: SQL Server 7 Database Design Study Guide

Be the first to write a review

Overview

Here's the book you need to prepare for Exam 70-029, Designing and Implementing Databases with Microsoft SQL Server 7.0.
This ...
See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Hardcover)
  • All (5) from $1.99   
  • New (2) from $35.99   
  • Used (3) 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
$35.99
surplus computer books
Seller since Tue Jan 01 01:01:01 EST 2008

Feedback rating:

(171)

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
0782125867 BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$45.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)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

More About This Book

Overview

Here's the book you need to prepare for Exam 70-029, Designing and Implementing Databases with Microsoft SQL Server 7.0.
This Microsoft Certified Professional Approved Study Guideprovides:
  • Full coverage of every exam objective-all the information you need to know
  • Lots of challenging review questions, in the book and on the CD
  • Practical information on designing and implementing a SQL Server database in the real world
    Authoritative coverage of critical exam topics, including:
  • Developing a logical data model
  • Applying normalization rules
  • Incorporating business rules into the data model
  • Deriving the physical design
  • Creating data services
  • Accessing data using the dynamic SQL model
  • Accessing data using the stored procedure model
  • Creating a physical database
  • Creating and managing files, file groups, and transaction logs
  • Populating the database with data from an external source
  • Maintaining a database
  • Evaluating and optimizing query execution plan performance
  • Diagnosing and resolve locking problems
  • Identifying SQL Server events and performance problems

Featured on the CD
The enclosed CD contains exclusive exam-preparation software that lets you test your knowledge of the material under exam conditions.
Read More Show Less

Product Details

  • ISBN-13: 9780782125863
  • Publisher: Wiley, John & Sons, Incorporated
  • Publication date: 9/1/1999
  • Series: MCSD Certification Series
  • Edition description: Student Manual, Study Guide, etc.
  • Pages: 656
  • Product dimensions: 7.87 (w) x 9.33 (h) x 1.91 (d)

Table of Contents

Introduction
Chapter 1 An Introduction to SQL Server 7
Chapter 2 Data Modeling
Chapter 3 System Databases and Tables
Chapter 4 Data Definition
Chapter 5 Data Retrieval
Chapter 6 Advanced Data Retrieval Techniques
Chapter 7 Creating Action Queries with Transact-SQL to Modify Data
Chapter 8 Using Indexes
Chapter 9 Designing and Using Views
Chapter 10 Programmability
Chapter 11 Triggers
Chapter 12 Maintaining a Database
Appendix A Review Questions and Answers
Index
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)
Sort by: Showing all of 2 Customer Reviews

  • Anonymous

    Posted Wed Apr 19 00:00:00 EDT 2000

    No joy here

    The error-filled text can only appear good when compared to the ambiguous sample tests. You can learn the basics with this book, but you'll have to buy another to pass the test. Also, there is no sample database on the CD. A VERY sub-par effort.

    Was this review helpful? Yes  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.

  • Anonymous

    Posted Fri Jan 14 00:00:00 EST 2000

    Poor prep for exam review

    This book covers most of the material required for Exam 70-029. However if it was all you based your preparation on I am afraid you would fail. Many of the test questionas could not be answered from this book. Additionally the book is fraught with errors, including incorrect answers to the review questions. On a positive note it was simple to understand and follow.

    0 out of 1 people found this review helpful.

    Was this review helpful? Yes  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.
Sort by: Showing all of 2 Customer Reviews
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)