Developing with InterSystems Objects and SQL

£1400 plus V.A.T. per person

This five-day course teaches programmers how to use the tools and techniques within the InterSystems development environment to build high-performance transactional applications. Learners build a complex application using the Atelier IDE, object-oriented design, SQL and unit testing.

This course is applicable for users of InterSystems IRIS Data Platform and Caché.


You are required to have the following knowledge/experience prior to attending this course:

  • Programming experience

Online resources that will help you familiarize yourself with material covered in class but are not required include:

  • Overview
    • Benefits
    • Features
    • Platforms and Versions
  • Development Introduction
    • Introduction to classes and methods
    • Packages
    • Persistent and serial classes
    • Errors
  • Development Setup
    • Development sandbox
    • Namespace and database setup
    • Resource and role setup
    • User setup
    • ODBC setup
    • Remote System Access setup
  • Architecture
    • Namespaces and databases
    • Globals and routines
    • System databases
    • Naming conventions
  • Classes
    • OOP/SQL correspondence
    • Classes revisited
    • Multiple inheritance
    • Class compilation
    • $System
  • Properties
    • Properties
    • Datatypes
    • Accessor and mutator methods
    • Reference properties
    • Implicit joins
    • Foreign keys
    • Cloning objects
    • Computed properties
  • Unit Testing
    • Unit testing
    • Benefits
    • Framework
  • Collections
    • Collections
    • List collections
    • Array collections
    • Object collections
    • Data population
  • Relationships
    • Relationships
    • Many-to-many relationships
    • Performance options
  • Streams and Files
    • Streams
    • Files
  • Queries
    • Sets of results
    • Embedded SQL
    • Dynamic SQL
    • SQL stored procedures
    • Command line shell
    • Views
    • Other SQL features
  • Indexes and Tuning
    • Indexes
    • Indexing options
    • Collation
    • Index types
    • Query performance tuning
    • Index methods
  • Methods
    • Inherited methods
    • Scripting languages
    • Method attributes
    • OOP callback methods
    • SQL triggers
    • ProcedureBlock methods
    • Code mode
    • Special method syntax
  • Debugging
    • Debugging with Studio
    • Debugging with ZBreak

Class size is limited to 12 students in order to provide an optimal learning enviroment which includes time for personal instruction. Courses are held at InterSystems Felstead House, 2-6 Frances Road Windsor, Berkshire SL4 3AA our training facility in Windsor Berkshire. Schedules subject to change.

Our classroom opens at 9am. Classes run from 9.30am – 5pm.

Local Hotels

The Mercure Windsor

The Castle Hotel
18 High Street
Windsor, Berkshire
Tel: +44(0)1753 851011

The MacDonald Windsor Hotel

High Street
Berkshire SL4 1LH
Tel: 0844 879 9101

Ye Harte & Garter Hotel

High Street
Tel: +44(0) 1753 863426

Sir Christopher Wrens House Hotel

Thames Street
Tel: +44(0) 1753 861354

The Christopher Hotel

Eton High Street
Tel +44(0) 1753 852359

The Royal Adelaide Hotel

46 Kings Road
Tel: +44(0)1753 863916

Holiday Inn Express Windsor

71 Alma Road
Berkshire SL4 3HD
Tel :+44(0) 1753 857541

Travelodge Windsor

34 King Edward Court
Berkshire SL4 1TG
Tel: 0871 984 6331

Marriott Courtyard

1 Church Street
Chalvey, Slough
Tel: +44(0) 1753 551551

Copthorne Hotel

Cippenham Lane
Cippenham, Slough
Tel: +44(0) 1753 516222

InterSystems reserves the right to cancel or reschedule a class at least 7 business days prior to the announced start date. We will usually cancel a class if there are less than five registrants. In the event of cancellation by InterSystems, we will refund any payment made for the canceled course.

Tuition is fully refundable if a registrant notifies InterSystems at least 10 business days prior to the announced start date. For cancellation received afterwards, we will provide a credit towards a future class.

For your convenience, we will teach any standard class at your site. In addition, we can customize a course to suit your specific needs. The cost of on-site courses* depends on course length, as follows:

1 day – £1500.00+vat
2 days -£3000.00+vat
* Plus instructor expenses £1500.00

To register or to find out more, call our Training co-ordinator Munjula Sharda on 01753 855450 or e-mail Complete course descriptions and outlines are available.