| |
| |
| Foreword | |
| |
| |
| About the Contributors | |
| |
| |
| Acknowledgments | |
| |
| |
| Preface | |
| |
| |
| Introduction | |
| |
| |
| SQL Server 7.0 Administration (Exam 70-028) | |
| |
| |
| SQL Server 7.0 Administration Questions | |
| |
| |
| Microsoft SQL Server 7.0 Overview | |
| |
| |
| Capacity and Growth Planning for a SQL Database | |
| |
| |
| Planning Database and Server Security | |
| |
| |
| Planning for Installation | |
| |
| |
| Installing SQL Server | |
| |
| |
| Configuring SQL Server | |
| |
| |
| Monitoring and Tuning SQL Server | |
| |
| |
| Managing Database Files | |
| |
| |
| Managing Security | |
| |
| |
| Automating Administrative Tasks | |
| |
| |
| Backing Up Databases | |
| |
| |
| Methods of Restoring Databases | |
| |
| |
| Transferring Data | |
| |
| |
| Replication | |
| |
| |
| Implementing Replication Scenarios | |
| |
| |
| Setting Up Replication | |
| |
| |
| SQL Server 7.0 Administration Answers | |
| |
| |
| Microsoft SQL Server 7.0 Overview | |
| |
| |
| Capacity and Growth Planning for a SQL Database | |
| |
| |
| Planning Database and Server Security | |
| |
| |
| Planning for Installation | |
| |
| |
| Installing SQL Server | |
| |
| |
| Configuring SQL Server | |
| |
| |
| Monitoring and Tuning SQL Server | |
| |
| |
| Managing Database Files | |
| |
| |
| Managing Security | |
| |
| |
| Automating Administrative Tasks | |
| |
| |
| Backing Up Databases | |
| |
| |
| Methods of Restoring Databases | |
| |
| |
| Transferring Data | |
| |
| |
| Replication | |
| |
| |
| Implementing Replication Scenarios | |
| |
| |
| Setting Up Replication | |
| |
| |
| SQL Server 7.0 Designing and Implementing Databases (Exam 70-029) | |
| |
| |
| SQL Server 7.0 Database Design Questions | |
| |
| |
| Transact-SQL Overview | |
| |
| |
| Creating and Managing Files and Databases | |
| |
| |
| Developing a Logical Data Model | |
| |
| |
| Planning and Creating Indexes | |
| |
| |
| Queries | |
| |
| |
| Summarizing Data | |
| |
| |
| Managing Transactions and Locks | |
| |
| |
| Implementing Views | |
| |
| |
| Implementing Stored Procedures | |
| |
| |
| Implementing Triggers | |
| |
| |
| Working with Distributed and External Data | |
| |
| |
| SQL Server 7.0 Database Design Answers | |
| |
| |
| Transact-SQL Overview | |
| |
| |
| Creating and Managing Files and Databases | |
| |
| |
| Developing a Logical Data Model | |
| |
| |
| Planning and Creating Indexes | |
| |
| |
| Queries | |
| |
| |
| Summarizing Data | |
| |
| |
| Managing Transactions and Locks | |
| |
| |
| Implementing Views | |
| |
| |
| Implementing Stored Procedures | |
| |
| |
| Implementing Triggers | |
| |
| |
| Working with Distributed and External Data | |
| |
| |
| Practice Exams | |
| |
| |
| Test Yourself: Administration Practice Exam 1 (Exam 70-028) | |
| |
| |
| Administration Practice Exam 1 Test Yourself Questions | |
| |
| |
| Administration Practice Exam 1 Test Yourself Answers | |
| |
| |
| Test Yourself: Administration Practice Exam 2 (Exam 70-028) | |
| |
| |
| Administration Practice Exam 2 Test Yourself Questions | |
| |
| |
| Administration Practice Exam 2 Test Yourself Answers | |
| |
| |
| Test Yourself: Database Design Practice Exam 1 (Exam 70-029) | |
| |
| |
| Database Design Practice Exam 1 Test Yourself Questions | |
| |
| |
| Database Design Practice Exam 1 Test Yourself Answers | |
| |
| |
| Test Yourself: Database Design Practice Exam 2 (Exam 70-029) | |
| |
| |
| Database Design Practice Exam 2 Test Yourself Questions | |
| |
| |
| Database Design Practice Exam 2 Test Yourself Answers | |
| |
| |
| About the Web Site | |
| |
| |
| Access Global Knowledge | |
| |
| |
| What You'll Find There | |
| |
| |
| Glossary | |