Skip to content
Узнайте о продуктах и решениях InterSystems, возможностях карьерного роста и многом другом.

Developing with InterSystems Objects and SQL

Use development tools and techniques of InterSystems Objects and InterSystems SQL

5-Day Course

Below is the upcoming schedule for this course:*
  • Mar 18, 2024 - Mar 22, 2024 9AM - 5PM ET* Virtual
  • Apr 29, 2024 - May 03, 2024 9AM - 5PM ET* In-Person Cambridge, MA

Course Pricing

Classroom Training

In Person Classroom

$2,100 per student (33% discount!)

Virtual Classroom
$3,100 per student

Register for a Course

Private Training

In Person Private Classroom

$14,000 per class (18% discount!)

Virtual Private Classroom
$17,000 per class

Request Private Training


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.