Skip to content

Developing with InterSystems Objects and SQL

Use development tools and techniques of InterSystems Objects and InterSystems SQL

5 days

Register for a Course
In-person classroom: $2,100/student (a 33% discount!)
Virtual classroom: $3,100/student

Request Private Training
In-person private classroom: $14,000/class (an 18% discount!)
Virtual private classroom: $17,000/class

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

This 5-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 an IDE, object-oriented design, SQL and unit testing.

This course is applicable for users of InterSystems IRIS® data platform and InterSystems 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

  • Objects
  • SQL
  • Data integrity

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

  • OOP/SQL correspondence
  • Classes revisited
  • Multiple inheritance
  • Class compilation
  • REST
  • $System
Properties and Datatypes

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

  • Unit testing
  • Benefits
  • Framework
Collections and Callbacks

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

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

  • Streams
  • Files
InterSystems SQL

  • Stored procedures
  • Sets of results
  • Dynamic SQL
  • Embedded SQL
  • T-SQL
  • Triggers
  • Views
  • Other SQL features

Indexes and Tuning

  • Indexes
  • Indexing options
  • Collation
  • Index types
  • iFind searching
  • Query performance tuning
  • Index methods

  • Debugging with IDEs
  • 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 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 afterward, we will provide a credit toward a future class.