Firebird basics for developers

Developing a Firebird database

Target group

This course is aimed at all those just starting out with Firebird development, or those currently considering the use of Firebird in a future project and would first like to get to know the database in more detail.

Content

The first day shows you how to develop a data model and create your first database including datatypes, constraints and keys.

You will learn how to create a new database, which database objects are available and which should be used when, depending on their properties. We will then proceed to create tables, learning the significance of primary keys, foreign keys, foreign key options, indices and the effects of missing primary and foreign keys. Following a look at datatypes in more depth we will go on to generate test data to help depict and understand the importance of dependencies. At this stage you will learn to visualize the data model, look at visual modeling and compare different data models. Finally on the first day, you will learn how to understand and use views.

The second day concentrates on programming the Firebird server using stored procedures and triggers.

You will be introduced to the construction of stored procedures, a critical part of Firebird database programming; beginning by writing simple procedures, learning about input and output parameters, and variables. We will then go on to look at FOR SELECT and SUSPEND, loops and conditions, the EXECUTE statement, recursions and modularity. Debugging options , both with and without IBExpert, will be presented and you will also learn how to optimize procedures and compare them. Finally we will go on to create more complex SELECTs, look at trigger construction and trigger function, NEW and OLD variables, universal triggers, as well as the automatic creation of triggers through procedures, blocks and IBEBlocks.

At the end of each day there will be ample time allowed for questions and answers.

Duration

The course lasts for 2 days.

Location

The workshop can be booked worldwide and is performed in English or German.

Registration

Please contact us at info@ibexpert.com or fax our Information Request form.

<< courses | Index | Firebird basics for admins >>