pic_cooming_soon

Online Lectures:
Further Reading:

1. Borrie: The Firebird Book Second Edition: Volume 1: Firebird Fundamentals Paperback – 26 Mar 2013

firebird_I

Since the original edition of The Firebird Book was published as a 900-gram doorstop in 2004, the open source Firebird relational database management system has undergone three major releases through versions 2.0, 2.1 and 2.5. The Firebird Book Second Edition brings Firebird technical users up to score across all of the releases from the original v.1.0 through to the latest 2.5. The whole book, too big to publish as a paperback, is distributed by the IBPhoenix company on a DVD. For print, it has been split into three partly overlapping volumes, of which Firebird Fundamentals is the first in the series.

In This Volume

Part I Firing Up with Firebird (pp. 1 – 72)
This is an introductory section that goes into some depth to give the reader an understanding of client/server deployments and how you can implement them using a choice of Firebird server and client models. It provides the basics for installing Firebird, setting it up on your network and getting it up and running.

  • 1 Firebird Servers and Clients
  • 2 Installation
  • 3 Network Setup and Initial Configuration
  • 4 Operating Basics

Part II Firebird Data Types & Domains (pp. 73 – 158)
In this section, the various data types that Firebird supports are described and discussed in detail.

  • 5 About Firebird Data Types
  • 6 Number Types
  • 7 Date and Time Types
  • 8 Character Types
  • 9 BLOBS and Arrays
  • 10 Domains

Part III A Database & Its Objects (pp. 159 – 288)
The real work starts here: designing and defining the database that you need to fit your requirements. Broadly, it provides an in-depth reference to DML, the SQL lexicon for creating and managing the objects in Firebird databases. At the end is a detailed manual for using the interactive and command-line modes of isql, a tool that comes in every Firebird distribution, regardless of platform.

  • 11 Designing and Defining a Database
  • 12 Data Definition Language—DDL
  • 13 Creating and Maintaining a Database
  • 14 Tables
  • 15 Indexes
  • 16 Referential Integrity
  • 17 Interactive SQL Utility (isql)

Part IV Transactions (pp. 289 – 303)
This section contains two detailed chapters describing the transactional model that allows multiple users or tasks to work with the same data simultaneously, in compliance with the ACID rules for ensuring data integrity.

  • 18 Overview of Firebird Transactions
  • 19 Configuring Transactions

Part V Appendices (pp. 315 – 411)

  • I Internal and External Functions
  • II Reserved and Non-Reserved Keywords
  • III Context Variables
  • IV Firebird Limits
  • V System Tables and Views
  • VI Character Sets and Collations
  • VII Resources

Index

GLOSSARY (18 pp. at end of book)

The next volume of the series, Developing with Firebird Data, covers the data manipulation language (DML) lexicon that is used in client applications to retrieve, populate and modify data, and the procedural language (PSQL) for creating executable code in stored procedures, triggers and dynamic executable blocks. It covers error handling in detail, as well as the ‘events’ mechanisms.

The third companion volume, Administering Firebird Servers and Databases, covers some of the same ground as Fundamentals Part I. It also includes a guide for migrating databases and applications to later versions of Firebird. It moves on to the detailed configuration of servers and databases and the tools for managing and monitoring them.

  • Paperback: 470 pages
  • Publisher: CreateSpace Independent Publishing Platform; Second edition (26 Mar. 2013)
  • Language: English
  • ISBN-10: 148274497X
  • ISBN-13: 978-1482744972
  • Product Dimensions: 18.9 x 2.7 x 24.6 cm

Buy at Amazon.co.uk

2. Borrie: The Firebird Book Second Edition: Volume 2: Developing with Firebird Data Paperback – 26 Mar 2013

firebird_II

Since the original edition of The Firebird Book was published as a two-pound doorstop in 2004, the open source Firebird relational database management system has undergone three major releases through versions 2.0, 2.1 and 2.5. The Firebird Book Second Edition brings Firebird technical users up to score across all of the releases from the original v.1.0 through to the latest 2.5. The whole book, too big to publish as a paperback, is distributed by the IBPhoenix company on a DVD. For print, it has been split into three partly overlapping volumes, of which this is the second, following on from Volume 1, Firebird Fundamentals.

In Developing with Firebird Data:

Part I Working With Data (pp. 1 – 178)
This section provides an in-depth survey of the data manipulation language (DML) lexicon of Firebird’s SQL implementation, the concept of sets (“datasets”) and the many ways available to retrieve stored data, manipulate it and operate on it. At the end is a detailed manual for using the interactive and command-line modes of isql, a tool that comes in every Firebird distribution, regardless of platform.

  • 1 Data Manipulation Language—DML
  • 2 DML Queries
  • 3 Expressions and Predicates
  • 4 Querying Multiple Tables
  • 5 Ordered and Aggregated Sets
  • 6 Views and Other Run-time Set Objects
  • 7 Interactive SQL Utility (isql)

Part II Transactions (pp. 179 – 223)
This section contains three detailed chapters describing the transactional model that allows multiple users or tasks to work with the same data simultaneously, in compliance with the ACID rules for ensuring data integrity. The third chapter describes how to work with transactions in your applications.

  • 8 Overview of Firebird Transactions
  • 9 Configuring Transactions
  • 10 Programming with Transactions

