Interbase Client Server Course - Felix John COLIBRI.

• Interbase : hassle free Client Server programming
  
• The course's objectives
  
• What you will learn
  
• Intended audience
  
• Detailed content
  
• Hands on exercises
  
• The teacher
  
• Conditions
  

Interbase : hassle free Client Server programming

The course's objectives

What you will learn

• quickly develop database applications using Interbase
  
• install and manage the Server
  
• conceive a relational data base
  
• develop a Windows application to access and manage data in Client Server mode
  
• write requests in SQL language
  
• create reports
  
• evaluate the most popular Client Server engines available
  

Intended audience

Detailed content

• Architecture
  
  • organization:base data local, Client Serveur 2 layers, Client Serveur 3 layers
    
  • access to the data: the BDE engine, SQL Links, dbExpress, Web
    
  • the components architecture : connection, access, visualization, reports
    
• Using the Server
  
  • the local Server
    
  • the remote Server
    
  • Versions and Dialects
    
• Creation of a Base
  
  • using ISQL : connection with the Server, creation of a base, using scripts
    
  • using IbConsole
    
  • creation with tIbDataBase
    
  • direct programming of the client API
    
• Connection
  
  • using a tDataModule
    
  • tDatabase:
    
    • Alias
      
    • controling the connection
      
    • Login dialog
      
    • tDataBase Editor- parameters
      
  • thetSession component
    
  • tIbDataBase, tIbTransaction, tIbDataBaseInfo
    
  • Exploring SQL
    
    • creation of aliases
      
    • using SQL
      
  • the Sql Monitor - the parameters
    
  • exception handling
    
    • Client or Server exceptions
      
    • displaying the exceptions
      
    • stop on exception
      
• Creating tables
  
  • standard of data SQL,Interbase, fields, forced
    
  • using a tQuery
    
    • CREATE TABLE
      
    • static and dynamic SQL
      
    • ExecSql, tFieldDefs
      
  • tIbQuery, tIbSql
    
  • creation of Views
    
  • index
    
    • Primary Key and Foreign Key
      
    • indices at the Database Engine level
      
    • tIndexDefs and SQL
      
• Display and navigation
  
  • the SQL Explorer
    
  • the SELECT request
    
    • Syntax
      
    • how things work at the Engine level
      
    • using tQuery, tDataSource, tDbGrid
      
    • simple and parameterized SQL request - Prepare - tParams
      
  • opening and closing of tables
    
  • access to the fields: dynamic and persistent tFields
    
  • navigation in the table
    
  • positioning and research
    
  • bookmarks - Use of auxiliary tables
    
  • filters: Range and filter expression
    
  • more complex SELECT requests
    
    • GROUP BY and HAVING
      
    • aggregates
      
    • nested requests
      
  • calculated fields - the tDataSet states
    
  • lookup fields - the data dictionary
    
  • stored procedures: tStoredProc
    
    • creating stored procedure
      
    • execution
      
    • Open vs. ExecProc
      
    • using parameters
      
    • call with SELECT
      
    • optimization of the requests - Query Plan
      
• Insertion, Modification, Validation
  
  • SQL: INSERT ,UPDATE, DELETE
    
  • live tQuery
    
  • tTable: Edit, Post, Cancel
    
  • the tTable, tDataSource, tdbGrid events
    
  • input validation - tdbLookUp
    
  • deleting rows
    
  • stored procedures and the INSERT, UPDATE, DELETE requests
    
  • triggers - Server side validation
    
    • creation - trigger kinds
      
    • the OLD and NEW system variables
      
• Handling several tables
  
  • Design of the DataBase
    
    • decomposition of an application into tables
      
    • normal forms
      
  • SQL join: Left, Right and Full Outer Join
    
  • Master Detail relation
    
  • creation of keys
    
    • AutoInc fields
      
    • generators: CREATE GENERATOR, SET GENERATOR, GEN_ID
      
  • referential integrity
    
  • cascading delete and update
    
• Memo, Blob and ASCII Fields
  
  • reading, editing, writing of Memo fields
    
  • binary data: Blobs - Using Streams
    
  • ASCII data Import and Export
    
• Reports
  
  • available tools
    
  • single page and tablular reports
    
  • custom previsualisation
    
• the Transactions
  
  • Integrity and concurrency - transisolation kinds
    
  • Locking:
    
    • table, field
      
    • Optimistic and Pessimistic
      
  • transaction in Interbase:
    
    • implicit and explicit transaction
      
    • Commit and RollBack
      
    • using generators
      
  • how it works: log or versioning systems
    
• Maintenance
  
  • reorganization of the base
    
  • rebuilding, removing and adding indices
    
  • importating from and exporting to other Databases
    
  • Server maintenance: gback, gsec, gfix, gstat
    
  • deployment
    
• Business Objects
  
  • Form Inheritances and tDataModule
    
  • using Business Rules
    

Hands on exercises

• creation of the Database and the tables by program
  
• extraction of the database schema from a database
  
• data input with validation
  
• building single page and tablular reports
  
• saving and restoration of the database
  

The teacher

Conditions

• length: this training lasts for 3 days
  
• location: the training courses are currently held in Paris, London, Munich. Courses can also be organized in other cities worldwide (United States, Australia, Brasil, Middle Eastern countries, Asia, Europe, ...)
  Custom trainings (subject, attendent level, dates) can also be arranged on customer premises
  
• language: courses are held in English. Courses can optionally be held in French
  
• dates: the updated calendar presents the dates of the next scheduled sessions.
  
• price: The price for 3 days is 1.680 Euros
  
• special discounts (starting at 30 %) for groups (2 persons or more) or frequent customers

• to register, please fill the Pre Registration Form

• for more information, please contact us at fcolibri@felix-colibri.com