Skip to content
Search to learn about InterSystems products and solutions, career opportunities, and more.

Developing with InterSystems Objects and SQL

Use development tools and techniques of InterSystems Objects and InterSystems SQL

4-Day Course

Below is the upcoming schedule for this course:*
  • Apr 22, 2024 - Apr 25, 2024 9AM - 5:30 PM GMT In-Person InterSystems UK Office
    Windsor, Berkshire
  • Jun 10, 2024 - Jun 13, 2024 9AM - 5:30 PM GMT In-Person InterSystems UK Office
    Windsor, Berkshire
  • Sep 16, 2024 - Sep 19, 2024 9AM - 5:30 PM GMT In-Person InterSystems UK Office
    Windsor, Berkshire
  • Nov 11, 2024 - Nov 15, 2024 9AM - 5:30 PM GMT In-Person InterSystems UK Office
    Windsor, Berkshire

Course Pricing

Classroom Training

In Person Classroom

£1,600.00 plus V.A.T. per person (33% discount!)

Register for a Course

Private Training

In Person Private Classroom
£2,000 plus V.A.T per day plus travel/expenses

Request Private Training

Overview

This 4-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é®

Prerequisites

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 familiarise yourself with material covered in class but are not required include:

Course Agenda

Overview
  • Benefits
  • Features
  • Platforms and Versions
Development Introduction
  • Objects
  • SQL
  • Data integrity
Architecture
  • Namespaces and databases
  • Globals and routines
  • System databases
  • Naming conventions
    Classes
    • 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
        • 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
            • 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 cancelled 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