Part III Programming Server-Side (pp. 225 – 340)
In this section is a full work-through of the many ways you can write code that is stored in your database for invoking when conditions call for it. It covers Firebird’s prcedural language (PSQL) with its use in stored procedures, triggers and dynamic executable code blocks in the client applications. Error-handling and events are covered here, too.

  • 11 Procedural SQL—PSQL
  • 12 Stored Procedures and Executable Blocks
  • 13 Triggers
  • 14 Accessing Other Databases from PSQL

Part IV Appendices (pp. 341 – 472)

  • I Internal and External Functions
  • II Reserved and Non-Reserved Keywords
  • III Context Variables/li>
  • IV Firebird Limits
  • V System Tables and Views
  • VI Character Sets and Collations
  • VII Firebird Error Codes
  • VIII SQLSTATE Codes
  • IX Application Interfaces
  • X Resources

Index

GLOSSARY (18 pp. at end of book)

Volume 1 of this series, Firebird Fundamentals, covers client/server concepts, the architecture of the multiple Firebird server models and the first tasks for installing a server, configuring it for the network and starting to work with Firebird. It moves on to the data definition language (DDL) lexicon that is used for creating databases and the objects in them to suit your requirements. Although it covers some of the same ground as this book on the subject of transactions, it is the precursor for this volume.

The third companion volume, Administering Firebird Servers and Databases, starts with a section with the basics for installing, configuring, operating and migrating servers and databases and moves on to the detailed configuration of servers, users and databases and the tools for managing and monitoring them.

  • Paperback: 532 pages
  • Publisher: CreateSpace Independent Publishing Platform; Second edition (26 Mar. 2013)
  • Language: English
  • ISBN-10: 1482767309
  • ISBN-13: 978-1482767308
  • Product Dimensions: 18.9 x 3 x 24.6 cm

Buy at Amazon.co.uk

3. Borrie: The Firebird Book Second Edition: Volume 3: Administering Firebird Servers and Databases Paperback– 26 Mar 2013

firebird_III

Since the original edition of The Firebird Book was published as a two-pound doorstop in 2004, the open source Firebird relational database management system has undergone three major releases through versions 2.0, 2.1 and 2.5. The Firebird Book Second Edition brings Firebird technical users up to score across all of the releases from the original v.1.0 through to the latest 2.5. The whole book, too big to publish as a paperback, is distributed by the IBPhoenix company on a DVD. For print, it has been split into three partly overlapping volumes, of which this is the third in the series.

In Administering Firebird Servers and Databases:

Part I Firing Up with Firebird (pp. 1 – 106)
This section provides the basics for installing Firebird, setting it up on your network and getting it up and running. It contains a chapter of notes about migrating servers, databases and applications to newer versions. At the end is a detailed manual for using the interactive and command-line modes of isql, a tool that comes in every Firebird distribution, regardless of platform.

  • 1 Installation
  • 2 Network Setup and Initial Configuration
  • 3 Operating Basics
  • 4 Migration Notes
  • 5 Interactive SQL Utility (isql)

Part II Configuring Firebird (pp. 107 – 156)
Here is where you can discover in detail how the configuration file, firebird.conf, provides the means to secure your servers and databases and make best use of network and hardware resources. It also covers the many switches available in the gfix command-line toolset.

  • 6 Configuring Firebird and Its Environment
  • 7 Configuration Parameters in Detail
  • 8 Configuring and Managing Databases

Part III Administering & Securing Firebird (pp. 157 – 284)
This section describes and documents the tools for securing both servers and data, using tools and SQL privileges. Use of the two backup tools, gbak and nbak, is described, as is shadowing. Monitoring and tracing are covered and a chapter describes the Services Manager and a tool that enables you to access it directly.

  • 9 Protecting the Server and its Environment
  • 10 Monitoring and Logging Features
  • 11 Database-Level Security
  • 12 Backing Up Databases
  • 13 The Services Manager

Part IV Appendices (pp. 285 – 389)

  • I Context Variables
  • II Firebird Limits
  • III System Tables and Views
  • IV Firebird Error Codes
  • V SQLSTATE Codes
  • VI Default Disk Locations
  • VII Database Repair How-To
  • VIII Healthcare for Databases
  • IX Upgrade Scripts
  • X Resources

Index

GLOSSARY (18 pp. at end of book)

Volume 1 of this series, Firebird Fundamentals, covers client/server concepts, the architecture of the multiple Firebird server models and the first tasks for installing a server, configuring it for the network and starting to work with Firebird. It moves on to the data definition language (DDL) lexicon that is used for creating databases and the objects in them to suit your requirements. Although it covers some of the same ground as this book on the subject of transactions, it is the precursor for this volume.

The second volume, Developing with Firebird Data, covers the data manipulation language (DML) lexicon that is used in client applications to retrieve, populate and modify data, and the procedural language (PSQL) for creating executable code in stored procedures, triggers and dynamic executable blocks.

  • Paperback: 444 pages
  • Publisher: CreateSpace Independent Publishing Platform; Second edition (26 Mar. 2013)
  • Language: English
  • ISBN-10: 1482768488
  • ISBN-13: 978-1482768480
  • Product Dimensions: 18.9 x 2.5 x 24.6 cm

Buy at Amazon.co.uk