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 Manage-ment Console (platform that the Enterprise Manager is now based upon); Update Replication feature (multisite, improved performance and scriptable replication objects); New Wizards such as: Create Database, Create Job, Index Tuning, Version Upgrade and Security; SQL Server Agent which provides unattended job execution and alter/response management; New Transact-SQL statements such as ALTER PROCEDURE, ALTER TRIGGER; and information on recursive triggers and local cursors. It walks you through the features of SQL Server 7, increasing the performance and scalability of your database.
I. WEEK 1: AT A GLANCE.Day 1: Introduction to SQL Server 7.0 and Relational Databases.
II. WEEK 2: AT A GLANCE.Day 8: Restoring SQL Server Databases.
III. WEEK 3: AT A GLANCE.Day 15: Working with Views, Stored Procedures, and Triggers.
III. WEEK 3: IN REVIEW.Appendix A.