Doc

IBExpert & Firebird Learning Center

Welcome to the IBExpert learning center, where we provide a range of tutorial films about Firebird and IBExpert.
You can also find all these films at YouTube.com.
If you own a valid registered IBExpert license, you can download all these tutorial films, along with PDF copies of the English voice-over scripts, from our customer download area.
If you cannot find a solution to a particular problem in these tutorials, please consult our online documentation.
If you have any comments or questions regarding any of these tutorials, or wish to translate any of the audio files into your own language, please mail documentation@ibexpert.com.



Working with IBExpert

TutorialSubjectClick to view film
#1Firebird installations for professionalspart 1part 2part 3
#2Installing IBExpertpart 1
#3Register Databasepart 1part 2
#4IBExpert Database Objectspart 1part 2
#5Firebird Database Filespart 1
#6IBExpert Database Comparerpart 1
#7IBExpert Table Data Comparerpart 1
#8IBExpert User and Grant Managerpart 1
#10IBExpert Extract Metadatapart 1part 2part 3

Firebird Developer Training

Based on the Firebird School which was held at the International Firebird Conference 2007 in Hamburg, Germany by Holger Klemt and Jason Chapman.

TutorialSubjectClick to view film
01Installing the sample databasepart 1  
02-04SQL Basicspart 1part 2part 3
05-06Creating your first Firebird databasepart 1part 2
07-08Database design & modellingpart 1part 2
09-10Writing stored procedures and triggerspart 1part 2
11-12Debugging & Optimizationpart 1part 2

Firebird DB Admin Training

Based on the Firebird School which was held at the International Firebird Conference 2007 in Hamburg, Germany by Holger Klemt and Jason Chapman.

TutorialSubject 
01Introduction to admin tasksclick to view
02Installing the Firebird serverclick to view
03Firebird server versions and differencesclick to view
04Firebird database aliasesclick to view
05Firebird configuration file parametersclick to view
06Multi-generational architecture & database statisticsclick to view
07Firebird database pagesclick to view
08Maintenance operationsclick to view
09Protocols, ODBC import & exportclick to view
10Automating the database backup & restoreclick to view
11Database corruption and database repair using gfixclick to view
12Alternative database repair methodsclick to view
13Typical causes of server problemsclick to view

Coming next ....
watch this space, or subscribe to the IBExpertise YouTube channel, to automatically receive notification of all new tutorials.

IBExpert registered full version customers can also download the videos (MP4) and English-language scripts (PDF) from our customer download area: IBExpert tutorials.

FBCon 10 Session Videos

Here you will find all FBCon 10 conference recorded sessions. All films have been edited to condense long upload times and speed up live demonstrations, so that many are shorter than the original session length. No important information has been deleted!

SessionSubjectSpeaker
A01Opening sessionHolger Klemt
A02New features in SQL language *Vlad Khorsun
A03Database conversions: UTF8 and other character set targetsHolger Klemt
A04Managing recursive, tree-like data structures with Firebird IFrank Ingermann
A05Managing recursive, tree-like data structures with Firebird IIFrank Ingermann
A06Writing 32 + 64-bit UDFs for Firebird using Pascal language with Lazarus and Freepascal, native multi-platform development for Windows, Linux, Mac, 32 and 64 bitHolger Klemt
A12ODS related optimizations in Firebird 3***Vlad Khorsun
A12aIBExpert licensing & integrationHolger Klemt
A13Turbo Firebird: A Firebird performance comparison: 32/64 bit, virtual machines, multicore, ramdisk, harddisk, Linux, Windows, monitoring, etc.Holger Klemt
A14Open Source OLAP Environment with FirebirdThomas Steinmaurer
A15Using Open-Source BI Tools with FirebirdRoman Rokytskyy
A16Firebird 2.5 architectures comparisonThomas Steinmaurer
A22Firebird 3. Initial review By Dmitry YemanovVlad Khorsun
A22aTrace API technology and toolsThomas Steinmaurer
A23Developing modern Rich Internet Applications with Java and FirebirdRoman Rokytskyy
A24IBEBlock scripting LanguageIBExpert
A25Firebird, Apache and PHP-based web application: basic technology for mobile browser access, including iPad, iPhone and AndroidHolger Klemt
B04New features in .NET provider for Firebird**Jiri Cincura
B05How to replace InterBase with Firebird?better office
B13Transparent JDBC replication with Firebird *Roman Rokytskyy
B15Connecting to Firebird using .NET provider from various devices - iPad, iPhone, Android, Windows Phone, ... *** (audio improves after 09:23:00)Jiri Cincura
B23Part-time foreign keys using flexible triggers to replace declarative foreign keys. ***Holger Klemt
B24Server-side programming techniques ***Thomas Steinmaurer
B25Creating services for Rich Internet Applications***Jiri Cincura

* This session was unfortunately not recorded; please refer to Vlad's PPT presentation.
** Unfortunately there were problems with the microphone during this session. We've left the sound in where it was comprehensible, and just run the screen show where not.
*** Unfortunately poor sound quality.

Firebird & IBExpert Power Workshops

The following is an English translation (with subtitles) of a live recording of the IBExpert KG Power Workshop: Optimizing Database Performance held by Holger Klemt in 2013.

If you're interested in participating in our Power Workshop series, you can find the upcoming dates on our News? page.

TutorialSubjectDescription
01Firebird turbo backup using shadows and IBExpertFree English-language excerpt (with subtitles), taken from a live recording of a power workshop
held by Holger Klemt in 2013

Deutsch/German

Firebird & IBExpert Powerworkshops

Deutschsprachige Videoreihe.

TutorialThemaBeschreibung
01Firebird Turbobackup mit Shadows und IBExpertKostenloser Auschnitt aus einem IBExpert und Firebird Powerworkshop zum Thema Leistungssteigerung
(Liveaufnahme Holger Klemt 2013).

Die vollständige Videoserie (sechs MP4 Filme) ist eine Originalaufnahme von einem IBExpert KG Firebird und IBExpert Powerworkshop zum Thema Leistungssteigerung. Diese Videoserie bietet Ihnen noch viele weitere ähnliche Tips und Tricks, um die Firebird Performance und Betriebssicherheit zu verbessern und kann im IBExpert Shop erworben werden. Oder nehmen Sie an einer Schulung teil: Aktuelle Termine finden Sie auf unsere Webseite unter Veranstaltungen.




Any comments? Send an email to documentation@ibexpert.com
COPYRIGHT © 2002-2013 HK-Software, IBExpert KG. All rights reserved.
All IBExpert brand and product names are trademarks or registered trademarks of IBExpert KG in Germany and other countries. InterBase, Delphi, CodeGear, C++Builder, Delphi/400, Delphi for PHP and JBuilder are trademarks or registered trademarks of Embarcadero Technologies Inc. in the United States and other countries. Firebird is a registered trademark of the FirebirdSQL Foundation. Turbo Pascal is a registered trademark of Borland International, Inc. Sun, Java, JavaScript and Solaris are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the United States and other countries. UNIX is a registered trademark in the United States and other countries, exclusively licensed through “The Open Group”. Oracle is a registered trademark of Oracle Corporation in the United States and other countries. All Microsoft brand and product names are trademarks or registered trademarks of Microsoft Corporation in the United States and other countries. AS/400, DB2, IBM, Informix and iSeries are trademarks or registered trademarks of IBM Corporation in the United States and other countries. Linux is a registered trademark of Linux Torvalds. dBASE is a trademark of dataBased Intelligence, Inc. Skype is a registered trademark of Skype Ltd., in the United States and other countries. All other product names mentioned herein and throughout the entire web site are trademarks of their respective owners.