Jensen Data Systems Inc  

TRAINING * CONSULTING * MENTORING * DEVELOPMENT

We provide Internet and database application training, development, documentation, and help system services. We support Delphi XE4, XE3, XE2, XE, and all earlier versions of Delphi, and Sybase's Advantage Database Server.

Phone: 281-359-3311 Email: info at JensenDataSystems.com

Delphi 7 Training

 

Embarcadero 

Technologies

Jensen Data Systems, Inc. provides Delphi 7 training by JDSI CTO Cary Jensen, Ph.D., one of the world's leading Delphi trainers. With onsite training, we can come to your site and it has never been more affordable. Get training for up to 10 developers for a competitive flat daily rate. Onsite training can be delivered using either lecture-style or hands-on techniques, and you can choose from a large selection of available topics.

Following are seminars available for Delphi 7. Many of these seminars can apply to previous versions of Delphi as well (see the "Delphi Version" listed for the particular seminar). We may also be able cover topics not listed online. Select our available seminar or have us put together a custom training seminar to cover just the topics you need.

For more information, including pricing and scheduling, please contact us.

Delphi 7 Training Seminars
Click on a seminar name below for a description
# of Days
Hands-on
# of Days
Lecture
Level Detailed Outline
Delphi Jump Start A comprehensive seminar on object-oriented programming and application development in Delphi 4 days 3 days Beg-Int Outline in pdf format
Delphi Database Development: In-Depth A comprehensive seminar on Delphi Database Development. Combines Database Development in Delphi topics with an in-depth focus on ClientDataSets 4 days 3-4 days Beg-Adv Outline in pdf format
Delphi RAD Development and Component Creation 2 days 2 days Beg-Int Outline in pdf format
Extreme Delphi: Tips, Tricks, and Techniques 2 days 1 day All levels Outline in pdf format

Extreme Delphi Reloaded: Tips, Tricks, and Techniques
An enhanced version of our most popular seminar

3 days 2 days All levels Outline in pdf format
Mastering Multithreading and Other Advanced Programming Topics Multithreading, Threads, Synchronization, DLLs, Windows Resources, and RTTI-Runtime Type Information 3 days 2 days Int-Adv Outline in pdf format
Delphi Interfaces and COM 2 days 2 days Int-Adv Outline in pdf format
Internet Development with Delphi 2-3 days 2 days Int Outline in pdf format
Delphi Web Services, XML, and Socket Programming 2 days 2 days All levels Outline in pdf format
Developing Web Applications Using IntraWeb 2 days 2 days Int Outline in pdf format
Using Delphi with Advantage Database Server 2 days 1 day All levels  
Database Development with Delphi 2 days 2 days Beg-Int  
Advanced Database Development Techniques 2 days 2 days Int-Adv  
Exploiting Delphi ClientDataSets 2 1/2 days 2 days Int-Adv  
<top of page>

Custom Delphi Seminars
Select from our available seminars above or have us put together a custom training seminar that covers just the topics you need. You can combine any topics described in our available seminars. You can also include any of the following additional Delphi topics (we have courseware for these topics). We may also be able cover topics not listed here.

Additional topics available for Delphi include multithreaded programming, debugging tips and tricks, writing and using DLLs (dynamic link libraries), using runtime type information (RTTI), creating and using Windows resources, customizable keymappings, understanding frames, ActiveX Data Objects (ADO), InterBase Express, Internet Express, internationalization issues, DFM resources as Text, using the ApplicationEvent object, control over auto-created forms, managing TeamSource, MIDAS in Delphi 5, writing DataSnap applications, and much, much more.

Combining Training with Consulting and Mentoring
Need assistance in the design, development, and/or deployment of your applications? Need a hand solving a problem? We can help. Cary Jensen can combine training with consulting, focusing on your particular application. Let's work side-by-side on your application and get those problems solved! For more information, please contact us.

<top of page>

 Delphi Jump Start: Object-Oriented Programming and Application Development in Delphi
