menu
  Home  ==>  training  ==>  delphi_ado_net_course   

Delphi ADO.NET Course - Felix J COLIBRI.



The course's objectives

The purpose of this training course is to learn how to manage Windows data bases (Sql Server, Oracle, Interbase) using ADO.NET.



What you will learn

You will learn to:
  • quickly develop data base applications with ADO.NET
  • design relational data bases
  • write requests using the SQL language
  • build reports
  • develop Client / Server and Multi Tier business applications
  • read and write XML formated data


Intended audience

Software developers and programmers wishing to build data base applicaction for the .Net framework. A general knowledge of Delphi will be usefull. Prior development of data base applications is not required.



Detailed content

  • The Development Interface
    • the Tools and Component Palette
    • the Code Structure
    • the Model
    • the Database Explorer
  • Database Architecture
    • Desktop, Client/server, 2 tier, multi tier applications
    • data access: the BDE, SQL Links, dbExpress, ibExpress, ADO, Ole dB, ADO.NET
    • the component hierarchy: connection, access, visualization, reporting
    • ADO.NET architecture: Connection, Command, DataReader, DataAdapter, DataSet, DataTable, DataView, Bindings, DataGrid
    • ADO.NET and Sql Server/Oracle/Interbase - Borland Data Provider (BPD)
  • Connection
    • the Connection component
    • the ConnectionString
    • the ConnectionEditor - testing the connection
  • reading data
    • the Command component - SELECT, INSERT, UPDATE and DELETE requests
    • using the DataReader
    • strongly types DataSets
    • parameterized queries - standard data provider and the BDP
  • displaying data
    • storage classes (DataSet, DataTable, DataRow, DataColumn, DataRelation, DataView, Constraints)
    • parameterized requests
    • computed fields, aggregates, parameters
    • visual controls and data binding
    • saving in local files and restoration
    • stored procedures
  • Data Modification
    • transactions
    • transaction isolation (transisolation)
    • reconciling updates - handling exceptions
  • Writing Reports
    • QuickReport, Rave Report, Crystal Report
  • Enterprise Core Objects III
    • MDA, object persistence, OCL
  • Internet Applications and Data bases
    • ASP.NET and ADO.NET
    • the dbWeb components
    • Web Services and .NET Remoting
    • handling XML data: definition, reading, writing
  • Migration
    • ADO.NET and Win32 applications


Hands on exercises

30% of the time is dedicated to hands on programming. Each participant will build several working Windows applications. For instance:
  • connecting visual controls to Database Tables
  • reading, writing and reconciliation using ADO.NET components
  • master detail display and update
  • displaying database tables in a Web Browser
  • writing a Web service


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: dec-05. 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