Firebird Certification
Firebird Certification consists of two levels, each with two exams:
Basic Level
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