This seminar is designed to provide developers with a foundation in the principles and techniques of object-oriented programming using Delphi and application development in Delphi. It begins with an overview of Delphi and Delphi's Integrated Development Environment (IDE), and then quickly moves on to a discussion of application development. Basic techniques that are used in almost every Delphi application are discussed, including how to configure components, creating event handlers, as well as efficient use of forms (windows). Basic database techniques are also covered, as well as how to manage exceptions (runtime errors). Delphi tips and tricks are included throughout the seminar.

View a detailed outline of topics (pdf format).
Following is a general outline of topics covered in this seminar:

  • Overview of Delphi
  • Understanding Components
  • Using the Object Repository
  • Building Database Applications in Delphi
  • Event Handlers
  • Adding Menus and Additional Forms
  • Working with Fields
  • Controlling Tab Order
  • Exception Handling in Delphi
  • Data Validation
  • Using Data Modules
  • Creating And Using DLLs
  • Power Debugging Techniques
  • Leveraging Visual Form Inheritance
  • Using Component Templates
  • Understanding Frames
  • Objects, Components, And Packages
  • Overview Of Packages
  • Overview Of Objects
  • Introduction To Component Creation
  • Defining New Property Defaults in Components
  • Creating The Design-Time Package
  • An Example With Properties
  • Raising Property Visibility
  • Reintroduced Methods
  • Methods And The Implied Contract
  • Advanced Component Design Issues
  • Property Editors
  • Creating Component Editors
  • Overview Of The Property Editor And Component Editor Wizards
  • Appendix A: Understanding Objects

Seminar Length: 4 days for hands-on training, 3 days for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a 230+ page detailed coursebook along with all code examples presented during the seminar as well as extra code examples.
Prerequisites: A basic familiarity with the principles of software development and experience with one or more programming languages. Prior experience with Delphi is not necessary.
Delphi Version: Delphi 7, Delphi 6, Delphi 5
<top of page>

 

Delphi Database Development: In-Depth

Here it is -- the definitive seminar for every Delphi database developer presented by one of the world's leading experts in Delphi database development. If you are a seasoned database developer, this seminar will both confirm that you are currently doing things the right way as well as expose you to a valuable collection of new tricks and techniques. If you are new to Delphi database development, this seminar will save you valuable time by showing you how it's done. Topics are applicable to Delphi 7 and Delphi 6 (Professional and higher) and Delphi 5 (Enterprise and higher). Topics also apply to Delphi 2007, Delphi 8 using VCL.NET (Enterprise and higher), and Delphi 2005 (either for Win32 Delphi development or Delphi 2005 for VCL.NET). The Delphi Database Development: In-Depth coursebook is over 215+ pages, includes numerous code examples, and is the definitive book on Delphi Database Development and ClientDataSets.

This seminar has two primary objectives. The first is to provide you with a solid foundation in the TDataSet class, the base class for data access in Delphi applications. Here you will learn about Delphi's various data access technologies, including the Borland Database Engine (BDE), ActiveX Data Objects (ADO), InterBase Express, dbExpress, MyBase, DataSnap, and third party data access solutions. The advantages and limitations of each of these technologies are considered, as well when and where to use each.

The second focus of this seminar, and the one that is most likely to influence the way you build database applications, is on ClientDataSets, Delphi's high-performance, in-memory data store. ClientDataSets can be used in almost any application where data must be stored or manipulated, even those already using one of Delphi's other data access technologies.

The wealth of features that ClientDataSets can add to your existing or new applications is staggering. These include dynamic dataset creation, local XML storage, dynamic indexing, ultra-fast in-memory searches and filtering, aggregate fields, cloned cursors, editable heterogeneous queries, to name a few of the ClientDataSet features that are explained and demonstrated in this seminar, lead by the industry's leading authority on ClientDataSets.

