Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days [Paperback]

Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days will clearly define and walk the student through the features of SQL Server 2000. The student 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: creating and altering databases, managing security and implementing permissions, enforcing and ensuring data integrity, as well as modifying and manipulating data.

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

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.