Delphi's
Database Tools
SQL
Explorer | BDE Administrator | SQL Monitor
| Query / SQL Builder
BDE Components in Depth
TDataSource / TQuery /
TStoredProc / TField | TDatabase / TSession
| Database maintenance | Searching for records
| Filtering / scoping records | TTable or
TQuery - pros and cons | Using Request Live
Queries
dbExpress
Differences
between dbExpress and BDE | DbExpress Components in depth
| TSQLConnection / TSQLDataSet / TSQLQuery / TSQLTable
/ TSQLStoredProcedure / TSQLClientDataSet | DbExpress
Aliases & Connection Strings | Connecting to a database
| Reading and Updating data | Multiple transaction support
TClientDataSet
Using
the TClientDataSet as a stand alone database | Briefcase
model | Updating a database | Handling Reconcile Errors
| Maintained Aggregates | Sorting on the client
ADO
Express (dbGo)
Differences
between dbGo and BDE | Connecting to a database
using TADOConnection | Read and update data
using the TADOQuery, TADODataSet, and TADOStoredProc.
| TADOCommand - sending information to the
database | Using parameters | Setting timeout
values | ADO Connection String Arguments
| Cursor Types | Lock Types
Standard
SQL in Depth
Thorough
introduction to SQL | Inserting, updating, & deleting
| Grouping & Having clauses | Aggregate
functions | Nested queries | Left, Right
and Full outer joins | SQL Data Definition
Language | Parameterized & linked queries
Database
techniques
Working
with Cached Updates | Using and inheriting Data Modules
| Implementing validation | Handling server side errors
in Delphi | Using an Auto-Increment column as the primary
key | Handling one-to-many relationships
Design of Client Server Applications
How client server databases
send data | Things to avoid with a client
server program | Writing record selection
forms | Creating and modifying SQL dynamically
Editing
Read-Only Datasets
Live
vs. non live data | How to edit read-only
datasets | Using cached updates | Using TClientDataSet
Optimization
Issues
Using
indexes | Managing multiple connections to
the database | Specifying locks for a query
Multi
User Issues
Transaction
Isolation | Understanding the database lock
types | Transaction Processing - Commit and
Rollback
Introduction
to Web Database applications
Using
WebBroker technology to write CGI applications
to return database records to a browser
Other
database products
Advantage
Database Server | Local, server, and internet
| Advantage database applications
