Skip to content
Search to learn about InterSystems products and solutions, career opportunities, and more.

Developing with InterSystems Objects and SQL

InterSystems IRIS, Caché, InterSystems ObjectScript, Studio, Application Development, Object Oriented Programming, SQL, Unit Testing

Register for a Course

£1,600 plus V.A.T. per person

    This course is run over over 4 days, it 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 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

    Preparing for Class

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

    Course Agenda


    • 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

    • Namespaces and databases
    • Globals and routines
    • System databases
    • Naming conventions

    • OOP/SQL correspondence
    • Classes revisited
    • Multiple inheritance
    • Class compilation
    • $System

    • Properties
    • Datatypes
    • Accessor and mutator methods
    • Reference properties
    • Implicit joins
    • Foreign keys
    • Cloning objects
    • Computed properties
    Unit Testing

    • Unit testing
    • Benefits
    • Framework

    • Collections
    • List collections
    • Array collections
    • Object collections
    • Data population

    • Relationships
    • Many-to-many relationships
    • Performance options
    Streams and Files

    • Streams
    • Files

    • 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

    • Inherited methods
    • Scripting languages
    • Method attributes
    • OOP callback methods
    • SQL triggers
    • ProcedureBlock methods
    • Code mode
    • Special method syntax

    • Debugging with Studio
    • Debugging with ZBreak

    Cancellation Policy

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

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

    For more information

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