OpenROAD Application Development and Maintenance

Code: OpenROAD
Days: 5
OpenROAD Version: 5.1

OpenROAD is a high-productivity low-maintenance 4GL-based object-oriented application-development tool for creating business applications of any type and complexity. It is well-established, with thousands of deployments worldwide.

You will learn:

At the end of this course you will be able to:

  • Understand and assess the role that OpenROAD can fulfill in your organisation
  • Develop high-quality display screens that interact fully with the database
  • Write effective, reusable, correctly partitioned 4GL code
  • Write applications that reflect users' requirements
  • Understand and exploit OpenROAD's system object hierarchy
  • Understand and exploit OpenROAD's system object hierarchy
  • Develop applications adaptable for use in OpenROAD ApplicationServer and EClient
  • Maintain existing OpenROAD applications

Course Style

This course provides you with all the knowledge and skill you need to:

  • Develop OpenROAD applications and functionality to current display standards
  • Maintain existing OpenROAD applications
  • Provide high-quality, low-cost interfaces to your database data
  • Assess the cost-benefit of OpenROAD compared to other technologies

The course is a mixture of lecture and demonstrations with hands on practical exercises for all key topics

Who Should Attend

IT staff designing, developing or maintaining business applications to be developed or prototyped in OpenROAD. Managers or IT staff who need to understand or assess the OpenROAD tools and capabilities.

This course is an essential prerequisite for anyone undertaking other OpenROAD training: OReServer; ORUpdate.

Prerequisites

Delegates should have attended the IngresSQL course (Introduction to Ingres and Ingres SQL), or should have equivalent experience.

Key Topics

Day 1

  • OpenROAD concepts
  • User Model and Data Model
  • UserClasses and Database
  • Building a Working Display

Days 2-5

  • The OpenROAD IDE
  • Display Fields and Features
  • Template-driven Development
  • Exploiting Object-Oriented capabilities
  • System Class Methods and Attributes
  • Display, System and User Events; the Event Queue
  • Programming the 4GL and SQL
  • Variables and Procedures
  • Multi-Window Applications
  • Application Debugger and Utilities
  • Array-handling and Tablefields
  • Selection, Validation and Guidance
  • Bitmaps and StringObjects
  • Exploiting Field Arrays

Next Course

IT staff developing or maintaining OpenROAD ApplicationServer or EClient applications should attend the OReServer course.

Developers who will be building applications in OpenROAD should attend the OpenROAD Advanced course

We have clear learning paths, so there is an appropriate course whatever your current expertise and knowledge. You can continuously advance your understanding and skills with Actian solutions by following the learning paths below.

Vector Database System Administrator

Course Description

Duration

IngresSQL
Introduction to the Ingres SQL [Recommended]
5 Days
VectorDBM
Managing Vector Installations and Database
4 Days

Matrix Database System Administrator

Course Description

Duration

MatrixDBM
Managing Matrix Installations and Database
4 Days

DataFlow Developer

Course Description

Duration

DataFlow
DataFlow Core
3 Days

DataConnect v10 Data Integrator

Course Description

Duration

DataConnectCore
DataConnect v10 Core
4 Days
DataConnectIT
EDI/HIPAA Integration Techniques
1 Day

DataConnect v9 Data Integrator

Course Description

Duration

DataConnectFund
Data Connect v9 Fundamentals
3 Days
DataConnectAdv
DataConnect v9 Advanced
1 Day
DataConnectIT
EDI/HIPAA Integration Techniques
1 Day

Versant Database System Administrator

Course Description

Duration

VersantDBM
Managing Versant Installations and Database
3 Days


Ingres Database System Administrator

Course Description

Duration

IngresSQL
Introduction to the Ingres Product and Ingres SQL
5 Days
IngresDBM
Managing Ingres Installations and Database
5 Days
Performance
Optimizing Ingres Performance [Recommended]
5 Days

OpenROAD Developer/ Maintainer

Course Description

Duration

IngresSQL
Introduction to the Ingres Product and Ingres SQL
5 Days

OpenROAD
OpenROAD Application Development and Maintenance

5 Days
ORAdv
Advanced Techniques in OpenROAD
3 Days
OReServer
OpenROAD Server and EClient for Developers [Option]
3 Days

ABF Developer/ Maintainer

Course Description

Duration

IngresSQL
Introduction to the Ingres Product and Ingres SQL
5 Days

ABF
Application Development in Ingres ABF

4 Days
IRW
Ingres Reportwriter [Recommended]
2 Days

Report Developer / Maintainer

Course Description

Duration

IngresSQL
Introduction to the Ingres Product and Ingres SQL
5 Days
IRW - Ingres Reportwriter [Recommended] 2 Days
We have a number of scheduled runnings for core classes in EMEA, APAC and North America. Other courses are offered on an on-demand basis. Please contact education@actian.com for further information.

