MCSE Fast Track : SQL Server 7 Database Design

Be the first to write a review

Overview

The Fast Track series already covers the four core exams and two of the most popular electives, passing all of which earn the candidate MCSE status. SQL Server 7 Database Design adds to the growing list of popular MCSE electives offered in Fast Track format. This book also expands coverage of MCSD exams under Microsoft's new revision of the MCSD track. Each book has two parts: Part I gets you ready for the test FAST, covering just what you need to know to pass the test. Part II takes you through the test and into...
See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Paperback)
  • All (3) from $33.99   
  • New (1) from $0.0   
  • Used (2) from $33.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$33.99
SUPER BOOKS
Seller since Tue Oct 07 09:42:27 EDT 2014

Feedback rating:

(55)

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.

Good
Buy with Confidence. Excellent Customer Support. We ship from multiple US locations. No CD, DVD or Access Code Included.

Ships from: Fort Mill, SC

Usually ships in 1-2 business days

  • •Standard, 48 States
$50.00
azure_books
Seller since Fri Jan 01 01:01:01 EST 2010

Feedback rating:

(6)

Condition: Like New
1999 Trade paperback Fine in fine dust jacket. Trade paperback (US). Glued binding. 378 p. Contains: Illustrations. MCSE Fast Track. Audience: General/trade. Standard shipping ... 2-4 business days to continental USA by UPS Express. No PO Box, APO or FPO address. If you are living outside of Continental US, please provide us your contact phone number after you place the order. The phone number will be use for UPS shipping purpose. We will have to cancel your order if you did not provide this essential information. Read more Show Less

Ships from: Diamond Bar, CA

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

The Fast Track series already covers the four core exams and two of the most popular electives, passing all of which earn the candidate MCSE status. SQL Server 7 Database Design adds to the growing list of popular MCSE electives offered in Fast Track format. This book also expands coverage of MCSD exams under Microsoft's new revision of the MCSD track. Each book has two parts: Part I gets you ready for the test FAST, covering just what you need to know to pass the test. Part II takes you through the test and into real-world use of the technology, with chapters on: Fast Facts Review Section: Digest of each chapter-ending 'What's Important-to-Know' section from Part I; Hotlists of Exam-Critical Concepts; Sample Test Questions: One question per key point made in the book; Insider's Spin: What Microsoft doesn't necessarily want you to know; Did You Know?: Invaluable real-world applications for the technology covered in the exam, taken from the author's training and consulting files.
Read More Show Less

Product Details

  • ISBN-13: 9780735700406
  • Publisher: Que
  • Publication date: 6/15/1999
  • Series: MCSE Fast Track Series
  • Pages: 352
  • Product dimensions: 6.01 (w) x 8.97 (h) x 0.91 (d)

Table of Contents

I. WHAT'S IMPORTANT TO KNOW ABOUT EXAM 70-029.

1. Developing a Logical Data Model.
Database Elements. Normalization Rules for Entity Definition. First Normal Form. Second Normal Form. Third Normal Form. Fourth and Fifth Normal Forms. Identification of Primary Keys. Foreign Key Selection and Referential Integrity. Business Rules and Data Integrity. Modeling Rules and Constraints. Denormalization. What Is Important to Know.

2. Deriving the Physical Design.
Performance. Maintainability. Extensibility. Scalability. Availability. Security. Physical Database Design. What Is Important to Know.

3. Creating Data Services.
The Syntax of Design. Dynamic SQL Model. Stored Procedures Model. Transact-SQL Cursors. Cursor Types. Cursor Selection. Resultset Size. Data Volatility. Cursor Features. Performance. Response. Sensitivity to Change. Cursor Navigation. Cursor Scope. Transaction Management. Explicit Transactions. Implicit Transactions. Distributed Transactions. Data Consistency. Atomicity. Consistency. Transaction Isolation. Service Durability. Recoverability. Automatic Database Recovery. Backup/Restore. Standby Servers. Checkpointing. Isolation. Share Locks. Update and Exclusive Locks. Intent Locks. Schema Locks. Implementing Locking. Lock Manager. Locking Configuration. Transaction Isolation. Read Committed. Read Uncommitted. Repeatable Read. Serializable. Using Isolation. Transaction Control. Bound Connections. Deadlocks. Avoiding Deadlocks. Locking. OptimisticLocking. Pessimistic Locking. @@trancount. SQL Standard Syntax. INSERT. DELETE. UPDATE. SELECT. Joins and Subqueries. Transact-SQL Scripts. Views. Stored Procedures. Triggers. Summarizing Data. Session Level Configuration. Accessing Data. CONTAINSTABLE. FREETEXTTABLE. Putting It All Together. Example: Conditional Error Check. Example: Referential Integrity. What Is Important to Know.

4. Creating a Physical Database.
Maintaining the Physical Implementation. File Management. Creating Database Files. Creating Filegroups. Managing Database Files. Managing Log Files. Maintaining Integrity. Data and Referential Integrity. Data Type Selection. User-Defined Data Types. NULL and NOT NULL. Generated Values. Constraint Implementation. Index Maintenance. Database Population. Full-Text Implementation. What Is Important to Know.

5. Maintaining a Database.
Optimizing and Tuning SQL Server Implementations. Execution Plans. Evaluation of Execution Plans. Optimizing Performance. Query Execution Plans. Evaluation of Query Plans. Optimizing Performance. Locking Problems. Locking Diagnosis. Resolving Locking Problems. SQL Server Profiler. Identifying Events Using Profiler. Putting It All Together. What Is Important to Know. Objective Review Notes.

II. INSIDE EXAM 70-029.

6. Fast Facts Review.
What to Study. Developing a Logical Data Model. Deriving the Physical Design. Creating Data Services. Creating a Physical Database. Maintaining a Database.

7. Insider's Spin on Exam 70-029.
Get into Microsoft's Mind-Set. Understand the Exam's Time Frame. Get Used to Answering Questions Quickly. Taking the Test. Where the Questions Come From. Different Flavors of Questions.

8. Hotlist of Exam-Critical Concepts.
9. Sample Test Questions.
Questions. Answers and Explanations.

10. Did You Know?
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)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)