Microsoft SQL Server 7 Applications with COM

This book helps you to quickly master all the latest features of SQL Server 7's revised architecture. It also provides you with a complete, step-by-step tutorial on creating n-tier client/server and intranet applications using SQL Server 7 with COM objects and MTS, Expert Sanjiv Purba walks you through each stage of planning,
database design, and prototyping, to coding, testing, and reporting providing sample code
(and resulting output) for the techniques described.

Key topics receiving in-depth, practical coverage Include:

• SQL 7 design and architecture
  
• COM and MTS architectures
  
• SQL 7 installation-covered in a quick-reference installation guide
  
• Database objects, data functions, formats and other critical new SQL features
  
• Server-side database programming with stored procedures, triggers, views, and other techniques
  
• Developing n-tier applications with COM, MTS, and ASP
  
• Leveraging Transact SQL in developing n-tier applications
  
• N-tier implementation guidelines
  
• Database roles and responsibilities on a project
  
• Systems management

Table of contents

Preface

Part One Quick Start

Chapter 1 Getting Started

Chapter 2 Learning the Basics of N-Tier Applications and COM

Chapter 3 Primer for Building an Application: Part A

Chapter 4 Primer for Building an Application: Part B

Chapter 5 Leveraging the Project Life Cycle to Build N-Tier

Part Two Building the Application Framework

Chapter 6 Getting Physical

Chapter 7 Defining and Validating Your Data

Chapter 8 Using the Data Definition Language

Chapter 9 Using the Data Manipulation Language

Chapter 10 Using the Data Control Language-Controlling Access
to SQL Server

Part Three Incorporating Advanced Features

Chapter 11 Writing Stored Procedures (Transact-SQL Programs)

Chapter 12 Leveraging SQL Server Functions

Chapter 13 Triggering Events

Chapter 14 Using Advanced Data Manipulation Techniques

Part Four Build Advanced Applications Using COM, Internet/intranet, Visual Basic, and MTS

Chapter 15 Building a COM-Based, N-Tier Application

Chapter 16 Developing the User Interface

Chapter 17 Connecting SQL Server to the Internet

Chapter 18 Testing Optimization, Debugging, and implementation

Chapter 19 System Administration through the Visual Tools and Wizards

Chapter 20 Maintaining Your N-Tier COM Applications

Appendix A Relational Data Modeling, Normal Forms, and Other Models

Bibliography

Index