menu
  Home  ==>  training  ==>  interbase_client_server_course   

Interbase Client Server Course - Felix John COLIBRI.



Interbase : hassle free Client Server programming

Interbase is the most efficient Database Engine as far as installation, memory footpring, programming and cost are concerned. This package was the first to implement Stored Procedures, Blobs, Database events, distributed processing, but still remains simple to use without sacrificing neither functionality nor performance. And any development on a local PC can be instantaneously changed into a full fledged Client Server appication.



The course's objectives

You will show you how to use the Interbase Server, to model the data base, then to build customer applications which create the base, the tables, the indices, and handle and print the data.



What you will learn

You will learn to:
  • 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

Software developers and programmers wishing to prototype or build Client Server Database applications. No preliminary knowledge of Windows, Delphi or Database is required.



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

Each participant will build several working Windows applications. For instance:
  • 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

The courses are exclusively presented by Felix COLIBRI. Author of more than 15 programming books and many papers and is a frequent speaker at the Delphi Conferences. Aside from training, he develops Delphi projects on a contractual basis. He has been teaching at the Pascal Institute since 1984, and personally trained more than 1.200 developers.



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
Created: mar-04. Last updated: jul-15 - 98 articles, 131 .ZIP sources, 1012 figures
Copyright © Felix J. Colibri   http://www.felix-colibri.com 2004 - 2015. All rigths reserved
Back:    Home  Papers  Training  Delphi developments  Links  Download
the Pascal Institute

Felix J COLIBRI

+ Home
  + articles_with_sources
  + delphi_training
    – delphi_tutorial_course
    – ib_client_server
    – delphi_2006_for_net
    – delphi_ado_net_course
    – delphi_asp_net_course
    – delphi_asp_net_20
    – rad_studio_databases
    – rave_reports_training
    – custom_delphi_training
    – training_calendar
    – registration_form
  + delphi_developments
  + sweet_home
  – download_zip_sources
  + links
Contacts
Site Map
– search :

RSS feed  
Blog