Certified Microsoft Trainers and Solutions Developers structure a mini-course for SQL Server administrators in Microsoft's newest version of its flagship relational database management system, covering SQL Server 2000's improvements and new features (e.g. new administrative tools and desktop installation). Includes a quiz-a-day with answer key for 21 days, though two bonus days extend the course to 23 days. The CD-ROM includes an evaluation copy of the server. Annotation c. Book News, Inc., Portland, OR (booknews.com)
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