View a detailed outline of topics (pdf format).
Following is a general outline of topics covered in this seminar:

  • Overview of Delphi Database Development
  • The TDataSet interface
  • Using Tables, Queries, and Stored Procedures
  • Delphi Data Access Technologies Compared and Contrasted
  • Third-Party Data Access in Delphi
  • Understanding the ClientDataSet Datastore
  • Loading ClientDataSets from Files and DataSets
  • ClientDataSet Deployment Issues
  • ClientDataSets and XML
  • Understanding the ClientDataSet/DataSetProvider Interaction
  • Applying Updates through a DataSetProvider
  • ClientDataSets and the Change Log
  • Defining ClientDataSet Structure Using FieldDefs and TFields
  • Understanding ClientDataSet Indexes
  • Creating and Using Aggregate Fields
  • Indexes and ClientDataSet GroupState
  • Cloning ClientDataSet Cursors
  • Creating and Using NestedDataSets
  • Understanding UpdateMode and ProviderFlags
  • Resolving Updates to DataSets
  • Writing BeforeUpdateRecord Event Handlers
  • Resolving Update Failures Using OnReconcileError Event Handlers
  • Using ClientDataSets with Borland’s dbExpress
  • dbExpress Application Deployment Options
  • Using ClientDataSets with Borland’s DataSnap
  • Controlling Application Servers through the Client ClientDataSet
  • Using the ClientDataSet CommandText Property
  • Controlling Parameterized Queries Using the ClientDataSet Params Property
  • Paging Data Using PacketRecords, FetchOnDemand, and OwnerData

Seminar Length: 3-4 days for hands-on training, 3-4 days for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a 215+ page detailed coursebook along with all code examples presented during the seminar as well as extra code examples.
Prerequisites: A basic familiarity with Delphi. Database experience helpful for ClientDataSet related topics.
Delphi Version: Delphi 7, Delphi 6, Delphi 5. Also applies to Delphi 2007, Delphi 8, and Delphi 2005 (either for Win32 Delphi development or Delphi 2005 for VCL.NET)
<top of page>

 

Delphi RAD Development and Component Creation
Learn how to create your own custom components to increase your productivity and simplify application maintenance. This seminar begins with an introduction to visual form inheritance, how and when to use component templates, as well as an in-depth discussion of frames. The remainder of the seminar provides you with a well-rounded examination of component design issues, including how to create properties, custom methods, and events. The philosophy of sound component development is emphasized throughout.

View a detailed outline of topics (pdf format).
Following is a general outline of topics covered in this seminar:

  • Leveraging Visual Form Inheritance
  • Using Component Templates
  • Understanding Frames
  • Objects, Components, and Packages
  • Working with Packages
  • Overview of Objects
  • Introduction to Component Creation
  • A Simple Component Example
  • Defining New Property Defaults
  • Creating the Design-Time Package
  • An Example with Properties
  • Raising Property Visibility
  • Reintroduced Methods
  • Methods and the Implied Contract
  • Advanced Component Design Issues
  • Property Editors
  • Creating Component Editors
  • Property Editor Wizards
  • Component Editor Wizards

Seminar Length: 2 days for hands-on training, 2 days for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a 110+ page detailed coursebook along with all code examples presented during the seminar as well as extra code examples.
Prerequisites: A basic familiarity with Delphi.
Delphi Version: Delphi 7, Delphi 6, Delphi 5
<top of page>

 

Extreme Delphi: Tips, Tricks, and Techniques
One of the most popular seminars, Extreme Delphi provides you with a potent grab bag of useful programming tools and technologies. From how to get the most out of the code editor to the debugging secrets of the experts, from controlling other applications to the art of writing Wizards, this seminar has something for every Delphi developer. The name says it all.

View a detailed outline of topics (pdf format).
Following is a general outline of topics covered in this seminar:

  • Code Editor Secrets
  • Power Debugging Techniques
  • Syntax Sleight-Of-Hand
  • Useful Compiler Directives
  • Controlling Other Processes
  • Using Application Versioning
  • Writing and Debugging Wizards
  • Persisting Information: INI Files and the Windows Registry
  • Preventing Multiple Instances of an Application
  • Tricking a Window Drag Operation
  • Adding Wallpaper to a Form
  • The Speed of Streams
  • Getting Short File Names and Path Names
  • Restricting the Mouse Cursor
  • Launching Control Panel Applets
  • Loading a Web Site from a Delphi Application
  • And Much, Much More

Seminar Length: 2 days for hands-on training, 1 day for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a 130+ page detailed coursebook along with all code examples presented during the seminar as well as extra code examples.
Prerequisites: A basic familiarity with Delphi. Some experience with component design is useful, but not required.
Delphi Version: Delphi 7, Delphi 6, Delphi 5
<top of page>

 

