Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
90 used & new from $0.07

Have one to sell? Sell yours here
 
   
MCAD/MCSE/MCDBA Self-Paced Training Kit: MicrosoftŪ SQL Server(TM) 2000 Database Design and Implementation, Exam 70-229, Second Edition (Pro-Certification)
 
 
Tell the Publisher!
I’d like to read this book on Kindle

Don’t have a Kindle? Get yours here.
 
  

MCAD/MCSE/MCDBA Self-Paced Training Kit: MicrosoftŪ SQL Server(TM) 2000 Database Design and Implementation, Exam 70-229, Second Edition (Pro-Certification) (Hardcover)

by Microsoft Corporation (Author) "This chapter introduces you to SQL Server 2000 by describing the components of SQL Server and explaining how those components work together to provide a..." (more)
Key Phrases: updateable partitioned view, inner stored procedure, local temporary stored procedure, Query Analyzer, Correct Answers, Books Online (more...)
2.8 out of 5 stars See all reviews (20 customer reviews)

List Price: $59.99
Price: $59.99 & this item ships for FREE with Super Saver Shipping. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Upgrade this book for $11.99 more, and you can read, search, and annotate every page online. See details
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Only 4 left in stock--order soon.

Want it delivered Tuesday, July 21? Choose One-Day Shipping at checkout. Details
31 new from $1.90 59 used from $0.07
More from Microsoft Press
Make the most of your investment in Microsoft technology with books from the Microsoft Press Learning Center.

Frequently Bought Together

Customers buy this book with MCSA/MCSE/MCDBA Self-Paced Training Kit: MicrosoftŪ SQL Server(TM) 2000 System Administration, Exam 70-228, Second Edition (Pro-Certification) by Microsoft Corporation

MCAD/MCSE/MCDBA Self-Paced Training Kit: MicrosoftŪ SQL Server(TM) 2000 Database Design and Implementation, Exam 70-229, Second Edition (Pro-Certification) + MCSA/MCSE/MCDBA Self-Paced Training Kit: MicrosoftŪ SQL Server(TM) 2000 System Administration, Exam 70-228, Second Edition (Pro-Certification)
Price For Both: $100.48

Show availability and shipping details


Customers Who Bought This Item Also Bought

MCAD/MCSD Self-Paced Training Kit: Microsoft (2nd Edition) .NET Core Requirements, Exams 70-305, 70-315, 70-306, 70-316, 70-310, 70-320, and 70-300 box vol. set

MCAD/MCSD Self-Paced Training Kit: Microsoft (2nd Edition) .NET Core Requirements, Exams 70-305, 70-315, 70-306, 70-316, 70-310, 70-320, and 70-300 box vol. set

by Microsoft Corporation
3.5 out of 5 stars (37)  $169.99
MCAD/MCSD Self-Paced Training Kit: Developing WindowsŪ-Based Applications with MicrosoftŪ Visual BasicŪ .NET and Microsoft Visual C#Ū .NET, Second Ed (Pro-Certification)

MCAD/MCSD Self-Paced Training Kit: Developing WindowsŪ-Based Applications with MicrosoftŪ Visual BasicŪ .NET and Microsoft Visual C#Ū .NET, Second Ed (Pro-Certification)

by Matthew A. Stoecker
3.2 out of 5 stars (60)  $45.73
MCAD/MCSD Self-Paced Training Kit: Developing Web Applications with MicrosoftŪ Visual BasicŪ .NET and Microsoft Visual C#Ū .NET, Second Edition (Pro-Certification)

MCAD/MCSD Self-Paced Training Kit: Developing Web Applications with MicrosoftŪ Visual BasicŪ .NET and Microsoft Visual C#Ū .NET, Second Edition (Pro-Certification)

by Jeff Webb
2.7 out of 5 stars (23)  $44.09
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)

by Solid Quality Learning
3.9 out of 5 stars (45)  $37.79
MicrosoftŪ ADO.NET Step by Step (Step By Step (Microsoft))

MicrosoftŪ ADO.NET Step by Step (Step By Step (Microsoft))

by Rebecca M. Riordan
Explore similar items

Editorial Reviews

