Courses IPC 2026

Designing Databases with Delphi

Instructor: Olaf Monien

Summary: The course introduces the fundamentals of designing and implementing professional database systems using Delphi. Starting with conceptual modelling and normalization, it moves toward practical implementation with FireDAC, SQL design, and real-world patterns for multi-tier systems. Participants build a complete end-to-end example covering schema design, connectivity, querying, and user-interface integration. Best practices for performance, security, versioning, and deployment complete the course.. The course will cover the following topics:

Lesson 1 – Fundamentals of Database Design
1.1 Conceptual modeling (ER models, normalization)
1.2 Translating models into relational schema (keys, constraints)

Lesson 2 – Delphi & FireDAC Essentials
2.1 Connecting Delphi applications with FireDAC (architecture, drivers)
2.2 CRUD operations, datasets, and live bindings

Lesson 3 – Designing Multi-Tier Database Architectures
3.1 Data modules, repositories, and clean architecture patterns
3.2 REST backends, JSON models, caching and transactions

Lesson 4 – Performance, Security & Deployment
4.1 Indexing, query optimization, monitoring tools
4.2 Secure connections, encryption, migration/versioning strategies

• Back to the list