Sams Teach Yourself Microsoft SQL Server 7 in 21 Days

By Richard Waymire and Rick Sawtell

More Information

Sams Teach Yourself Microsoft SQL Server 7 in 21 Days gives you the new features and capabilities of SQL Server 7, in a tutorial environment. This book features information on: Row-level locking; SQL Server Query Analyzer (formerly the ISQL/w); Microsoft ...

Table of Contents

• Copyright
• About the Authors
• Acknowledgments
• Tell Us What You Think!
• Introduction
• Part 1: Week 1 At a Glance
• Day 1. Introduction to SQL Server 7.0 and Relational Databases
• Day 2. Installing SQL Server 7.0
• Day 3. Using the SQL Server 7.0 Tools and Utilities
• Day 4. Creating and Implementing Databases, Files, and Filegroups
• Day 5. Using SQL Server Login and User Security
• Day 6. Working with Permissions
• Day 7. Implementing Backups in SQL Server 7.0
• Part 2: Week 2 At a Glance
• Day 8. Restoring SQL Server Databases
• Day 9. Creating Tables
• Day 10. Using SQL Server 7.0 Data Transformation Services
• Day 11. Retrieving Data with Queries
• Day 12. Data Modification with Queries
• Day 13. Enhancing Performance with Indexing
• Day 14. Ensuring Data Integrity
• Part 3: Week 3 At a Glance
• Day 15. Working with Views, Stored Procedures, and Triggers
• Day 16. Programming SQL Server 7.0
• Day 17. Understanding Replication Design and Methodologies
• Day 18. Implementing Replication Methodologies
• Day 19. Using the SQL Server Agent
• Day 20. Configuring and Monitoring SQL Server 7.0
• Day 21. Integrating SQL Server and the World Wide Web
• Appendix A. Answers