Building Microsoft® SQL Server® 7 Applications with COM

Sanjiv Purba

Total coverage of the latest SQL Server release, from a leading SQL expert. With the release of Microsoft SQL Server 7, client/server developers must master the latest features and SQL's new architecture—vastly different from earlier editions. To build full-scale business applications, they will also need to learn how to harness the power of COM distributed objects and MTS. This book will ease the pressure, providing a complete tutorial on each developmental phase, from planning and design to prototyping, coding, and reporting.

Table of Contents

  • QUICK START.
    • Getting Started.
    • Learning the Basics of N-Tier Applications and COM.
    • Primer for Building an Application: Part A.
    • Primer for Building an Application: Part B.
    • Leveraging the Project Life Cycle for Build N-TIER, COM Database Applications.
  • BUILDING THE APPLICATION FRAMEWORK.
    • Getting Physical.
    • Defining and Validating Your Data.
    • Using the Data Definition Language.
    • Using the Data Manipulation Language.
    • Using the Data Control Language—Controlling Access to SQL Server.
  • INCORPORATING ADVANCED FEATURES.
    • Writing Stored Procedures (Transact-SQL Programs).
    • Leveraging SQL Server Functions.
    • Triggering Events.
    • Using Advanced Data Manipulation Techniques.
  • BUILD ADVANCED APPLICATION USING COM, INTERNET/INTRANET, VISUAL BASIC, AND MTS.
    • Building a COM-Based, N-Tier Application.
    • Developing the User Interface.
    • Connecting SQL Server to the Internet.
  • DEPLOYING PRODUCTION-READY N-TIER APPLICATIONS AND SYSTEM ADMINISTRATION.
    • Testing, Optimization, Debugging, and Implementation.
    • System Administration Through the Visual Tools and Wizards.
    • Maintaining Your N-Tier COM Applications.
  • Appendix.
  • Bibliography.
  • Index.

Online Ordering

Quantity:

Other ordering options are available.

Copyright © 1999 John Wiley & Sons, Wiley Computer Books

Cover

$39.99
ISBN 0471192333
506 pages
Published: 02/19/1999
Paperback

More Books About:
Database and Data Warehouses