The course is organized into units, each covering a series of related topics. Units are organized into a logical sequence, to ensure that each topic builds upon the knowledge gained in earlier topics. An instructor slide show, hands-on exercises, end-of-unit review questions, and a final exercise all combine to make this a worthwhile interactive classroom experience for the student.

Intended Audience
The class is targeted at Database Administrators, IT managers, and developers of client/server applications.

Length of Course
The courseware is five days of planned curriculum in an instructor-led setting.

We recommend that individuals attending this course have a familiarity to the relational database model and data processing techniques. They should also have a basic understanding of client/server architecture.

Borland Training—The First Step to Product Certification
Classroom training is the best setting to master Borland products. No other teaching approach can replace the breadth of information and learning customers experience in our classes. Borland Training classes are distinguished by detailed discussions and hands-on lab exercises, enabling attendees to learn by listening and discussing, and then by doing.

All Borland certified trainers are skilled developers with an appreciation for and understanding of the complexity of our technology. We have the experience and expertise to walk you through our products in a meaningful way. Every trainer who teaches a Borland course is certified.

In our classes, you will learn essential product features that will advance your skills, shorten your development time, and apply immediately to your current projects.

Attend one of the Borland Open Enrollment classes, held at locations nationwide, or bring a Borland trainer to your facility. Onsite classes are often the best way to cut costs and train your entire team at the same time. We also offer customized courses, tailoring them to meet your unique business needs.

Certification
There is no certification program for InterBase at this time. Please watch the Borland website for any announcement of upcoming programs.

InterBase 6 Courseware Table of Contents:

1. An Introduction to InterBase
   • What is InterBase?
   • Interbase Components
   • Interbase SQL Dialects
   • How To Create An Interbase Application
   • Summary
2. Understanding the Relational Model
   • What Is A Database?
   • What Is A Table?
   • Candidate and Primary Keys
   • Foreign Keys
   • Indexes Versus Keys
   • Nulls
   • What Makes A DBMS Relational?
   • Designing A Database
   • What Is Normalization?
   • First Normal Form
   • Second Normal Form
   • Third Normal Form
   • Summary
3. Using IBConsole
   • About IBConsole
   • Connecting to a Server and Database
   • Working With Databases
   • Database Maintenance
   • Working With the Server
   • Summary
4. InterBase Commmand Line Utilities
   • Issuing SQL With Command-Line ISQL
   • Using gsec To Manage Server Security
   • Using gbak to Backup and Restore Databases
   • Using gfix To Validate and Maintain Databases
   • Using gstat To Get Database Statistics
   • Summary
5. Creating and Modifying Databases
   • Working With Databases
   • Creating A Database
   • Altering A Database
   • Dropping A Database
   • Database Shadows
   • Summary
6. Datatypes, Domains, and Tables
   • Understanding Datatypes
   • Domains
   • Creating Tables
   • Altering Tables
   • Dropping A Table
   • Summary
7. Working with Indexes
   • Why Use Indexes?
   • Automatic Indexes
   • When and When Not To Index
   • The CREATE INDEX Statement
   • The DROP INDEX and ALTER INDEX Statements
   • The SET STATISTICS Statement
   • Summary
8. Inserting, Updating, and Deleting Data
   • The INSERT Statement
   • Working With External Tables
   • The UPDATE Statement
   • The DELETE Statement
   • Summary
9. Extracting Data
   • The SELECT Statement
   • Specifying Columns
   • Using WHERE To Limit Rows
   • Using Table Aliases
   • Joining Tables
   • Summary
10. More about Select
    • Deriving New Columns
    • InterBase Functions
    • Aggregate Calculations
    • Outer Joins
    • Subqueries
    • Summary
11. Working with Views
    • What Is A View?
    • The CREATE VIEW Statement
    • Updateable and Read-Only Views
    • Specifying WITH CHECK OPTION
    • Altering and Dropping Views
    • Summary
12. Database Security
    • Understanding The InterBase Model
    • The GRANT Statement
    • Viewing Access Privileges
    • The REVOKE Statement
    • Summary
13. Stored Procedures
    • What Is A Stored Procedure?
    • The Structure Of Stored Procedures
    • The Terminating Character Issue
    • Executing Stored Procedures
    • Altering and Dropping Procedures
    • Additional Language Constructs
    • Using DML Statements With Procedures
    • Summary
14. Generators and Triggers
    • Generators
    • What Is A Trigger?
    • The Structure Of Triggers
    • Chaining Triggers
    • The NEW and OLD Context Variables
    • Modifying and Dropping Triggers
    • Summary
15. Exception and Error Handling
    • What Is An Exception?
    • Working With Exceptions
    • Raising An Exception
    • Errors Returned By Interbase
    • Handling Exceptions and Errors Using WHEN ... DO
    • Summary
16. Transactions and Versioning
    • What Is A Transaction?
    • Starting A Transaction
    • Finishing A Transaction
    • Managing Transactions Automatically
    • How Does InterBase Manage Transactions?
    • The Interbase Versioning Engine
    • Version Management
    • Summary
17. Embedded SQL Applications
    • Understanding Embedded SQL Applications
    • Writing Embedded SQL
    • Creating An Embedded SQL Application
    • Using The gpre Preprocessor
    • A Before and After Example
    • The Interbase API
    • Working With Events
    • Summary
18. Advanced and Miscellaneous Topics
    • User-Defined Functions
    • Blob Filters
    • Query Optimization and Performance Tuning
    • Moving Data Into InterBase
    • Differences Between Platforms
    • Interpreting Version Ids
    • Summary
19. Replication
    • Understanding Replication
    • IBReplicator Components
    • Using Replication Manager
    • The REPL User
    • Starting Replication
    • Summary
20. Using InterBase Express with Delphi
    • The Data Access Components
    • Building an IB Express Application
    • Other Data Access Components
    • Creating and Dropping a Database
    • Using IBDatabaseInfo
    • Using IBSQLMonitor
    • Using IBEvent
    • Master Detail Relationships
    • Preparing Queries and Stored Procedures
    • Running the Sample Applications
    • Summary
21. Using the InterBase Express Admin Components
    • The Admin Components
    • IBInstall
    • IBUninstall
    • Common Component Properties
    • IBConfigService
    • IBBackupService
    • IBRestoreService
    • Running the Sample Applications
    • Summary
22. About the Sample Database
    • The Data Model
    • Tables and Structures
23. Recommended Books