home - about us - contact us

DL106: Delphi® 2010 Database Application Development


Description
Delphi 2010 Database Application Development workshop provides a thorough hands-on introduction to developing client-server database applications. Using the robust features of dbExpress™, other Delphi technologies, you will apply best practices commonly used in modeling and developing a two-tier Rent-a-Car database application. The sample Rent-a-Car application will model many features that are common to all well designed database applications, including data modules, client-side and server-side constraints, CRUD Forms (Create, Retrieve, Update, Delete), transaction control and conflict resolution, centralized error checking, visual inheritance (form re-use), and more. Concepts are taught through text, instructor-led discussions and hands-on lab exercises. Delivery is available thru on-site and virtual led (web-conferencing) classes.

Cost
The cost of this course is $1,495 CDN

Length
2 days or 16hrs, 60% lecture / 40% hands-on activities

Audience
This course is targeted at Delphi developers that want to learn Client/Server database application development.

Prerequisites
Working knowledge of the Windows® operating systems. Basic experience Delphi programming is recommended.

Headings

Introduction to Technologies

  • Client/Server architecture overview
  • TClientDataSet and TDataSetProvider components
  • dbExpress™ technology overview

Developing the Database Structure

  • The challenge: develop a rent-a-car business manager application
  • Modeling and data typing: performance and best practices
  • Data validation and constraints
  • Applying the DDL to create the database

Developing the Client Side Application

  • Implementing Data Modules and best practices
  • Applying data access technologies: dbExpress™, SQLConnection, DataSetProvider and ClientDataSet
  • Implementing client-side data validation
  • Centralized error handling and code re-use
  • Creating CRUD Win32 Forms: query and interface techniques based on visual inheritance
  • Creating CRUD Win32 Forms for Master/Detail Relationship (nested DataSets)
  • Creating Master/Detail Reports
  • Overview on using version control and deploying client side applications

Appendix

  • Using the DataPump to migrate data from the BDE and DBGo (ADO)
 

 

Top Headlines

 


 

home - about us - contact us