Firebird Certification

Here is the list of Firebird Certified Professionals: https://firebirdsql.org/en/certified-firebird-professionals

Firebird Certification consists of two levels, each with two exams:

Basic Level

1. Basic Firebird DBA (try demo exams: in English  in Portuguese  in German)

Confirms the ability to:

  • Manage Firebird instances on Windows and Linux
  • Use standard tools (gbak, nbackup, gstat, etc.) to perform backups, restores, maintenance, installations
  • Handle basic configuration and monitoring (monitoring tables and trace), location of temporary files
  • Create and alter users and password

2. Basic Firebird Developer

Confirms the ability to:

  • Develop client applications for Firebird with basic SQL operaions
  • Understand SQL query execution and basic indexing
  • Understand basic challenges with transaction managementt
  • Comprehend basic query performance metrics. basic query execution statistics
  • Use basic data types and domains
  • Develop basic stored procedures, execute blocks, triggers, and packages

Advanced Level

3. Advanced Firebird DBA

Confirms advanced skills in:

  • OS tuning for Firebird usage
  • Firebird configuration file tuning
  • Resource consumption analysis
  • Migration between Firebird versions
  • Database statistics analysis (record versions, index statistics)
  • User, role, and grant management, user and role mapping
  • Authentication plugin understanding (Srp, Legacy_UserManager), trusted authentication setup
  • Advanced monitoring and performance analysis
  • Error tracing, including lock conflicts and deadlocks

4. Advanced Firebird Developer

Confirms proficiency in:

  • Effective SQL constructions
  • SQL execution plan understanding and optimization
  • Advanced indexing (composite, expression-based, partial)
  • Transaction modes and record locking (including SKIP LOCKED)
  • Deadlock and lock conflict resolution
  • Data type binding
  • Various trigger types (DML, DDL, on connect)
  • SQL profiler usage

Certification Process

  • The certification exams will be multi-lingual. The list of supported languages will be announced later.
  • Details on the certification process, exam cost, and other specifics will be announced later.
  • Subscribe to the Firebird Certification Substack list for updates.

Benefits and Conditions

  • Basic level certified specialists receive a public page on the FirebirdSQL certification website to showcase their certificates.
  • Advanced level certified specialists should contact the Firebird Foundation President for potential introductions to top companies using FirebirdSQL.
  • More details to be announced