Cover image for Sams teach yourself Microsoft SQL server 7.0 in 21 days
Sams teach yourself Microsoft SQL server 7.0 in 21 days
Waymire, Richard.
Personal Author:
Publication Information:
Indianapolis, Ind. : Sams Pub., [1999]

Physical Description:
xxi, 772 pages : illustrations ; 23 cm
General Note:
Includes index.
Title Subject:
Added Author:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D3 W385 1999 Adult Non-Fiction Central Closed Stacks

On Order



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.

Author Notes

Rick Sawtell is both a Microsoft Certified Solutions Developer as well as a Microsoft Certified Trainer. Richard Waymire is a Principal Engineer with Aris Corp. in Bellevue, WA. He is also a Microsoft Certified Trainer (MCT), Solution Developer (MCSD), and Microsoft Certified Systems Engineer (MCSE).

Table of Contents

I 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 /Repository/06723/0672312905/conversion/html/0672312905/element_003.html/Repository/06723/0672312905/conversion/html/0672312905/element_003.html
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
II 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
III 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
III Week 3: In Review
Appendix A