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