Extreme Delphi Reloaded: Tips, Tricks, and Techniques
Our all-time most popular seminar is better than ever. By expanding to this seminar, we now cover even more essential, undocumented, and powerful secrets to improve your Delphi applications and productivity. Topics are applicable to Delphi 7, Delphi 6, and Delphi 5 (Professional and higher). Topics also apply to development in Delphi 2005 (Win32 development, some .NET and VCL.NET development). Many topics also apply to Delphi 8 (Professional and higher). This is one seminar that you cannot afford to miss.

View a detailed outline of topics (pdf format).
Following is a general outline of topics covered in this seminar:

  • Code Editor Secrets
  • Power Debugging Techniques
  • Understanding Interfaces *
  • Using Interfaces in Real-World Applications
  • Syntax Sleight-Of-Hand
  • Working with Runtime Type Information (RTTI) *
  • Useful Compiler Directives
  • Multithreaded Programming *
  • Thread Synchronization *
  • Controlling Other Processes
  • Using Application Versioning
  • Writing and Installing Editor Keybindings
  • Persisting Information: INI Files and the Windows Registry
  • Preventing Multiple Instances of an Application
  • Creating Objects from String References *
  • The Speed of Streams
  • Windows API Programming Tricks
* Hot new topics added to "Extreme Delphi"

Seminar Length: 3 days for hands-on training, 2 days for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a 200+ page detailed coursebook along with all code examples presented during the seminar as well as extra code examples.
Prerequisites: A basic familiarity with Delphi. Some experience with component design is useful, but not required.
Delphi Version: Delphi 7, Delphi 6, Delphi 5
<top of page>

 

Mastering Multithreading and Other Advanced Programming Topics
(Multithreading, Threads, Synchronization, DLLs, Windows Resources, and RTTI - Runtime Type Information)

Are you ready to take your Delphi development to a whole new level? If so, you will want to attend Mastering Multithreading and Other Advanced Topics. Here you will learn the advanced techniques that empower you to write exceptional software.

The main topic of this seminar is multithreaded programming. Once considered a luxury, threads are now an essential part of many applications. And they are not hard to implement, once you learn how to do it right. Whether you need to add threads to enable advanced features in your existing applications, or you are working with one of Delphi's multithreaded frameworks, such as Web Broker, DataSnap, or IntraWeb, this seminar shows you how to create and use threads safely. Topics covered include creating, configuring, executing, and terminating threads. You will also learn how and when to use many of Delphi's synchronization objects, including critical sections, TEvents, TThreadLists, and MultiReadExclusiveWriteSynchronizers.

Next we turn our attention to writing and using DLLs. Learn how you can share your Delphi functions and procedures between applications, even those written in other languages. Topics discussed include exporting functions from DLLs, statically and dynamically loading DLLs, writing import units, and much more.

Next you will learn how to integrate data into your executable using resources. Among the topics discussed here include using the Borland resource command-line compiler, writing resource scripts, creating string, bitmap, icon, and cursor resources; compiling resources into your executables, and accessing your resources at runtime. Creating and using resource DLLs is also discussed.

This workshop concludes with an in-depth look at runtime type information (RTTI), a feature of Delphi that permits you to perform runtime inspection of classes and objects. If you like to write reusable code, and have not been using RTTI, you'll wonder how you ever lived without it. RTTI can help you perform miracles, making your code more manageable in the process.

View a detailed outline of topics (pdf format).
Following is a general outline of topics covered in this seminar:

  • What Are Threads, and Why Do You Need Them
  • Adding Threads of Execution to an Application
  • Controlling Thread Priority
  • Understanding Thread Synchronization and Blocking
  • Synchronization Options
  • Using the Synchronize Method
  • Creating and Using Critical Sections
  • Using Mutexes
  • Using Semaphores
  • Connection Pooling
  • Understanding ThreadVar
  • Using Threadlists and MultiReadExclusiveWriteSynchronizers
  • Creating and Waiting for Events
  • Multithreaded Access to Databases
  • Creating Stress Testers
  • A Database Server Stress Tester
  • A HTTP Stress Tester
  • Compiling DLLs
  • Exporting Functions and Procedures from DLLs
  • Passing Strings to and from DLLs
  • Statically Loading DLLs
  • Writing Import Units
  • Calling DLLs from Your Delphi Applications
  • Accessing Forms Stored in DLLs
  • Dynamically Loading and Unloading DLLs at Runtime
  • Understanding Windows Resources
  • Writing Resource Scripts
  • Using the BRCC32 Compiler
  • Linking Resource Files into your Executables
  • Loading Resources at Runtime
  • Writing Resourcestring Blocks
  • Understanding Runtime Type Information (RTTI)
  • Getting the String Value of Enumerated Types
  • Determining Object Properties
  • Accessing "Hidden" Properties and Methods
  • Going Beyond Polymorphism

