- Hardcover: 1200 pages
- Publisher: McGraw-Hill Inc.,US; Har/Cdr edition (1 Sep 2001)
- Language English
- ISBN-10: 0072131586
- ISBN-13: 978-0072131581
- Product Dimensions: 24.5 x 18.8 x 4.9 cm
- Average Customer Review: 2.0 out of 5 stars See all reviews (2 customer reviews)
-
Amazon Bestsellers Rank:
3,242,442 in Books (See Top 100 in Books)
- #6 in Books > Computers & Internet > Certification > Exams > Microsoft Certified Database Administrator (MCDBA)
- #49 in Books > Computers & Internet > Certification > Subjects > Microsoft > SQL Server
- #98 in Books > Computers & Internet > Certification > Publishers > Osborne McGraw-Hill
- See Complete Table of Contents
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Product Description
This "All-in-One" is all you need! This authoritative reference offers complete coverage of all material on the two core MCDBA SQL Server 2000 exams. You'll find exam objectives at the beginning of each chapter, helpful exam tips, end-of-chapter practice questions, and photographs and illustrations. The bonus CD-ROM contains practice tests, hundreds of questions, and LearnKey([trademark]) video clips. This comprehensive guide will not only help you pass the MCDBA SQL Server 2000 certification exams, but will also serve as an invaluable on-the-job reference.
From the Publisher
Fully searchable book on CD expedites study and research.
Real world, hands on labs and examples reinforce learning and product practice.
Practice test questions in each chapter test your understanding of exam objectives.
Includes Virtual Study Group software for online collaborative study.
Easy to use map of exam objectives facilitates quick access for exam review.
Real world, hands on labs and examples reinforce learning and product practice.
Practice test questions in each chapter test your understanding of exam objectives.
Includes Virtual Study Group software for online collaborative study.
Easy to use map of exam objectives facilitates quick access for exam review.
Inside This Book
(Learn More)
First Sentence
Welcome to the Osborne McGraw-Hill All-in-One MCDBA Exam Guide. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Welcome to the Osborne McGraw-Hill All-in-One MCDBA Exam Guide. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
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
Most Helpful Customer Reviews
24 of 24 people found the following review helpful
Format:Hardcover
Maybe my expectations were too high with this one but I was looking for something to serve as a final review before taking the two SQL 2000 exams.
I've been in IT just under two years and have been working with databases (mainly SQL7) exclusively for about half that time. I found that this book went into too much detail on some of the real basics but didn't provide sufficient coverage for some topics on the exam, for example log shipping or replication. Each chapter includes exam tips such as "Replication is an important part of the exam; be sure you are comfortable with this topic". A valid, if obvious point, unfortunately the reader won't get to know Replication from this book alone. Other sections got better coverage including Installation/Upgrade and creating/managing databases and database options.
Unfortunately. like many other test preparation books, All-In-One MCDBA falls short in the sample questions. In fact after the first few chapters, I gave up using them because they can be so misleading. For example, there is question about which database is used as template for new databases. According to Perkovich, the answer is master - when in actual fact it's the model database. In a book offering "Complete coverage of all material on both required exams #70-228 & #70-229" mistakes like this could cost somebody an exam pass.
Having said all this, I still give this book three stars and this is why:
For a complete beginner, with no real database knowledge, this book is a reasonably good starting point although it shouldn't be the only book a beginner buys. Also, issues with wrong answers to sample questions seem to be quite common amongst this type of book so that alone should not put the prospective buyer off.
If you have some experience try Brian Knight's Admin 911: SQL Server 2000. That together with BOL is good preparation for the SQL 2000 Admin exam.
I've been in IT just under two years and have been working with databases (mainly SQL7) exclusively for about half that time. I found that this book went into too much detail on some of the real basics but didn't provide sufficient coverage for some topics on the exam, for example log shipping or replication. Each chapter includes exam tips such as "Replication is an important part of the exam; be sure you are comfortable with this topic". A valid, if obvious point, unfortunately the reader won't get to know Replication from this book alone. Other sections got better coverage including Installation/Upgrade and creating/managing databases and database options.
Unfortunately. like many other test preparation books, All-In-One MCDBA falls short in the sample questions. In fact after the first few chapters, I gave up using them because they can be so misleading. For example, there is question about which database is used as template for new databases. According to Perkovich, the answer is master - when in actual fact it's the model database. In a book offering "Complete coverage of all material on both required exams #70-228 & #70-229" mistakes like this could cost somebody an exam pass.
Having said all this, I still give this book three stars and this is why:
For a complete beginner, with no real database knowledge, this book is a reasonably good starting point although it shouldn't be the only book a beginner buys. Also, issues with wrong answers to sample questions seem to be quite common amongst this type of book so that alone should not put the prospective buyer off.
If you have some experience try Brian Knight's Admin 911: SQL Server 2000. That together with BOL is good preparation for the SQL 2000 Admin exam.
Format:Hardcover
I have taken the 70-228 exam and passed, and am now trying to use this guide to study for the 70-229. That is covered in 5 short chapters towards the end of the book, which is really shows the lack of depth in the guide as a whole.
This book contains glaring inaccuarcies such as repeatedly stating that the master database is used as a model for the creation for new databases, rather than the model, and referring to material on the CD that simply was not there.
This book also seems to go into quite some depth on areas that the Author is obviously confident and glosses over other areas that were important areas of the exam. Sure, I passed, but only just, despite having 8 years in this area. This study guide was not helpful,and somewhat misleading on occasions, if it had been my only source of study I would have failed, despite getting over 90% in the exams on the accompanying CD.
Given what I know now, I would not have bought this book. There are better books on the market, however, for the pricce the book is retailing for in the "new and used" section, as a backup reference it may be sufficient.
I would certainly not recommend this book as an "on-the-job" reference as it states on the cover, it is completely exam focussed if it is anything, and there is no useful material in it to assist anyone except for a complete novice.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
16 reviews
11 of 11 people found the following review helpful
DBA Not
5 Mar 2002
Format:Hardcover
Dave Perkovich is not a MSSQL DBA and he doesn't have a clue. The book is full of errors. For example: The book states several times that the timestamp field is a datetime field. This is not true. I started marking the errors in the book. More than a third of the pages are marked. The test software is full of bugs. Don't buy this book. If you bought this book, try to get your money back.
7 of 7 people found the following review helpful
It isn't that bad!
21 Aug 2002
Format:Hardcover
I bought this book because I couldn't find any others in my local bookstores. When I 'browsed' it, it seemed clear enough so I took a chance. Now that I've read all but the last few chapters (and done all the exercises, etc), I feel I would buy it again and, indeed, recommend it with a small qualification or two.
Positives:
First, it is not the bottom of the heap - far from it. I've read much poorer quality technical books before. I rated it at 3 stars but, if it hadn't claimed to be a test prep book, I would have rated it at 4 stars.
Second, it is great for new people. So what if it misses a few of the finer points (even necessary ones?) Within two days of starting with it I was using DTS and replication and getting XML responses back through IIS. I found it very clear to get these services going.
Third, I don't mind pictures and this book has quite a few. Nothing like a picture to show you what screen you *should* be looking at.
Fourth, other than minor typos, the author is literate. Better than many other books out there.
Negatives:
First, this is *not* a test prep book. I've taken a number of cert tests (dozens) and I don't feel like I'm even close to ready for testing. However, I do feel a lot more confident about understanding the questions. A lot more.
Second, there are some awful mistakes in some of the exercises. All of them are correctable and you have to correct them but it makes you suspicious whenever you start an exercise. For me, that isn't a bad thing. For a complete newbie, it could be a bit distressing.
Third, the test banks don't work well. This doesn't make it a '1' in my opinion. I've not seen a test bank in a book that is representative of the real test. However, it does degrade my overall score for the book a little. Like I said when I started, if the book hadn't advertised it was a test prep book, I would have given it a '4'.
7 of 7 people found the following review helpful
CD-ROM Test Software Useless
5 Mar 2002
Format:Hardcover
The content is reasonable. There are a large number of step-by-step processess with screen shots, which I consider filler.
The self-test software on the CD is unusable. It has blank questions. There are also multiple-choice questions that should use checkboxes, but use radio buttons, resulting in only being able to choose one answer. If you happen to choose the first right answer, the answer is scored as correct even though you didn't answer the others.
I'd like to get my money back for this book and buy a better one.
I hope this review prevents others from falling into the same trap as me.
Good luck with your certifications!
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Computing & Internet > Certification > Exams > Microsoft Certified Database Administrator (MCDBA)
- Books > Computing & Internet > Certification > Publishers > Osborne McGraw-Hill
- Books > Computing & Internet > Certification > Subjects > Microsoft > SQL Server
- Books > Computing & Internet > Computer Science > Information Systems
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server > Introduction
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Database Theory
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
