Chapter 01. The BDE Administrator and SQL Links
  Explorer Interface
     BDE Administrator Utility
     Database Page
     Configuration Page
  Deploying the BDE
  SQL Links
  Summary
  Review Questions and Exercise
     Questions
     Exercise

Chapter 02. Using the SQL Monitor
  Using the SQL Monitor
  Viewing a SQL Log
  Setting Trace Options
  Summary
  Review Questions and Exercise
     Questions
     Exercise

Chapter 03. Using Sessions
  TSession Components
  TSession Properties
     Private Dir
     NetFile Dir
     KeepConnections
     SQLHourGlass
     ConfigMode
     TraceFlags
  TSession Event Handlers
     OnStartUp
  TSession Methods
     AddAlias
     DeleteAlias
     IsAlias
     ModifyAlias
     SaveConfigFile
  Summary
  Review Questions and Exercise
     Questions
     Exercise

Chapter 04. Using the TDatabase Component
  Controlling Database Connections
  Custom Login Dialogs
  Important Database Component Properties and Methods
    Schema Caching
     Handle
     Temporary
     CloseDataSets and DataSets
     TraceFlags
     Transactions and Transisolation Levels
  Summary
  Review Questions and Exercise
     Questions
     Exercise

Chapter 05. Performance in Client/Server Environments
  Tables vs Queries
  Live vs Non-Live Result Sets
  Filtering
  Using Parameters
  SQL Update Mades
     upWhereAll
     upWhereChanged
     upWhereKeyOnly
  Summary
  Review Questions and Exercise
     Questions
     Exercises
     Extra

Chapter 06. Client/Server Transaction Processing
  Managing Database Transactions
  Transisolation Levels
     tiDirtRead
     tiReadCommitted
     tiRepeatableRead
     Unsupported Levels
  SQLPassThroughMode
  Summary
  Review Questions and Exercise
     Questions
     Exercise

Chapter 07. Refreshing Queries
  Query Insertions
  Top of Result Set
  Summary
  Review Questions and Exercise
     Questions
     Exercise

Chapter 08. Cached Updates
  Overview
  Writing Cache
     ApplyUpdates
  Using the UpdateSQL Component
  Cached Updates in Master Detail Relationships Using a TDatabase
  Summary
  Review Questions and Exercise
     Questions
     Exercise

Chapter 09. Handling Cached Update Errors
  Overview
  OnUpdateError
  Summary
  Review Questions and Exercise
     Questions

Chapter 10. Stored Procedures
  Overview
    Returning a Single Value
     Returning a Set of Records
     Open vs. ExecProc
  Using Strdprcd.ExecProc
  Using a TQuery or TStoredProcedure's Open Method Against a Stored Procedure
  Summary
  Review Questions and Exercise
     Questions
     Exercise

Chapter 11. Advanced Cached Updates
  Overview
  Controlling Cascading Deletes on the Client Side
  Generating Key Values Localy when using Cached Updates
  Summary
  Review Questions and Exercise
     Questions
     Exercise

Chapter 12. Trapping Server Exceptions
  Overview
  Interpreting Default Messages from a Server
  Interpreting SQL Generated Messages from a Server
  Summary
  Review Questions and Exercise
     Questions
     Exercise

Chapter 13. Load Balancing
  Monolithic DataModule
  Entity-Based DataModules
  Monolithic vs Entity-Based
  Multiple Instancing of DataModules
  Summary
  Review Questions and Exercise
     Questions
     Exercise

Chapter 14. Application Partitioning
  Single-tier Applications
    Business Rules Classes
  A Working Example
  Scalability
  Summary
  Review Questions and Exercise
     Questions
     Exercise

Chapter 15. Creating ActiveX Libraries and COM Objects
  Creating ActiveX Libraries
  Adding COM Objects
  Registering ActiveX Libraries
  Creating and Using COM Objects
  Summary
  Review Questions and Exercise
     Questions
     Exercise

Chapter 16. Creating Active Forms
  Creating ActiveX Forms
  An ActiveForm Example
  Deploying ActiveForms
  Summary
  Review Questions and Exercise
     Questions
     Exercise

Chapter 17. Using the Decision Cube
  What is a Decision Cube?
     Definitions
  Components of a Decision Cube
     TDecisionQuery
     TDecisionCube
     TDecisionSource
     TDecisionPivot
     TDEcisionGrid
     TDecisionGraph
  Summary
  Review Questions and Exercise
     Questions
     Exercise

Appendix A. InterBase Event Alerter
  About InterBase Events
  Adding an Event to the InterBase Server
  Catching Events with TIBEventAlerter
  Things to Watch Out For
  Summary
  Review Questions and Exercise
     Questions
     Exercise