Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days (Book & CD-ROM) (Paperback)

~ (Author), Rick Sawtell (Author)
Key Phrases: sysadmin fixed server role, serverwide roles, create database process, Server Enterprise Manager, Server Agent, English Query (more...)

Editorial Reviews

Product Description

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.

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

See all Editorial Reviews

Product Details

• Paperback: 800 pages
• Publisher: Sams (September 21, 2000)
• Language: English
• ISBN-10: 0672319691
• ISBN-13: 978-0672319693
• Product Dimensions: 9.1 x 7.4 x 2.1 inches
• Shipping Weight: 3.3 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars  See all reviews (19 customer reviews)
• Amazon.com Sales Rank: #1,026,812 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

64 of 64 people found the following review helpful:

5.0 out of 5 stars Excellent introduction to SQL Server 2000, February 18, 2001

By	ad_crumenam "ad_crumenam" (Texas, USA) - See all my reviews

If you are an absolute SQL Server 2000 beginner but understand (basically) what a database is, this is the book for you. I have no experience in programming or SQL, and I've been able to ramp up VERY quickly with SQL Server, creating databases, tables, queries, and stored procedures with ease using the examples. The book is clearly laid out and has good examples. However, it IS a book about the server itself, not programming SQL. It contains a great deal of information on using ALL of the features included in SQL Server 2000. If all you want to do is learn to do is write queries, you might want to skip this and go for a book with a more narrow focus. This book's treatment of SQL Server is very broad.

33 of 33 people found the following review helpful:

5.0 out of 5 stars Great For Developers & Administrators New To SQL Server, July 23, 2002

By	David Gurgel (Roseland, New Jersey United States) - See all my reviews (REAL NAME)

Amazon Verified Purchase

I am a mechanical engineer and have rolled my own applications and done much of the systems administration for twenty years for my small online services company. Working on an ambitious .NET project and with little previous experience with SQL Server, I wanted to get comfortable with the physical implementation of relational data bases while I was still doing the logical data base design using Embarcadero. This book met all my needs and was enjoyable to read.

The book has 850 pages and has a CD with a 120-day evaluation copy of SQL Server 2000. The code for the exercises is available for downloading from the SAMS site. The organization is chronological, with steps ordered pretty much as you would do them if you were installing, setting up and administering a new SQL Server installation. You should be comfortable in a Windows 2000 or NT environment and have done some prior work with a database before attempting this book which is written for computer professionals.

The book did not seem like a typical SAMS Teach Yourself book, which are very useful as tutorials but often poorly arranged and indexed as references. This book together with the exhaustive and detailed SQL Server Books Online (the Microsoft SQL Server manual on the CD) will be all of the references you will need for physical data base design and administration. You will need other references for logical design of a relational data base and for the other platform technologies such as ASP.NET and VB.NET that you may use to do a full application.

I was pleased with the exercises. Each stood alone for the most part, allowing me to jump around a bit and still do those exercises that were useful to me. I was also pleased with the section on security. Security is a subject that I usually dread, but here it was covered in some detail but very clearly.

The author is a senior Microsoft SQL Server team member.

32 of 33 people found the following review helpful:

5.0 out of 5 stars Worth the Investment, May 3, 2001

By	R. Corvino "rj5000" (Chicago Area, IL USA) - See all my reviews (REAL NAME)

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.