Seminar Length: 3 days for hands-on training, 2 days for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a detailed coursebook along with all code examples presented during the seminar as well as extra code examples.
Prerequisites: A basic familiarity with Delphi development.
Delphi Version: Delphi 7, Delphi 6, Delphi 5
<top of page>

 

Delphi Interfaces and COM
Learn how to better reuse your development efforts with this detailed and intense look at implementing COM solutions in Delphi. This seminar begins with an in-depth discussion of interfaces, including the theory and practice of their use. Next, the most common form of COM deployment, automation, is covered in detail. Here you learn how to create both COM servers and COM controllers. Topics discussed include architectures that simplify COM development, COM server registration and deployment, creating and importing type libraries, as well as writing both early and late binding controllers. ActiveX, a special case of COM server, is discussed next. Topics covered here include creating ActiveX servers from Delphi components, deploying ActiveX components for use by Web browsers, creating property pages, and building ActiveForms. This seminar concludes with a look at transaction objects (called MTS objects in NT 4.0) for building distributed applications.

View a detailed outline of topics (pdf format).
Following is a general outline of topics covered in this seminar:

  • Understanding Interfaces
  • Interface Implementation by Delegation
  • Overview of COM
  • Understanding Automation
  • Creating Automation Servers
  • Defining Type Libraries
  • Implementing COM Interfaces
  • COM+ and the Windows Registry
  • Accessing COM Servers Using Delphi
  • Importing Type Libraries
  • Creating ActiveX Servers
  • Deploying ActiveX Servers via Web Pages
  • Understanding COM+ Component Services
  • Writing and Installing COM+ Objects

Seminar Length: 2 days for hands-on training, 2 days for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a 100+ page detailed coursebook along with all code examples presented during the seminar as well as extra code examples.
Prerequisites: . Attending Delphi RAD Development and Component Creation or equivalent experience or training with the following topics is highly recommended: Delphi's object model, class type declarations and design, component creation, DLLs, and multithreaded programming.
Delphi Version: Delphi 7, Delphi 6, Delphi 5
<top of page>

 

Internet Development with Delphi
Making new or existing applications available on an intranet or the Internet is a major goal of nearly every IT organizations, and this seminar shows you how to do it quickly and easily. It begins by providing an understanding of Internet-related technologies and protocols, including TCP/IP, HTTP, HTML, and XML. It continues with a detailed examination of the client/server interaction of the World Wide Web, and the role that HTML plays in the building of browser-based user interfaces. This all leads up to the core content of this seminar - Web Broker - Delphi and Kylix's powerful technology for Building Web server extensions. Topics discussed include configuring WebActionItems, working with providers, and creating sophisticated, dynamic Web sites, including those that are data based. Active Server Pages (ASPs) are next on the agenda. Here you learn how ASPs are different from Web server extensions, and how to leverage Delphi's COM support to build custom Active Server objects. This seminar concludes with a detailed discussion of WebSnap, Borland's powerful new technology for creating sophisticated Web sites. Here you will learn how to use adapters and producers, along with HTML templates and scripting instructions, to build interactive Web sites the Delphi way.

View a detailed outline of topics (pdf format).
Following is a general outline of topics covered in this seminar:

  • Overview of Internet Protocols and Technologies
  • Understanding the World Wide Web
  • User Interface Development with HTML Forms
  • Overview of Web Broker
  • Building Dynamic Database Web Applications with Web Broker
  • Advanced Web Broker Techniques
  • Understanding Active Server Pages
  • Building Active Server Objects with Delphi
  • Understanding and Using WebSnap
  • Team Development with WebSnap Modules

