Vous voulez voir cette page en français ? Cliquez ici.

Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days [Paperback]

Richard Waymire , Rick Sawtell
3.7 out of 5 stars  See all reviews (14 customer reviews)

Available from these sellers.


Amazon Price New from Used from
Paperback CDN $32.75  
Paperback, Oct. 19 2000 --  
There is a newer edition of this item:
Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days (2nd Edition) Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days (2nd Edition) 3.7 out of 5 stars (14)
CDN$ 32.75
Usually ships in 1 to 3 months
Join Amazon Student in Canada

Book Description

Oct. 19 2000 Sams Teach Yourself...in 21 Days
Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days will clearly define and walk the student through the features of SQL Server 2000. The student will be given tips and tricks for working within the new SQL Server 2000 product environment as well as working with SQL Server databases. The book will feature information on: creating and altering databases, managing security and implementing permissions, enforcing and ensuring data integrity, as well as modifying and manipulating data.

Product Details

Product Description

From the Back Cover

Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days will clearly define and walk the reader through the features of SQL Server 2000. The reader will be given tips and tricks for working within the new SQL Server 2000 product environment as well as working with SQL Server databases. The book will feature information on:

  • Create and alter databases*
  • Manage security and implement permissions*
  • Protect, backup, and restore data*
  • Enforce and ensure data integrity*
  • Modify and manipulate data*
  • Create views, triggers, functions, and stored procedures

    This book will also show readers how to:

  • Row-level locking*
  • SQL Server Query Analyzer*
  • Microsoft Management Console (platform that the Enterprise Manager is based upon)*
  • Replication*
  • SQL Server Agent which provides unattended job execution and alter/response management
  • About the Author

    Richard Waymire is a Program Manager with the SQL Server development team at Microsoft. He is also a Microsoft Certified Trainer (MCT), Solution Developer (MCSD), Database Administrator (MCDBA), and Systems Engineer + Internet (MCSE). He is a past president of the Pacific Northwest SQL Server User's Group.

    Rick Sawtell is both a Microsoft Certified Solutions Developer (MCSD) as well as a Microsoft Certified Trainer (MCT). He owns his own consulting firm and writes and trains on several Microsoft products.

    Inside This Book (Learn More)
    Browse and search another edition of this book.
    Explore More
    Browse Sample Pages
    Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
    Search inside this book:

    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
    This is a well written book that covers a lot of topics...in the end you'll have a very clear understanding of SQL Server 2K from both the administration and programming perspectives.
    I disagree with the other reviews posted on here about this book being too wordy or poorly organized. Perhaps those folks work for Oracle :-) There is a lot of material covered in this book, and for the most part, it's concise and doesn't adopt a condescending attitude towards the reader.
    In my search to learn SQL Server, I've found this book to rank at the top for general coverage of most of the DBA and programmer/user topics you encounter.
    Worth your time to read, and money to spend.
    Was this review helpful to you?
    1 of 1 people found the following review helpful
    5.0 out of 5 stars Worth the Investment May 3 2001
    Are you desiring to become a competent DBA, pass the related MCP exam, get hands on experience with and understand the general methodology of all features, or just dabble with some basic Transact SQL on SQL Server 2000 look no further. The book is written for persons with no to intermediate experience but the information contained within is applicable to all skill levels. The delivery of information is depicted in a clear and concise manner. The authors have definitely been around the block with previous versions of Microsoft SQL Server. Their experiences conveyed are instrumental in your present and future employment plus will save you valuable time that can be utilized more wisely elsewhere. My thoughts are if you desire to build a house you need to build a strong foundation first. If you don't you'll have ongoing structural problems and a leaking roof etc. This book will provide you with a strong foundation if you work through and apply its teachings. Prior to purchasing this book I've implemented and supported approximately thirty plus databases on Microsoft SQL Server 6x and 7 and one on 2000.
    Was this review helpful to you?
    1.0 out of 5 stars Not as good as Microsoft's on-line help. June 20 2003
    This is a very poorly written book. It wastes thousands of words telling the reader what it is going to tell you...and then...after all the build up...it doesn't tell you as much as the built-in SQL help files. The writing is often obtuse, and sometimes cryptic. Microsoft's on-line help gives more information, more concisely. This book does not live up to SAMS books reputation.
    Was this review helpful to you?
    1.0 out of 5 stars For beginners -only-. May 8 2003
    By A Customer
    This is the most useless book I've ever purchased. It rambles on from "what is a databse?" to "cost threshold for parallelism" without ever covering something as simple as inserting the date and time (or null not as a string) into a table. Certainly the last "Sams" book I'll ever buy.
    Was this review helpful to you?
    By A Customer
    I have no doubt that the authors of this book are very experienced at development and admin of SQL Server 2000 and earlier versions. They covered all topics in sufficent breath and depth. However, I would only rate this book as adequate for the following 2 reasons:
    1. There was a definate lack of organization to the way the material was presented. Quite often, there were non-sequeters: the text would be explaining some concept, but then suddenly there would be a paragraph on something quite unrelated (at least, I did not see the connection). The authors should have explained how the paragraph relates, or put it in a side-bar, or perhaps in another section. 'Stream of Consciousness' prose does NOT belong in a book providing technical instruction!
    The book was also disorganized in the fact that concepts were often used before they were introduced or explained. I know this is necessary sometimes, but it should happen rarely, and an author should explain fully why they are doing it so the reader is not left to wonder if they missed something.
    2. There were some errors in the code examples, not as much as in some computer books I have seen, but more than I think is acceptable. When I am paid to write code, I make damn sure it runs, and I hold authors of computer books to the same high standards. As a novice to T-SQL, I need to be able to examine CORRECTLY WORKING code examples; I really am not in a position to debug code in a langauge that I am just starting to learn.
    Bottom line: this book is OK, but the authors need to do a better job at organizing their material before presenting it, and checking over their own code.
    Was this review helpful to you?
    This is a fantastic book for people who need a crash course in SQL Server 2K. The information is presented in a style that gives the reader the "bottom line" on how to perform a task, with enough information to explain what the reader is doing and why.
    The book is also well-written, so if the reader is learning SQL Server on one's own, the reader should struggle very little.
    This book also comes with a 120-day evaluation of SQL Server 2000, so the reader can easily perform the hands-on exercises in the book, as well as experiment on one's own.
    Will this book make you a maven of SQL Server 2K? No, but this book will give you the information that you need to be a SQL Server Database Administrator.
    Was this review helpful to you?
    5.0 out of 5 stars Great book Oct. 14 2002
    I've read the reviews here - some of which complain that it's not detailed enough - but I disagree. Technical books almost always fall short when it comes to detail about specific topics simply because there's a limit on how many pages one wants to wade through!! When one needs specific technical details about a topic, you don't pick up a "teach yourself in 21 days book". The book did an excellent job of accomplishing what it states -the users leaves with a solid overview of SQL Server, with adequate foundation laid to uncover other information needed. I was also pleasantly surprised to see the non-technical lingo used to cover database design basics as well - ambitious coverage, well done!
    Was this review helpful to you?
    Want to see more reviews on this item?
    Most recent customer reviews
    Search Customer Reviews
    Only search this product's reviews

    Look for similar items by category