Sams Teach Yourself Microsoft SQL Server 7 in 21 Days

Sams Teach Yourself Microsoft SQL Server 7 in 21 Days

This is a free sql server book from Sams Reference Library. 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.

Table of Contents

  • Introduction to SQL Server 7.0 and Relational Databases
  • Installing SQL Server 7.0
  • Using the SQL Server 7.0 Tools and Utilities
  • Creating and Implementing Databases, Files, and Filegroups
  • Using SQL Server Login and User Security
  • Working with Permissions
  • Implementing Backups in SQL Server 7.0
  • Restoring SQL Server Databases
  • Creating Tables
  • Using SQL Server 7.0 Data Transformation Services
  • Retrieving Data with Queries
  • Data Modification with Queries
  • Enhancing Performance with Indexing
  • Ensuring Data Integrity
  • Working with Views, Stored Procedures, and Triggers
  • Programming SQL Server 7.0
  • Understanding Replication Design and Methodologies
  • Implementing Replication Methodologies
  • Using the SQL Server Agent
  • Configuring and Monitoring SQL Server 7.0
  • Integrating SQL Server and the World Wide Web

Book Details

Author(s): Richard Waymire and Rick Sawtell
Format(s): HTML
Link: Read online.

Leave a Reply