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.
Customer Reviews
Average Rating:
Rating: - No peer.
I use(d) this book as the basis towards my WIN2K MCDBA...It is superior to anything out there including Microsoft's Official MCSE [Exam 70-228] SQL Server 2000 SA Training Kit... includes everything one needs assuming one immerses oneself in the book from Day 1 through Day 21 in addition to Day 22 (SQL Server Analysis Services (OLAP)) and Day 23 (English Query).It is both a superior reference book and programmer's guide. After purchasing Microsoft's official references I found myself repeatedly (frustrated ... Read More
Rating: - I liked the book
The book was ok. It has taught me a lot. However, it is not without its easily seen errors.
1) Some concepts are not expounded on to make sure a newcomer or complete idiot thoroughly understands what is said. Some sentences can be so concise that it can cause you to take a word for granted (if you aren't paying extra attention) which could lead to complete confusion. thus, if there are no supporting sentences you can be completely lost. It also uses terms without explaining them or maybe expects ... Read More
Rating: - GREAT Book
I have a LOT of access experience and wanted to move to SQL Server.
This is a great beginner book for those with a little knowledge of SQL and a lot of knowledge of relational databases.
Great chapters on SQL usage.
GET THIS BOOK!!
Rating: - Excellent exam prep
I found this book excellent prep for the MCP exam (70-229). The discussions on deadlocks, indexing, transactions, and security (specifically, application roles and ownership chains) were definitely the difference in my passing the exam.
The authors do a very good job of explaining WHY you would want to do something, not just HOW.
The only negative thing for me was the frequent references to how things used to work in SQL 7.0, 6.5 and earlier.
Rating: - A very good book if you're the right audience
This is a very good book for the newcomer to SQL Server, particularly for those who have little experience with other databases.
It addresses various topics that are just enough to get you started on being able to get some work done with SQL Server and know what else you need to learn. Strange as it may sound, IMHO, discovering what you don't know is a valuable endeavour. Sure, it could've gone into a lot more detail on the query optimizer or how lock escalation really works, etc... but really, where ... Read More
- No peer.
