Exam Prep: MSCE Database DEsign on SQL Server 7

Be the first to write a review

Overview

Provides the reader a thorough understanding and knowledge of SQL Server's data architecture, query techniques, and methods on implementing data integrity. Describes the programming language Transact-SQL's most important commands, indexes, stored procedures, and triggers. Key technologies covered include: data modeling, process modeling, physical database design and implementation, query design, execution and optimization, and protecting data by using SQL Server's security features. Includes sample questions, ...
See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Paperback)
  • All (8) from $1.99   
  • New (1) from $125.0   
  • Used (7) 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
$125.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)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

More About This Book

Overview

Provides the reader a thorough understanding and knowledge of SQL Server's data architecture, query techniques, and methods on implementing data integrity. Describes the programming language Transact-SQL's most important commands, indexes, stored procedures, and triggers. Key technologies covered include: data modeling, process modeling, physical database design and implementation, query design, execution and optimization, and protecting data by using SQL Server's security features. Includes sample questions, reviews of terminology and tools, and resources for additional reading and study. Jam-packed with hands-on projects and real-world case projects; provides comprehensive coverage of the curriculum objectives for Designing and Implementing Databases with Microsoft SQL Server 7, Exam 70-029. The number of applications being developed for SQL Server has quadrupled in the last 18 months. MCSE Designing Databases on SQL Server 7 Exam Prep and its companion CD offer a unique learning and study experience because unlike competing products, the practice exams are based on the content of the book. Complete Certification Insider Press's interactive learning system with MCSE Database Design on SQL Server 7 Exam Cram. An exam simulation environment commissioned specially for Certification Insider Press's Exam Preps featuring questions formatted like those on the actual exam. Two complete practice exams on the Exam Prep CD offer questions based on the content of the book to enhance the learning experience by reinforcing concepts and practical applications.
Read More Show Less

Product Details

  • ISBN-13: 9781576105191
  • Publisher: Coriolis Group
  • Publication date: 10/28/1999
  • Series: Exam Prep Ser.
  • Pages: 755
  • Product dimensions: 7.36 (w) x 9.22 (h) x 1.82 (d)

Table of Contents

Introduction
Chapter 2: SQL Database Architecture
Chapter 3: Developing A Logical Database Design
Chapter 4: Deriving The Physical Design
Chapter 5: Tables
Chapter 6: Indexes
Chapter 7: Retrieving And Modifying Data
Chapter 8: Transact-SQL Scripting And Command Batches
Chapter 9: Summarizing And Transforming Data
Chapter 10: Views
Chapter 11: Transactions And Locking
Chapter 12: Stored Procedures
Chapter 13: Triggers
Chapter 14: Creating The Physical Database
Chapter 15: Remote Data Sources
Chapter 16: Data Transfers
Chapter 17: Implementing Full-Text Search
Chapter 18: Maintaining A Database
Chapter 19: Diagnosing Problems And Improving
Appendix A: Design On SQL Server 7 Exam Objectives
Appendix B: MCSE Requirements
Glossary
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 3 Customer Reviews

  • Anonymous

    Posted Fri May 26 00:00:00 EDT 2000

    Excellent Source

    I definitely agree with other reviewers. This is an excellent source for the MCP 70-029 exam as well as a very handy desk-top reference. The review questions at the end of each chapter were very helpful in preparing for my exam.

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

  • Anonymous

    Posted Wed Mar 29 00:00:00 EST 2000

    Excellent prep source

    Well written book. Anyone thinking about taking the test should also get the Transcender CD to get the clearer idea on what subjects to concentrate on. The contents of this book well cover the entire test and beyond. I am still using it in the real world as a reference.

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

  • Anonymous

    Posted Thu Mar 09 00:00:00 EST 2000

    MONEY WELL SPENT

    Why buy an exam cram style book for SQL Server when this one is available? I passed the 70-29 exam (supposedly one of Microsoft's most difficult) using this book as my primary reference. But since it is much more thorough than a typical Exam Cram, I now have a good desktop reference as well! Although it would be nice to see Replication adddressed, I think that is covered by exam 70-28, not 70-29. Overall, I couldn't be much happier with this book. If you buy it, I don't think you will be disappointed!

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