D501
- Delphi Database Development
Price:
US $1,995, UK £1,499 + VAT | Duration: 5 days
Programmers
& consultants who develop Delphi database applications using
Delphi 5 or 6.
A
good working knowledge of Delphi. Our Delphi
Programming Fundamentals provides
a solid base for this course.
The course
emphasizes productivity, performance, and application integrity.
You will use Delphi 5 & 6 specific features such as visual
form inheritance, data modules, tClientDataSet, the repository,
cached updates etc. to drastically cut development time and create
more reliable applications. You'll learn the four different ways
of accessing data in Delphi - BDE, ADO, dbExpress (Delphi 6 and
Kylix), and custom third party database solutions. You'll also
learn how to publish data on the Web using CGI and WebBroker.
- Design
and implement client server, desktop, and Internet database
applications
- Make
good use of the database tools and components in Delphi to
increase productivity
- Program
in standard SQL
- Develop
multi-table, multi-user applications employing a wide range
of controls and tools - to be deployed against local and client
server databases
- Manage
database integrity violations in your Delphi application
- Configure
the BDE, ADO, and dbExpress
- Peek
under the hood of database applications using SQL Monitor
- Use dbExpress
to create database applications without using the BDE
- Use dbGo
(ADO) as an alternative to the BDE
- Use TClientDataSet
with the BDE and dbExpress
- Publish
data on the Web using CGI and WebBroker technologies
D103
- Object Oriented Programming w/Delphi
D601
- Delphi Multi-tier Development
D301
- Delphi Power Programming
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
- Use visual
form inheritance to develop a general purpose database maintenance
form to work against any database / table
- Use the
BDE, dbGo and dbExpress to create database applications
- Use data
modules to share database information among forms
- Convert
applications from using the BDE to dbGo and dbExpress
- Build
internet database applications using CGI applications and
Web Broker technology
