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. |
Frequently Bought Together
Product details
|
Product Description
Product Description
Learn how to deliver powerful database solutions using SQL Server 2000 Enterprise Edition—and prepare for the Microsoft Certified Professional (MCP) exam—with this official Microsoft study guide. Work at your own pace through the lessons and hands-on exercises. And use the special exam-prep section and testing tool to measure what you know and where to focus your studies—before taking the actual exam. As you build the real-world expertise for designing data-driven business solutions, you’re also preparing for MCP Exam 70-229—a core exam for MCDBA certification and a key elective on the MCSE, MCAD, and MCSD tracks.
Build the skills to:
- Develop a logical data model
- Create databases—files, objects, space management, and growth strategy
- Use Transact-SQL and Data Transformation Services (DTS) to manipulate data; extract data in XML format
- Program business logic using stored procedures, transactions, triggers, user-defined functions, and views
- Optimize database performance by using SQL Profiler and the Index Tuning Wizard * Design a security plan—data access, object-level security, and application roles
Ready for the exam? Take practice tests on the CD.
Your kit includes:
- Comprehensive self-paced study guide that maps to MCP exam goals and objectives
- NEW—Test-readiness tool that generates timed, 50-question practice exams with automated scoring
- NEW—More than 200 pages of exam prep and objective-by-objective review
- Learn-by-doing exercises for skills you can apply to the job
- 120-day evaluation version of SQL Server 2000 Enterprise Edition
- Fully searchable eBook
About the Author
Developed by senior editors and content managers at Microsoft Corporation.
Inside This Book
(Learn More)
First Sentence
Microsoft SQL Server 2000 is a complete database and analysis solution for rapidly delivering the next generation of scalable Web applications. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Microsoft SQL Server 2000 is a complete database and analysis solution for rapidly delivering the next generation of scalable Web applications. 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
2 of 2 people found the following review helpful
Format:Hardcover
I bought this book a while ago but have only just found the time to sit down and study it with a view to passing my MCP exam. Although the book is well structured it contains so many errors and misses important features of SQL 2000 that you will be tested on in the exam. For example, the book does not cover DTS in any real detail and doesnt even mention replication. These are serious omissions.
24 of 43 people found the following review helpful
Format:Hardcover
Excellent book, and includes 120 day trial version of SQL Server 2000, a cd containing simulated electronic tests similiar to actual microsoft exams.
Well worth the money.
Nice one Microsoft Press.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
20 reviews
27 of 28 people found the following review helpful
More of a course on SQL than an exam prep guide...
19 Feb 2005
Format:Hardcover
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.
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.
27 of 29 people found the following review helpful
Sales book, not good for certification
8 Jun 2004
Format:Hardcover
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.
13 of 14 people found the following review helpful
70-229 SQL 2k Design and Implementation
6 Feb 2004
Format:Hardcover
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.
Were these reviews helpful?
Let us know
Listmania!
|
|
Look for similar items by category
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.
|
