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

5-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
  • 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
£2,000.00 plus V.A.T. per person

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