Skip to content
Suchen Sie nach Produkten und Lösungen von InterSystems, Karrieremöglichkeiten und mehr. Die Ergebnisse umfassen neben Suchtreffern von InterSystems-Webseiten auch Inhalte aus unserer Entwickler-Community, unseren Produktdokumentationen und Schulungsangeboten.

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.