Seminar Length: 2-3 days for hands-on training, 2 days for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a100+ page detailed coursebook along with all code examples presented during the seminar as well as extra code examples.
Prerequisites: Attending Delphi Interfaces and COM or familiarity with COM is recommended. Familiarity with Delphi database development is also useful.
Delphi Version: Delphi 7, Delphi 6
<top of page>

 

Delphi Web Services, XML, and Socket Programming
Web services is the hottest technology on the Internet landscape, and this seminar provides you with the information you need to begin creating and using Web services today. Web services use XML to invoke remote procedure calls across a TCP/IP network, so XML is where this discussion starts. Here you learn the basic structure of XML, including XML namespace, and how to use Delphi's powerful new XML components and Wizards to create XML-aware applications. This discussion continues with socket programming, a technology that provides you with the greatest power and flexibility for your Internet-aware applications. Last, but definitely not least, this discussion turns to Web services. Here you will learn how you can use Delphi to build powerful and flexible distributed applications using Web services, without the cost and configuration of technologies such as CORBA (common object request broker architecture) or DCOM (distributed COM). Topics discussed include remote interface design, implementation, and invocation; the simple object access protocol (SOAP); Web services description language (WSDL); and much, much more.

View a detailed outline of topics (pdf format).
Following is a general outline of topics covered in this seminar:

  • Describing Data Using XML
  • MyBase: ClientDataSet and XML
  • Document Object Model (DOM) Programming
  • Creating and Using XML Transformations
  • Overview of Socket Programming
  • Using Delphi's Socket Components and Internet Direct
  • Overview of Web Services and the Simple Object Access Protocol (SOAP)
  • Creating Web Service Servers with Delphi
  • Building Web Service Clients Using Delphi

Seminar Length: 2 days for hands-on training, 2 days for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a 90+ page detailed coursebook along with all code examples presented during the seminar as well as extra code examples.
Prerequisites: Attending Internet Development with Delphi and Delphi Interfaces and COM, or equivalent familiarity with those topics is highly recommended. Familiarity with Delphi database development is also useful.
Delphi Version: Delphi 7, Delphi 6

<top of page>

 

Developing Web Applications Using IntraWeb
IntraWeb is a revolutionary component-based framework for creating Web sites using Delphi and Kylix. Using IntraWeb, you can quickly and efficiently create world-class Web sites using an approach similar to traditional Delphi development, and this seminar shows you how.

This seminar begins with an overview of IntraWeb development, including an examination of the two primary modes of development: application mode and page mode. It continues with a systematic look at the application mode development. Here you learn how to configure and deploy your IntraWeb server, manage user state information, restrict access to authorized users, and manage your IntraWeb forms. Additional topics include using HTML templates to separate application logic from the presentation, sharing resources between user sessions, serving secure data, as well as building ISAPI Web server extensions.

A major focus of this seminar is serving data from a database on the Internet. If you need to create a Web site, large or small, you cannot afford to miss this informative seminar.

View a detailed outline of topics (pdf format).
Following is a general outline of topics covered in this seminar:

  • Understanding the World Wide Web
  • Overview of IntraWeb Development
  • Creating a Basic IntraWeb Project
  • Building Custom IntraWeb Project Templates
  • Working with IntraWeb AppForms
  • Understanding IntraWeb Components
  • Creating Custom IntraWeb AppForm Templates
  • Building Stand-Alone Applications Using Application Mode
  • Configuring the ServerController
  • Persisting State Information Using TSessionUser
  • Understanding WebApplication Sessions
  • Configuring WebApplications
  • Managing Forms
  • Serving Database Data
  • Creating and Using HTML Templates
  • Serving Static Content
  • Debugging IntraWeb Applications
  • Installing Stand-Alone Applications as Services
  • Converting Stand Alone Applications to ISAPI Applications
  • Creating ISAPI IntraWeb Applications
  • Reading Parameters in ISAPI Applications
  • Using Secure Socket Layer (SSL)
  • Using IntraWeb in Page Mode
  • Creating Custom IntraWeb Components

