Delphi database training UK class course

Delphi Database Training Course in UK - Delphi Training Class Outline

Delphi Database Development

This course is scheduled or demand, or can be scheduled as a one on one. Click to send an email RE this course.

Duration

5 days

Pre-requisites

A good working knowledge of Delphi. Our Delphi Part I - Fundamentals provides a solid base for this course.

Who Should Attend?

Programmers & consultants who develop Delphi database applications using Any Version of Delphi.

Course Benefits

This Delphi database training course emphasizes productivity, performance, and application integrity. You will use Delphi 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.

You Will Learn How To

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 apps employing a wide range of controls and tools
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

Course Content

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

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

Practical Sessions

Use Visual Form Inheritamce to develop a general purpose database maint 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