Skip to content
Etsi tietoja InterSystemsin tuotteista ja ratkaisuista, uramahdollisuuksista ja muusta. Tuloksia ovat lisäksi kehittäjäyhteisömme sisältö, tuotedokumentaatio ja koulutussivustot.

Developing with InterSystems Objects and SQL

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

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

    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 an 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

    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.