IBExpert Firebird 3 Bootcamp

What our customers have to
say about our bootcamps:
(view all testimonials here)

"...definitely a worthwhile investment."
Ing. Pedro Fernando Pardo R., Software y Servicios Informáticos Ltda
"This being my first IBE event I did not know what to expect, but it did exceed expectation as compared to other in-depth trainings I’ve attended. ... I absolutely would recommend the HK software team!"
Dustin Waling, BuilderMT''
"I wanted to thank you for the past 2 days training. It was been a pleasure meeting you and really really educational training. It was a lot of material covered and I look forward we can work together soon."
Eduardo Rocha, Avatar Solutions
"...very informative. Customer projects that I have implemented ... can now be extended and optimized even further on the basis of the newly acquired knowledge.
"... I can develop much faster in the database and integrate these improvements in customer projects and also in our ERP software.
"Holger Klemt also constantly offers tips, advice and guidance .. so that you can avoid a variety of "beginner mistakes" from the outset, which would otherwise make life very difficult later.
"Participation in IBExpert workshops is firmly fixed in my schedule every 1-2 years."
Michael Clemens, Line Software GmbH
"Three days pure Firebird: Firebird internals, Firebird replication, Firebird configuration, repairing Firebird, optimizing Firebird, basically: all things Firebird. It's not possible to pack more Firebird theory and practice into three days!
"The very next day, following the recommendations, we set about configuring a new PC as a Firebird server, initially without any software optimization: a LIKE search across all data by customer name previously took about 15 seconds, with the new server 2 seconds. Price of the previous server: 3,500 €, price of the new FB-Server PC: 1,000 €.
"We will need a few months to digest it all, and implement other parts of our newly gained knowledge. Thanks for the video recordings; they help enormously!"
Chris Hölzemann, Jürgen Medart, Ingenieurbüro Medart
""We would like to thank you for an excellent workshop. We've really learnt a lot about Firebird and IBExpert...
"PS: This was by far the best workshop I've ever participated in!" "
Jakob Töws,
Tele-Trac Kommunikations GmbH

view all testimonials

The Firebird 3 Bootcamp is for admins and developers who have been actively working with Firebird for at least 2 years. The focus is on upgrading to Firebird 3 and optimization of your own database environment (also for Firebird 2.x). You can expect interesting talks covering all aspects of Firebird, IBExpert, Lazarus and Delphi development. The focus is on the practical application of the technologies and methods presented, which can also be implemented with other programming languages.

Benefit from the knowledge of the IBExpert database experts.

Overview of topics

Client development

  • Debugging a Delphi/Lazarus database application with the integrated debugger
  • Create appropriate events for additional protocols without the Debugger
  • Server-side monitoring of database applications
  • Establishing a 24/7 monitoring protocol on the server
  • Network monitoring of database communication at TCP/IP packet level
  • Performance comparison of different components: TxxTable, TxxDataset, TxxQuery etc.
  • Identify and assess automatically component-generated SQLs
  • Identify SQLs on the server based on source code additions in the Delphi/Lazarus source code
  • Automatically supplement own profiling methods in the Delphi/Lazarus source code
  • Autocommit or manual commit?
  • Use Prepare or not?
  • SQLs with or without parameters? Advantages and disadvantages!
  • Integrate block commands

Server development

  • Basic knowledge regarding the Firebird server functionalities and architecture
  • Detect inadequate transaction handling and assess impact
  • Locate long-running transactions in network operation, identify the cause
  • Techniques to end long-running transactions on the server side
  • Analyze trigger sequences and log the process
  • Measure and evaluate speed benefits of stored procedures
  • Create and debug stored procedures and triggers using IBExpert
  • Global database analysis: lack of primary keys, detection of duplicates, false and missing indices
  • Use calculated fields for maximum performance and manage display using permissions
  • Use data types and table definitions properly
  • Correct use of execute statement on external

Administrative tasks

  • Visualize a database model using IBExpert
  • Export a database model for version control in SVN or similar
  • Use IBExpert to set up versioning of stored procedures and triggers
  • Automate metadata comparison between the development database and the production database
  • Automate an automatic data synchronization between multiple databases using scripts
  • Data backup using Backup tools during normal operation
  • Optimize running time of the data backup
  • Shadow as an alternative high-speed backup method
  • Basic knowledge of replication as a real-time backup
  • Measure hardware speed and compare using IBExpert Benchmark
  • Tips and Tricks to optimize hardware and software for a Firebird Server

<< IBExpert Firebird Developer Week | Sitemap | IBExpert Firebird Bootcamps: What our customers say >>