Practical Firebird Administration Course

Practical FirebirdSQL Administration is for database administrators who need the features that matter in production - install, transactions, backups, and configuration - with a practical bias.

About 5-6 hours · English · All courses

Syllabus

Installation and updates
- Files in the Firebird folder and what they do (Windows, Linux)
- Installation packages
- Manual install and embedding from archives
- Updates between minor versions
Transactions and the versioning engine
- Multi-versioning: versions, garbage collection, sweep
- Markers: OIT, OST, OAT, Next
- Version control with gstat and Database Analyst
- Long-running transactions and garbage
Administrative tasks and command-line tools
- isql and scripts
- gbak backup/restore schemes that actually restore
- Incremental backups with nbackup, including scaling large files
- Practices for big databases
Firebird configuration
- firebird.conf parameters
- Lock analysis with fb_lock_print
- Tuning configuration for better performance