Product Description

Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days, 2E 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.

Product Details

• Amazon Sales Rank: #282181 in Books
• Published on: 2002-11-19
• Original language: English
• Number of items: 1
• Binding: Paperback
• 960 pages

From the Back Cover

Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days, 2E 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.

About the Author

Richard Waymire, a group program manager with the SQL Server development team at Microsoft, is also a Microsoft Certified Database Administrator and Systems Engineer. He's been working on various versions of SQL Server since 1994, and joined the Microsoft development team in 1998. Richard has been a programmer, DBA, and trainer on SQL Server before joining Microsoft. Richard still considers himself a database administrator at heart. You can reach Richard at rwaymi@hotmail.com.

Rick Sawtell is a Microsoft Certified Solutions Developer and Certified Trainer. He owns his own consulting firm based in the Hawaiian Islands and currently consults, trains, and writes computer books on several Microsoft products. He has more than 17 years of experience in the consulting and programming arena, with emphasis on database front-end and back-end development. You can reach Rick at r_sawtell@hotmail.com.

Customer Reviews

Good intro to sql for beginners
This was my first book on SQL and I found it very useful. The examples are clearly explained, although a little brief at times. The book is based on the microsoft sql server 2000 product range, whereas other books which I have looked at where a little bit more general. Overall, a good read although you will need another book if you want detailed explanations of the enterprise manager and wizard functionality.

Excellent intro to SQL Server 2000
As the previous reviewer stated, this book is very centered on SQL Server 2000; the title of the book, 'Teach Yourself SQL Server 2000 in 21 Days' is kind of obvious in that respect. This book is not a SQL tutorial; it focuses mainly on aspects of installation, usage, and database administration as they pertain to SQL Server 2000. If you are looking for a SQL language tutorial, this book is probably more than you need though it does contain an excellent but brief SQL tutorial.

As for teaching SQL Server 2000, this book does so superbly. It doesn't assume that you're a programmer or that you know much about databases but it does assume prior experience with computing. I purchased a copy nearly five years ago when I was just getting started with SQL Server and this book didn't leave my side for weeks. By the time I finished, I had a SQL server up and running with reliable backups and easy admin tasks, and was using it for a practical purpose. The sections on using XML with SQL Server were a little thin, but the information has probably been updated in a subsequent version between 2001 and now. Despite the thinness on this subject, I had my SQL server producing data in a usable XML format and a website calling a stored procedure that used XML.

I highly recommend this book if you're interested in the administrative aspects of running a database. It may also be useful for developers who want to know more about database administration. If all you need is to learn the SQL language for simple queries, this book is overkill; and if you want to know about Oracle or MySQL, this is obviously not the book for you!