Seminar Length: 2 days for hands-on training, 2 days for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a detailed coursebook, code templates, and source code for more than 10 IntraWeb demonstration projects.
Prerequisites: A basic familiarity with Delphi development.
Delphi Version: Delphi 7

<top of page>

 

Using Delphi and Advantage Database Server
This seminar begins with a general overview of the ADS architecture. During this section we will install the Advantage Database Server, the Advantage Local Server (ALS), the Data Architect, and the Delphi-related ADS components. In this section you will learn how to import existing data into ADS tables, create and modify ADS tables, create data dictionaries, create users and groups, define constraints, write views, and configure referential integrity. We will also show you how to secure your database from unwanted access, as well as to define table-level and field-level rights. Also included in this section is a discussion of Advantage Replication, the new database replication technology from iAnywhere (formerly Extended Systems), permitting you to keep your data up-to-date across multiple locations. Taken together, these topics provide you with everything you need to know to begin implementing your own remote database server solutions using ADS today.

The remainder of this seminar focuses on using ADS with Delphi. Topics covered here include configuring ADSConnection components, accessing data using the ADSTable, writing SQL queries for use with ADSQuery components, executing views, writing and debugging Advantage Extended Procedure (AEP) stored procedures, and programmatically manipulating your data dictionaries. Following is a list of some of the topics covered in this workshop:

  • Building Scalable Solutions Using Advantage Local Server and Advantage Database Server
  • Understanding Database Replication
  • Defining a Database Using the Data Architect (ARC)
  • Defining Tables and Indexes
  • Defining Referential Integrity and Creating Constraints
  • Importing Existing Data into ADS Tables
  • Encrypting Tables and Databases
  • Controlling User Access Using Users and Groups
  • Understanding the ADS Delphi Components
  • Implementing Standard Database Solutions in Delphi Using ADS
  • Understanding ADO and the Advantage OLE DB Provider
  • Configuring and Using the Advantage ODBC Driver
  • Building Advantage Extended Procedure Stored Procedures Using Delphi
  • And Much, Much More

Seminar Length: 2 days for hands-on training, 1 day for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a 90+ page detailed coursebook along with all code examples presented during the seminar as well as extra code examples.
Prerequisites: A basic familiarity with databases as well as a basic familiarity with either Delphi, C#, or C++.

<top of page>

 

 

Database Development with Delphi
This seminar provides a solid foundation in Delphi database development. It begins with an overview of Delphi's data-related architectures, including the BDE, ADO, dbExpress, MyBase, and IBExpress. It then takes a detailed look at a variety of database programming techniques. This discussion begins with a look at the TDataSet interface, including filters, navigation, editing, Fields (including calculated and lookup fields), FieldDefs, and IndexDefs. This is followed by an in-depth discussion of data-aware controls, including DBGrid, TColumns, DBLookup components, and more. Additional topics show you how to optimize your use of queries and stored procedures, understand your reporting options, and how to create professional business graphs using TChart.

  • Overview of Delphi Database Development
  • Configuring the Borland Database Engine
  • Configuring and Deploying dbExpress Applications
  • Understanding Delphi's Data Access Components
  • Programming with the TDataSet Interface
  • Using Persistent Fields
  • Leveraging Delphi's Data-Aware Controls
  • Working with Queries and Stored Procedures
  • Basic Reporting with Quick Reports (Delphi 5, Delphi 6)
  • Basic Reporting with Rave Reports (Delphi 7)
  • Creating Business Graphs with TChart

Seminar Length: 2-3 days for hands-on training, 2 days for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a 135+ page detailed coursebook along with all code examples presented during the seminar as well as extra code examples.
Prerequisites: Programming experience. Familiarity with Delphi programming is recommended.
Delphi Version: Delphi 7, Delphi 6, Delphi 5

<top of page>

 

