Join us for InterSystems Virtual Summit 2021
October 26 - 29
X

Developing with InterSystems Objects and SQL

Developing with InterSystems Objects and SQL

5 days, $2800/student

Request Registration for a Course

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é.

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 familiarize 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 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.