Sams teach yourself SQL Server 7 in 24 hours

Topics included are:

• Creating databases and gathering information
  
• Building queries and retrieving data
  
• Analyzing and defining data
  
• Creating tables, and working with views
  
• Stored procedures and triggers
  
• Concise one-hour tutorials provide all the information needed to use SQL Server quickly and productively
  
• Covers using SQL Server on Windows 9X as well as Windows NT

Table of contents

Introduction

Hour 1: Introducing SQL Server

Hour 2: Installing SQL Server

Hour 3: Introducing Relational Databases

Hour 4: Database Architecture Fundamentals

Hour 5: Using the Tools and Utilities

Hour 6: Creating Databases, Files, and Filegroups

Hour 7: Creating Tables

Hour 8: Logins and Security

Hour 9: Permissions

Hour 10: Implementing Backups

Hour 11: Restoring Databases

Hour 12: Importing and Exporting Data

Hour 13: Introducing Replication

Hour 14: Replication Scenarios

Hour 15: Implementing Replication

Hour 16: Scheduling Tasks and Alerts

Hour 17: Querying Data

Hour 18: Advanced SELECT Statements

Hour 19: Modifying Data

Hour 20: Stored Procedures

Hour 21: Programming SQL Server

Hour 22: Indexes and Data Integrity

Hour 23: Optimization and Tuning

Hour 24: Troubleshooting

Appendix

Answers

Index