E-Learning Training Courses

Course Code

Training Room Classes

Course Code
DataConnect v10 Core DATACON
Ingres Database Management For Oracle DBAs DBMORA
Managing Ingres Installations and Databases INGDBM
Introduction to the Ingres Product and Ingres SQL INGSQL
New Features in Ingres INGUPD
Ingres 1-Day Overview IOVVIEW
OpenROAD 1-Day Overview OOVVIEW
OpenRoad Application Development and Maintenance OPROAD
OpenRoad 5.1 New Features from OpenROAD 4.1 OR51UP
Advanced Techniques in OpenROAD ORADV
OpenRoad Application Server and EClient for Developers ORESERV
Optimising Ingres Performance PERFORM
Versant Object Database Administration VERDBM
Versant Fastobjects C++ API Programming VFASTOB
Managing Vector Databases VWDBM
Please use the following list to jump to a regional schedule

Whether you are new to Ingres or an old hand, our education courses are designed to make sure you learn how to make best use of the advanced features and functionality in the latest release. For inquiries about our education programs, please email education@actian.com, or formations@actian.com (FR).

America

Location - Austin, USA

Course Code Date
DataConnect v10 Core DATACON 2014-10-06
DataConnect v10 Core DATACON 2014-12-08
DataConnect v10 Core DATACON 2015-02-09
DataConnect v10 Core DATACON 2015-04-13
DataConnect v10 Core DATACON 2015-06-08
DataConnect v10 Core DATACON 2015-08-10
DataConnect v10 Core DATACON 2015-10-05
DataConnect v10 Core DATACON 2015-12-07

Location - New York City, USA

Course Code Date
Managing Ingres Installations and Databases INGDBM 2014-12-01
Managing Vector Databases VWDBM 2014-12-08
Ingres 1-Day Overview IOVVIEW 2015-02-02
Introduction to the Ingres Product and Ingres SQL INGSQL 2015-02-02
Managing Vector Databases VWDBM 2015-02-09
Ingres 1-Day Overview IOVVIEW 2015-09-21
Introduction to the Ingres Product and Ingres SQL INGSQL 2015-09-21
Managing Vector Databases VWDBM 2015-09-28
Managing Ingres Installations and Databases INGDBM 2015-11-30
Managing Vector Databases VWDBM 2015-12-07

Location - Redwood City, USA

Course Code Date
Ingres 1-Day Overview IOVVIEW 2015-05-11
Introduction to the Ingres Product and Ingres SQL INGSQL 2015-05-11
Managing Vector Databases VWDBM 2015-05-18
Managing Ingres Installations and Databases INGDBM 2015-08-10
Managing Vector Databases VWDBM 2015-08-17

Europe, Middle East, Africa

Location - Paris, France

Course Code Date
Managing Ingres Installations and Databases INGDBM 2015-02-02
Optimising Ingres Performance PERFORM 2015-03-23
Managing Ingres Installations and Databases INGDBM 2015-04-13
Optimising Ingres Performance PERFORM 2015-05-18
Managing Ingres Installations and Databases INGDBM 2015-06-22
Optimising Ingres Performance PERFORM 2015-07-20
Managing Ingres Installations and Databases INGDBM 2015-08-24
Optimising Ingres Performance PERFORM 2015-09-21
Managing Ingres Installations and Databases INGDBM 2015-10-19
Optimising Ingres Performance PERFORM 2015-11-23

Location - Hamburg, Germany (English materials with German instructor)

Course Code Date
Optimising Ingres Performance PERFORM 2014-10-13
Ingres 1-Day Overview IOVVIEW 2014-11-03
Introduction to the Ingres Product and Ingres SQL INGSQL 2014-11-03
OpenRoad 5.1 New Features from OpenROAD 4.1 OR51UP 2014-11-10
OpenRoad Application Server and EClient for Developers ORESERV 2014-11-12
New Features in Ingres INGUPD 2014-11-26
Managing Ingres Installations and Databases INGDBM 2014-12-08
Ingres 1-Day Overview IOVVIEW 2015-01-19
Introduction to the Ingres Product and Ingres SQL INGSQL 2015-01-19
Managing Ingres Installations and Databases INGDBM 2015-02-02
Versant Object Database Administration VERDBM 2015-02-10
Optimising Ingres Performance PERFORM 2015-02-23
Versant Fastobjects C++ API Programming VFASTOB 2015-03-10
New Features in Ingres INGUPD 2015-03-18
New Features in Ingres INGUPD 2015-05-12
Versant Object Database Administration VERDBM 2015-06-16
Ingres 1-Day Overview IOVVIEW 2015-07-27
Introduction to the Ingres Product and Ingres SQL INGSQL 2015-07-27
New Features in Ingres INGUPD 2015-08-04
Versant Fastobjects C++ API Programming VFASTOB 2015-09-15
Managing Ingres Installations and Databases INGDBM 2015-09-21
Optimising Ingres Performance PERFORM 2015-10-12
Ingres 1-Day Overview IOVVIEW 2015-11-02
Introduction to the Ingres Product and Ingres SQL INGSQL 2015-11-02
Versant Object Database Administration VERDBM 2015-11-10
New Features in Ingres INGUPD 2015-11-25
Managing Ingres Installations and Databases INGDBM 2015-12-07

