Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days with CD-ROM

by Waymire, Richard; Sawtell, Rick

• ISBN13: 9780672319693
• ISBN10: 0672319691
• Format: Paperback
• Copyright: 2000-10-01
• Publisher: Pearson P T R

Summary

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.

Table of Contents

At a Glance	7	(256)
Introducing Relational Databases and Microsoft SQL Server 2000	9	(14)
Installing Microsoft SQL Server 2000	23	(40)
Working with SQL Server 2000 Management Tools and Utilities	63	(48)
Creating and Administering Databases and Data Files	111	(34)
Setting Up Login and User Security	145	(38)
Establishing Database Permissions	183	(36)
Backing Up Your Databases	219	(44)
In Review	261	(2)
At a Glance	263	(248)
Restoring Your Databases	265	(32)
Data Types and Creating Tables	297	(28)
Retrieving Data with the SELECT Statement	325	(50)
Modifying Data	375	(18)
Using Transact-SQL Extensions	393	(36)
Indexing for Performance	429	(42)
Ensuring Data Integrity	471	(40)
In Review	509	(2)
At a Glance	511	(234)
Creating Views, Triggers, Stored Procedures, and Functions	513	(36)
Understanding Replication Design Methodologies	549	(34)
Implementing Replication Methodologies	583	(42)
Scheduling Jobs with SQL Server Agent	625	(36)
Migrating Data Between Database Servers	661	(28)
Performance Monitoring Basics and Tools	689	(30)
Using XML with SQL Server 2000	719	(26)
In Review	743	(2)
Bonus Days At a Glance	745	(54)
An Overview of Analysis Services	747	(14)
An Overview of English Query	761	(38)
Appendix
Appendix A Answers to Quiz Questions	775	(24)
Index	799