Register your product to gain access to bonus material or receive a coupon.
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.