Product Description
Learn how to design and implement database solutions using SQL Server 2000 Enterprise Edition--as you prepare for MCP Exam 70-229, a core requirement for MCDBA certification and an elective for the MCAD, MCSE, and MCSA tracks.

Product Details


Inside This Book (learn more)
First Sentence:
This chapter introduces you to SQL Server 2000 by describing the components of SQL Server and explaining how those components work together to provide a relational database management system (RDBMS). Read the first page
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
updateable partitioned view, inner stored procedure, local temporary stored procedure, book shop scenario, bulk copy data, server cursors, fixed server role, global temporary stored procedure, default result set, one application role, implicit transaction mode, second logical drive, foreign key constraint referencing, bcp command prompt utility, identifying system requirements, optimizing database performance, syscomments system table, virtual log files, data modification statements, isqlw utility, tabular result set, lazy schema validation, advanced query techniques, clustered index, lock timeout setting
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Query Analyzer, Correct Answers, Books Online, Object Browser, Lesson Summary, Enterprise Edition, Microsoft Windows, English Query, Open Table, Execute Mode, Analysis Services, Data Transformation Services, Microsoft Press, Manage Indexes, Microsoft Access, Number of Sales, Create Stored Procedure, Developer Edition, Meta Data Services, Create Database Wizard, Microsoft Excel, Server Agent, User-to-Activity Map, Microsoft Search, Selected Data
New!
Books on Related Topics | Concordance | Text Stats
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Search Inside This Book:



Books on Related Topics (learn more)
 
 


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below.

Your tags: Add your first tag
 
Help others find this product — tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

 

Customer Reviews

20 Reviews
5 star:
 (2)
4 star:
 (6)
3 star:
 (4)
2 star:
 (2)
1 star:
 (6)
 
 
 
 
 