Location - Leeds, UK

Course Code Date
Advanced Techniques in OpenROAD ORADV 2014-09-30
Ingres 1-Day Overview IOVVIEW 2015-05-18
Introduction to the Ingres Product and Ingres SQL INGSQL 2015-05-18
Managing Ingres Installations and Databases INGDBM 2015-06-08

Location - Slough, UK

Course Code Date
Ingres 1-Day Overview IOVVIEW 2014-10-20
Introduction to the Ingres Product and Ingres SQL INGSQL 2014-10-20
Managing Ingres Installations and Databases INGDBM 2014-11-03
OpenRoad Application Development and Maintenance OPROAD 2014-11-10
OpenROAD 1-Day Overview OOVVIEW 2014-11-10
Advanced Techniques in OpenROAD ORADV 2014-11-25
Optimising Ingres Performance PERFORM 2014-12-08
Ingres 1-Day Overview IOVVIEW 2015-01-12
Introduction to the Ingres Product and Ingres SQL INGSQL 2015-01-12
Managing Ingres Installations and Databases INGDBM 2015-02-23
Optimising Ingres Performance PERFORM 2015-04-13
Managing Vector Databases VWDBM 2015-04-28
Managing Vector Databases VWDBM 2015-06-22
Ingres 1-Day Overview IOVVIEW 2015-10-19
Introduction to the Ingres Product and Ingres SQL INGSQL 2015-10-19
Managing Vector Databases VWDBM 2015-11-02
Managing Ingres Installations and Databases INGDBM 2015-11-23
Optimising Ingres Performance PERFORM 2015-12-07

Australia, New Zealand and Asia Pacific

Location - APAC, Australia

Course Code Date
Ingres Database Management For Oracle DBAs DBMORA 2014-10-13
Managing Vector Databases VWDBM 2014-10-20
OpenRoad Application Development and Maintenance OPROAD 2014-11-10
OpenROAD 1-Day Overview OOVVIEW 2014-11-10
Managing Vector Databases VWDBM 2014-11-24
Ingres Database Management For Oracle DBAs DBMORA 2015-02-23
Ingres 1-Day Overview IOVVIEW 2015-03-03
Introduction to the Ingres Product and Ingres SQL INGSQL 2015-03-03
Managing Ingres Installations and Databases INGDBM 2015-03-16
OpenRoad Application Development and Maintenance OPROAD 2015-04-13
OpenROAD 1-Day Overview OOVVIEW 2015-04-13
Ingres 1-Day Overview IOVVIEW 2015-05-11
Introduction to the Ingres Product and Ingres SQL INGSQL 2015-05-11
Managing Vector Databases VWDBM 2015-05-25
Managing Ingres Installations and Databases INGDBM 2015-06-01
OpenRoad Application Development and Maintenance OPROAD 2015-06-22
OpenROAD 1-Day Overview OOVVIEW 2015-06-22
Ingres 1-Day Overview IOVVIEW 2015-07-06
Introduction to the Ingres Product and Ingres SQL INGSQL 2015-07-06
Managing Vector Databases VWDBM 2015-07-20
Managing Ingres Installations and Databases INGDBM 2015-08-03
OpenRoad Application Development and Maintenance OPROAD 2015-08-17
OpenROAD 1-Day Overview OOVVIEW 2015-08-17
Ingres 1-Day Overview IOVVIEW 2015-09-07
Introduction to the Ingres Product and Ingres SQL INGSQL 2015-09-07
Managing Vector Databases VWDBM 2015-09-21
Ingres Database Management For Oracle DBAs DBMORA 2015-10-12
Managing Vector Databases VWDBM 2015-10-26
OpenRoad Application Development and Maintenance OPROAD 2015-11-09
OpenROAD 1-Day Overview OOVVIEW 2015-11-09
Managing Vector Databases VWDBM 2015-11-23

ONLINE

The Ingres Instructor-Led Online Training environment is an alternative to our traditional in-class training, without the need for expensive travel.

Ingres ILO Environment

Our ILO environment provides

  • Interactive, instructor led training
  • Live demos
  • Pre-configured remote lab environment
  • Classes available to suit your timezone
  • PDF handouts of course material

"Closed" ILO Class

Efficient training for coworkers across multiple locations. If your team is geographically dispersed you can also request that our instructor-led online format be delivered as a "Closed" course for your company.