- Paperback: 608 pages
- Publisher: John Wiley & Sons; Updated, 2nd Edition edition (5 Sep 2003)
- Language English
- ISBN-10: 0782142788
- ISBN-13: 978-0782142785
- Product Dimensions: 22.8 x 18.8 x 3.8 cm
-
Amazon Bestsellers Rank:
1,274,503 in Books (See Top 100 in Books)
- #3 in Books > Computers & Internet > Certification > Exams > Microsoft Certified Database Administrator (MCDBA)
- #17 in Books > Computers & Internet > Certification > Exams > Microsoft Certified Systems Administrator (MCSA)
- #70 in Books > Computers & Internet > Computer Science > Databases > Applications > Microsoft SQL Server > Introduction
- See Complete Table of Contents
MCSA/MCSE/MCDBA
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
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
Here′s the book you need to prepare for Exam 70–228, Installing, Configuring, and Administering Microsoft SQL Server 2000. This Study Guide provides:
- In–depth coverage of every official exam objective
- Practical information on installing, configuring, and administering SQL Server 2000
- Real–world insights, advice, and recommendations
- Hundreds of challenging practice questions, in the book and on the CD
- Leading–edge exam preparation software, including a test engine and electronic flashcards
Authoritative coverage of all exam objectives, including:
- Installing and configuring SQL Server 2000
- Creating SQL Server 2000 databases
- Managing, monitoring, and troubleshooting SQL Server 2000 databases
- Extracting and transforming data with SQL Server 2000
- Managing and monitoring SQL Server 2000 security
- Managing, monitoring, and troubleshooting SQL Server 2000
Note: CD–ROM/DVD and other supplementary materials are not included as part of eBook file.
From the Back Cover
Here′s the book you need to prepare for Exam 70–228, Installing, Configuring, and Administering Microsoft SQL Server 2000. This Study Guide provides:
- In–depth coverage of every official exam objective
- Practical information on installing, configuring, and administering SQL Server 2000
- Real–world insights, advice, and recommendations
- Hundreds of challenging practice questions, in the book and on the CD
- Leading–edge exam preparation software, including a test engine and electronic flashcards
- Installing and configuring SQL Server 2000
- Creating SQL Server 2000 databases
- Managing, monitoring, and troubleshooting SQL Server 2000 databases
- Extracting and transforming data with SQL Server 2000
- Managing and monitoring SQL Server 2000 security
- Managing, monitoring, and troubleshooting SQL Server 2000
Inside This Book
(Learn More)
First Sentence
SQL Server 2000 is a client/server-based relational database management system that runs on Windows 2003; Windows XP; Windows NT 4; Windows 9x/Millennium; and Windows CE. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
SQL Server 2000 is a client/server-based relational database management system that runs on Windows 2003; Windows XP; Windows NT 4; Windows 9x/Millennium; and Windows CE. 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. |
Customer Reviews
There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
6 reviews
8 of 8 people found the following review helpful
Good Tutorial, Bad Test Prep
8 Jun 2004
Format:Paperback
I really enjoyed this book. It's explaniations are incredibly good and it explains SQL Server very well.
However, the exam questions suck.
Two Examples:
Page 230: Question 4 - It says the correct answer is D, but there is no such command as sp_grantaccess ( It should be sp_grantdbaccess )
Page 232: Question 8 - again, there is no such command as sp_activateapprole, it's sp_setapprole.
I could go on, but it's really frustrating trying to use a book for an exam when it misleads like this.
3 of 3 people found the following review helpful
Good Contents
2 April 2005
Format:Paperback
Coming from Oracle background I am currently using this book to prepare for my MCDBA certification. I would not rate myself as beginner because I have dealt with MS SQL Server on many occasions but not heavily. I am pacing myself with one chapter a day. So far I read about 5 chapters and I would admit that the content is good. Like any other technical book, this one also has some mistakes. In my case I started seeing the mistake on pages 145 and 146. On those pages the authors stated that to see the file id you need to run in the SQL Analyzer the stored procedure sp_helpdb. That is not true at all it should be sp_helpfile. I caught that mistake quickly because I really understood the previous information given and related to file, and I also tested the stored procedures listed in the book. I did check the errata on sybex website nothing is listed concerning that mistake but there are some other corrected mistakes though on the website.
As I always do I don't rely on one source for my certification exams. I have got another book and I am planning to get a third one too. I will go through all of them before I go take the exam end of May. I will try to post another review after I took exam.
My overall impression on this book is the book is well-written and easy to follow. So far I am getting useful information out of the book. And that helps me understand the objectives on the exam. I am doing pretty good with the review questions at the end of the chapters. After going through half of the book I think I like what I see and I would recommend this book but not as the only source to study for the exam.
As I always do I don't rely on one source for my certification exams. I have got another book and I am planning to get a third one too. I will go through all of them before I go take the exam end of May. I will try to post another review after I took exam.
My overall impression on this book is the book is well-written and easy to follow. So far I am getting useful information out of the book. And that helps me understand the objectives on the exam. I am doing pretty good with the review questions at the end of the chapters. After going through half of the book I think I like what I see and I would recommend this book but not as the only source to study for the exam.
2 of 2 people found the following review helpful
DEFINITELY Incomplete Information
27 Nov 2005
Format:Paperback
I bought this book because 1)I have absolutely ZERO experience with Microsoft SQL 2000 and 2)I have used Sybex books in the past to help me gain knowledge of Windows XP and Windows Server 2003, of which I have passed all exams.
However, with this book I am very dissappointed. Examples are imcomplete, not clear and generally leave the reader hanging as to what to do next. More often than not, when working my way through the excercises I have to go to the SQL page on the Microsoft website and try and find the information that was left out of the book. It's a tremendous waste of time and very frustrating. If the authors of this book want to assume that every reader out there already has knowledge of how SQL server is installed and administered, then they should be writing handbooks and pocket guides for existing IT administrators and engineers.
Like many people out there who are working on a certification, I bought this book to learn the ins-and-outs of SQL installation and administration. As such, I need to understand every step as much as possible. Unfortunately both the authors and Sybex have failed me this time.
However, with this book I am very dissappointed. Examples are imcomplete, not clear and generally leave the reader hanging as to what to do next. More often than not, when working my way through the excercises I have to go to the SQL page on the Microsoft website and try and find the information that was left out of the book. It's a tremendous waste of time and very frustrating. If the authors of this book want to assume that every reader out there already has knowledge of how SQL server is installed and administered, then they should be writing handbooks and pocket guides for existing IT administrators and engineers.
Like many people out there who are working on a certification, I bought this book to learn the ins-and-outs of SQL installation and administration. As such, I need to understand every step as much as possible. Unfortunately both the authors and Sybex have failed me this time.
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 > Exams > Microsoft Certified Systems Administrator (MCSA)
- Books > Computing & Internet > Certification > Publishers > Wiley
- 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
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Hardware
- Books > Computing & Internet > Software & Graphics
- Books > Science & Nature > Education
- Books > Study Books > Teachers Resource
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.
|