Average Customer Review
2.8 out of 5 stars (20 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
26 of 27 people found the following review helpful:
1.0 out of 5 stars Sales book, not good for certification, June 8, 2004
By Jason Folkens (Dewitt, MI United States) - See all my reviews
I bought this book, thinking I would get certified.

I spent 2 months reading the pages, and doing the exercises.

Then I went to take the exam... Failed 3 times before I actually threw the book away and searched for another training source. And I'm not a dufus; I've passed many certification exams in the past.

This book contains SOME quality information, but if your goal is to get certified, just read Books On Line and totally disreguard the existance of this book.

Its common knowledge that the goal of MS certification tests is to test your ability to transform working knowledge of a product into real world application, and for that reason, an effective training source should simulate that real world expierence. This book fails to do this.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
25 of 26 people found the following review helpful:
3.0 out of 5 stars More of a course on SQL than an exam prep guide..., February 19, 2005
I used this book with the intention of passing Microsoft's 70-229 exam. Although I took the exam yesterday and passed, it was not due to the material in this book as much as it was taking practice exams.

As I read this book, all I could think is that it was a review of what I already knew. I have been a software developer using SQL for over 10 years now and I was a bit worried that this book wasn't giving me the information I needed to pass the exam. I got a great refresher of SQL DDL and DML commands and even learned a few things I didn't know. I learned a little about how SQL Server works specifically.

It wasn't until I finished reading the book and began taking the Transcender practice exams that I began to realize what I would be in store for on the actual exam. The Transcender practice exams were a very accurate simulation as to how the actual exam would look, I would recommend them to anyone. As a matter of fact, some of the Transcender exam questions looked very similar to ones I saw on the real exam. I did not take the practice test in the text of the book or on the supplied CD, so I cannot comment on their quality. From my experience, the exams offered for free in books are not very good.

This book would be a lot better if it modeled the exam a bit more. The exam likes to present a situation and ask what you should do to solve a particular problem. For instance, a example Security question on the exam goes something like this:

"John creates a table and you create a view on that table. Neither of you belong to the sysadmin role. The users in the sales department try using the view and they report that they cannot access the information they need. What should you do?"

I would have liked the book more if it presented examples like this to illustrate the information presented. As a matter of fact, this book reminds me of an information dump. Like most Microsoft exam study guides I have read in the past, they simply back up the information truck and dump the load onto you. You are responsible for figuring out how to apply that knowledge. But guess what? The exam test you on applying that knowledge.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
13 of 13 people found the following review helpful:
3.0 out of 5 stars 70-229 SQL 2k Design and Implementation, February 5, 2004
By James W. Frock, Ph.D. (Waldorf, MD United States) - See all my reviews
I was not pleased with the contents of this book in terms of sloppy editing and in the paltry treatment of important topics. Those of us in pursuit of the MCP or MCDBA will have to augment this book and what we take from this book with other more complex books dealing with design and implementation. Do be prepared to purchase additional books on T-SQL programming and do be prepared to purchase real exam prep software.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
Ad
 
Most Recent Customer Reviews

1.0 out of 5 stars Poorly written...
Most books I have read from Microsoft Press have been good, but this one is not one of them. The chapters referred to the SQL Book Online (BoL) way too often. Read more
Published 3 months ago by J. Miller

4.0 out of 5 stars Good training book
I am in a SQL Database Implementation and Design class right now, and the lessons provided in the book do a good job at instilliong SQL code into your mind.
Published 9 months ago by A. Alexander

4.0 out of 5 stars Exam 70-229
Fairly good book with some problems in repetitive text. Do NOT count on this book as your only resource for the 70-229 exam. Read more
Published 20 months ago by David Kelley

4.0 out of 5 stars Works for getting the basics and cert prep
Not being interested in certification, I was looking for something that would get me the basics, and tell me where to go to get the meat. This book is doing that. Read more
Published on June 9, 2007 by P. Siegling

1.0 out of 5 stars Simply badly designed for exams
I believe that the writers made some bad choices when they first began to write this book. First of all, unlike most other certification books the exam goals are not together in... Read more
Published on May 22, 2006 by zrer10

4.0 out of 5 stars This Won't Prepare You For 70-229 But a Good Starting Point.
This book is a very easy read, explains concepts clearly, but lacks the kind of detail necessary for passing the 70-229 exam, especially if you are taking this as an elective on... Read more
Published on May 16, 2005 by M. Inman

1.0 out of 5 stars Book for SQL novice
This book is good for a person whom does not know any thing about SQL and Database Designing. If you are an Experience whom trying to get ready for the exam. Read more
Published on April 16, 2005 by Mamdoh Al-habeeb

1.0 out of 5 stars Microsoft Blew it - Again
This book is so full of ommissions and errors that it is virtually usless as a tutorial or reference.
Published on March 21, 2005 by ASmith

3.0 out of 5 stars Good overview, but still needs an assist.
The book gives a cursory overview of the topics needed for the exam. This comes as no surprise since the teams that write the courses/books and the teams that write the exams are... Read more
Published on December 17, 2004 by Michael Temkin

2.0 out of 5 stars Exam Topic Overview Only
This book gives an introduction to the topics required for the exam but nowhere near the detail required. Read more
Published on October 21, 2004 by Tim

Only search this product's reviews



Customer Discussions

 Beta (What's this?)
New! See all customer communities, and bookmark your communities to keep track of them.
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]


   


Product Information from the Amapedia Community

Beta (What's this?)



Look for Similar Items by Category


Don't Slip and Slide

HeatTrak Heated Walkway

Keep your walkways safe and clear of snow and ice using the HeatTrak heated walkway.

Shop all HeatTrak heated walkways

 

Big Savings in Books

Bargain Books
Find great titles at fantastic prices in our Bargain Books Store.
 

Summer Reading for Kids & Teens

Summer Reading for Kids and Teens
Discover everything from beach reads and board books to teen romance and action-adventure series in Summer Reading for Kids & Teens. And, check off the kids' required reading lists in our Summer School Reading Store.
 

FREE Super Saver Shipping on Select Makita Power Tools

FREE Super Saver Shipping on select Makita power tools
Check out our huge selection of Makita power tools, including an extensive line of drills and saws. Take advantage of FREE Super Saver Shipping to save even more.

Shop all Makita power tools

 
Ad

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Where's My Stuff?

Shipping & Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue shopping: Top Sellers
Free
Free by Chris Anderson
Paranoia
Paranoia by Joseph Finder
The Adventures of Sherlock Holmes
The Adventures of Sherlock Holmes by Arthur Conan, Sir, 1859-1930 Doyle
Glenn Beck's Common Sense

Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates