Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days Paperback – Oct 19 2000
There is a newer edition of this item:
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
To get the free app, enter your e-mail address or mobile phone number.
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.
Top Customer Reviews
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.
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.
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.
Most recent 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... Read morePublished on Dec 12 2003 by Amazon Customer
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... Read morePublished on June 19 2003 by Marvin Fretwell
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... Read morePublished on May 8 2003
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... Read morePublished on Oct. 14 2002 by Amazon Customer
Vale la pena invertir bien el tiempo en cada uno de los capítulos de este libro. Particularmente pienso que hay capítulos en que hay que invertir más de dos y... Read morePublished on June 20 2002 by Jaime Javier Flores
Many of the subjects treated were glossed over and/or not fully explained. The authors managed to eek out over 700 pages of text
with such stunning revelations the following... Read more
This book is excellent. Helped me pass the MCP exam. Originally started with the Exam Cram but that just covered topics superficially. Read morePublished on Dec 12 2001
If you are an absolute SQL Server 2000 beginner but understand (basically) what a database is, this is the book for you. Read morePublished on Feb. 18 2001 by ad_crumenam
Look for similar items by category
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Databases > Relational Databases
- Books > Computers & Technology > Microsoft > Development > SQL Server
- Books > Computers & Technology > Networking & Cloud Computing > Data in the Enterprise > Client-Server Systems
- Books > Computers & Technology > Software
- Books > Computers & Technology > Web Development > Programming > SQL
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design
- Books > Textbooks > Computer Science & Information Systems > Programming Languages