Advanced Database Development Techniques
Expand your database development repertoire with this in-depth look at advanced Delphi database development techniques. Learn how to add enhanced features to your applications through cached updates, build thin clients for the InterBase RDBMS, and exploit the features of the ClientDataSet component. A major focus of this seminar is dbExpress, the new, cross-platform, high-performance data-access technology for 6 and Kylix. Here you will learn how to managed SQL connections, utilize unidirectional datasets, exploit dataset providers, and deploy dbExpress applications. These topics set the stage for a detailed look at DataSnap (formerly known as MIDAS), Borland's powerful multi-tier development technology.

  • Using Cached Updates
  • Using ActiveX Data Objects (ADO) Data Link Files
  • Programming ClientDataSets
  • Using Nested DataSets
  • Overview of Programming with dbExpress
  • Advanced dbExpress Programming Techniques
  • Building DataSnap Application Servers
  • Creating DataSnap Thin Clients
  • Configuring Remote Queries
  • Using Delphi's Connection Components

Seminar Length: 2 days for hands-on training, 2 days for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a 125+ page detailed coursebook along with all code examples presented during the seminar as well as extra code examples.
Prerequisites: Attending Database Development with Delphi or familiarity with Delphi database development.
Delphi Version: Delphi 7, Delphi 6
<top of page>

 

Exploiting Delphi ClientDataSets
A ClientDataSet provides you with an in-memory data store that is both high-performance and rich in features. Since the release of Delphi 6 and Kylix, Borland has included the ClientDataSet in the Professional versions of their products. As a result, it is now available to all Delphi and Kylix developers. The widespread availability of ClientDataSet has important implications for most applications, especially database applications. Specifically, developers should consider using this powerful and flexible component in nearly every situation where data must be stored, manipulated, or displayed.

In database applications, the ClientDataSet can be used to provide a layer of abstraction between your code and the underlying data access mechanism, such as the Borland Database Engine (BDE), ActiveX data objects (ADO), and dbExpress. Used in this way, the ClientDataSet provides your applications with a consistent set of features for both your data aware components and your programmatic manipulation of data. It also provides a lightweight alternative to database servers and local database engines for single-user applications. For non-database applications, the ClientDataSet provides a flexible alternative to TStringLists, linked lists, INI files, and other temporary and persistent local storage mechanisms.

This seminar provides you with the information that you need to be productive with ClientDataSet today. It begins with an overview of the ClientDataSet, including how to configure it and how it works. It then continues with an in-depth and detailed look at using the ClientDataSet features. Other topics that are discussed include dbExpress, Borland’s SQL-based data access mechanism, as well as DataSnap, Borland’s multi-tier distributed application framework. We examine the following topics:

  • Understanding the ClientDataSet Datastore
  • Loading ClientDataSets from Files and DataSets
  • ClientDataSet Deployment Issues
  • ClientDataSets and XML
  • Understanding the ClientDataSet/DataSetProvider Interaction
  • Applying Updates through a DataSetProvider
  • ClientDataSets and the Change Log
  • Defining ClientDataSet Structure Using FieldDefs and TFields
  • Understanding ClientDataSet Indexes
  • Creating and Using Aggregate Fields
  • Indexes and ClientDataSet GroupState
  • Cloning ClientDataSet Cursors
  • Creating and Using NestedDataSets
  • Understanding UpdateMode and ProviderFlags
  • Resolving Updates to DataSets
  • Writing BeforeUpdateRecord Event Handlers
  • Resolving Update Failures Using OnReconcileError Event Handlers
  • Using ClientDataSets with Borland’s dbExpress
  • dbExpress Application Deployment Options
  • Using ClientDataSets with Borland’s DataSnap
  • Controlling Application Servers through the Client ClientDataSet
  • Using the ClientDataSet CommandText Property
  • Controlling Parameterized Queries Using the ClientDataSet Params Property
  • Paging Data Using PacketRecords, FetchOnDemand, and OwnerData

Seminar Length: 2 days for hands-on training, 2 days for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a 100+ page detailed coursebook along with all code examples presented during the seminar as well as extra code examples.
Prerequisites: Attending Database Development with Delphi or familiarity with Delphi database development.
Delphi Version: Delphi 7 and Delphi 6 version (Professional, Enterprise, or Studio editions) or Delphi 5 Enterprise
<top of page>

JDSI HOME


Copyright © 2004-2011 Jensen Data Systems, Inc., Ph: 281-359-3311, Email: info at JensenDataSystems.com