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:
Instructor: Olaf Monien
CV: Olaf Monien has been a long-standing Embarcadero MVP and serves as the coordinator for the German-speaking region. With over 25 years of experience in the IT industry, he is a recognized expert in software architecture and database design, holding a Master's degree in Computer Science with a minor in Business Studies. His extensive experience spans industrial, banking, SaaS, and medical/pharmaceutical sectors, providing him with a comprehensive perspective on IT consultancy.
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
International Pascal Congress® is a registered trademark.