DL201 - Delphi Programming Concepts III

Control-related techniques
Using multi-page forms
Creating ToolBars and StatusBars
Using Actions, ActionLists, the Action Manager
Working with frames
Handling keyboard and mouse input
Dragging and drawing with the mouse
Form handling techniques

DL203 - Client/Server with dbExpress

Overview of client/server architecture in Delphi
Server-side programming
Overview of the dbExpress library
Using MySQL, InterBase, Oracle, Informix, MS SQL Server or IBM DB2 with Delphi
Working with the ClientDataSet component
Working with packets
Handling updates and error reconciliation
Using transactions

DL205 - Working with ADO

Working with and deploying MDAC
Overview of Delphi's dbGo
Working with data link files
Getting schema information
Using the Jet Engine
Utilizing transaction processing
Working with disconnected and persistent recordsets
Understanding the Briefcase Model

SQL201 - SQL: Structuring Queries & Views

Understanding subqueries, their need and how they work
Joins vs. Subqueries - Know the difference
Stick to the rules
Evaluating different return values with subqueries
Nesting of queries
Introducing Views and their advantages
Understanding how views work
Modifying data through views
Copying data
Administration pitfalls

DL207 - WORKSHOP - Step by step from idea to full application

This class will put to use many of the concepts taught in the Intermediate Programming Classes. It will assume a competent knowledge of Delphi fundamentals and foundatinoal concepts. An entire application will be built from the ground up. It is an excellent way to exercise your programming skills. As we build our "8-hour app," as we call it, you will learn how to plan for and create a real-life application that you can use for yourself every day. Topics:

Step by step planning of your application. You should be able to write a user manual before actually writing a single line of code. We will not write the manual, but we will go through the steps of planning our application.
Designing the user interface
Step by step coding
Testing and troubleshooting your application
Deciding on implementation and documentation