DL101 - Introduction to Delphi
 Introduction to Delphi, a brief history and overview and a general coverage of features that make it such a powerful development tool.
The concept of Windows as Forms (using components and templates, learning about events and how to respond to them, adding code and examining source code, all about the use of properties)
The Delphi Environment - (review of all menus, understanding the form designer and code editor, managing projects, exploration of a program, the Delphi file system)
Delphi Wizards and Templates - overview of wizards and templates and how to add to them
Object Repository - what it is and how to use it
Delphi components - An overview of the components, how to configure them and add new ones to the list
How to create and handle menus, and attach to events
The Help System and how to maximize its benefits |
DL102 - Pascal Basics
Delphi is based on Object Pascal. While Delphi does a great deal for you without coding, you will eventually have to write code. This course covers the basics of Pascal and goes beyond an introductory coverage of the concepts. You will also learn some advanced programming concepts. We will cover the following topics:
Important concepts about coding in Pascal
Types, Variables and Constants
Data Types and how to define your own
Statements (simple, compound, conditional, using assignments and loops)
Procedures and functions (parameters, arrays, methods, declarations, overloading, calling conventions)
How to handle strings and dates
File handling
Debugging, troubleshooting and basic exception handling
|
DL103 - Delphi Programming Concepts I
Understanding classes, objects and memory
Public and private encapsulation in Delphi
Defining constructors and destructors
Inheritance, virtual methods, polymorphism
Type-safe down-casting
Overview of the Run-Time Library
RTL functions and conversions
Understanding the RTL units |
DL104 - Delphi Programming Concepts II
Understanding the TPersistent class
Understanding the TComponent base class
Properties and events
Streams
Overview of the VCL and the CLX
Designing and working with your forms
Understanding the different visual controls
About boxes and splash screens |
DL105 - Database Programming with Delphi
Delphi excels when it comes to databases. This course is a very general introduction to database programming with Delphi. It will give you the basics and lay a solid foundation for using Delphi to connect to any database from a simple Excel spreadsheet to a full RDBMS like SQL Server or Oracle. If you have not worked with databases in Delphi, you need this course. Topics:
Introduction to Delphi's database architecture
Database programming concepts
The Borland Database Engine
MyBase - Stand-alone ClientDataSet
Using data-aware controls
Indexing, filtering and searching
Presenting and navigating your data
Calculated fields, lookup fields, aggragates
Using bookmarks
Master/Detail structures |
DL106 - Relational Database Design
Attempting to create a database for your application without understanding the relational model or foundations is like driving a car during rush hour without ever learning how to drive. Sooner or later, you will crash. This course lays the foundations of relational database design, the basics and foundational principles of a solid database. You will learn about:
Logical data modeling and sound design
Building blocks of a relational database
Normalizing your data
Keys, indexes, views, stored procedures
Field specifications, table relationships
Business rules and data integrity
Avoiding mistakes and troubleshooting
If you have little or no experience with database design and need to create a database for your application, this class should be a requirement. |
SQL101 - Introduction to SQL Programming
Introduction to SQL
Understanding Relational Databases
Designing a database
Understanding data entities and relationships
Guidelines for Normalization in design
Creating the database and objects with SQL
Understanding SQL syntax
Creating tables and indexes
Understanding SQL-92 constraints
Modifying and deleting databases and objects
Populating databases
Modifying and deleting existing data |
SQL102 - SQL - Selecting and Presenting Data
Elements of a select statement
Narrowing down specific selections
Sorting your query results
Eliminating duplicate rows
Aggregates
Grouping data
Null values
Working with multiple tables
Joins and their uses
Working with joins
|
DL107 - WORKSHOP - Step by step from idea to full application
 This class will put to use many of the concepts taught in all the Beginner 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.
Creating the database and all that is needed to connect to it.
Designing the user interface
Step by step coding
Testing and troubleshooting your application
Deciding on implementation and documentation
|
