Skip to content
Effectuez une recherche pour en savoir plus sur les produits et solutions InterSystems, les offres d'emploi, etc.

Developing with InterSystems Objects and SQL - In Person

Use development tools and techniques of InterSystems Objects and InterSystems SQL

Register for a Course

5 days, $2,100/student - a 33% discount!

    InterSystems IRIS, Caché, Caché ObjectScript, Studio, 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 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.


    Ask Learning Services

    Questions about Learning Services offerings?
    Fill out this form and we’ll get back to you.
    *Required Fields
    Highlighted fields are required
    *Required Fields
    Highlighted fields are required