Skip to content
Use the search to find information 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

5-Day Course

Below is the upcoming schedule for this course:*
  • Jan 06, 2025 - Jan 10, 2025 9AM - 5PM ET* Virtual
  • Feb 10, 2025 - Feb 14, 2025 9AM - 5PM ET* Virtual
  • Mar 24, 2025 - Mar 28, 2025 9AM - 5PM ET* In-Person Cambridge, MA

Course Pricing

Classroom Training

In Person Classroom

$2,100 per student (33% discount!)

Virtual Classroom
$3,100 per student

Register for a Course

Private Training

In Person Private Classroom

$14,000 per class (18% discount!)

Virtual Private Classroom
$17,000 per class

Request Private Training

Overview

This 5-day course teaches programmers how to use the tools and techniques within the InterSystems® development environment. Students develop a database application using object-oriented design, building different types of IRIS classes. They learn how to store and retrieve data using Objects or SQL, and decide which approach is best for different use cases. They write code using ObjectScript, Python, and SQL, with most exercises offering the choice between ObjectScript and Python, and some exercises requiring a specific language.

Programming Languages Note: This course includes several Python and SQL features specific to IRIS but is not a comprehensive Python or SQL language course. It covers ObjectScript in relatively more depth. InterSystems doesn’t offer an ObjectScript-only course; we recommend Introducing ObjectScript and the ObjectScript Tutorial in the documentation.

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

Course Agenda

Overview
  • Benefits and Features
  • Platforms and Versions
Development Environment
  • Visual Studio Code
  • InterSystems Studio
  • Windows Terminal
  • ObjectScript shell
  • Other shells
  • Management Portal
  • Class Reference
  • More developer tools
  • Developer Community
Development Introduction: Objects
  • Methods
  • Classes
  • Variables
  • Objects
  • Properties
  • Reference properties
Development Introduction: SQL
  • Tables
  • Data population
  • Implicit joins
  • Indexes
ObjectScript and JSON
  • ObjectScript
  • Macros
  • $system
  • JSON
Data Types
  • Data types for variables
  • Data type classes
Unit Testing
  • Unit testing
  • Benefits
  • Framework
Methods Using SQL
  • Simple Embedded SQL
  • Dynamic SQL
  • Cursor-based Embedded SQL
  • Class queries
Architecture
  • Namespaces and databases
  • Globals and routines
  • System databases
Classes
  • Objects and SQL correspondence
  • Class definition details
  • Inheritance
  • Member inheritance
Data Integrity
  • Transactions
  • Concurrency control
  • Foreign Key constraints
Object Composition
  • Serial objects
  • Streams
  • Collections

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.