| |||||||||||||||
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Books Trade-In Store for more details. Learn more. |
|
There is a newer edition of this item:
|
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:
*This book will also show readers how to:
*
Product details
Would you like to update product info or give feedback on images?
|
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.
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!
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.
