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

Online resources that will help you familiarize yourself with material covered in class but are not required include:

  • Overview
    • Benefits
    • Features
    • Platforms and Versions
  • Development Introduction
    • Introduction to classes and methods
    • Packages
    • Persistent and serial classes
    • Errors
  • Architecture
    • Namespaces and databases
    • Globals and routines
    • System databases
    • Naming conventions
  • Classes
    • OOP/SQL correspondence
    • Classes revisited
    • Multiple inheritance
    • Class compilation
    • $System
  • Properties
    • Properties
    • Datatypes
    • Accessor and mutator methods
    • Reference properties
    • Implicit joins
    • Foreign keys
    • Cloning objects
    • Computed properties
  • Unit Testing
    • Unit testing
    • Benefits
    • Framework
  • Collections
    • Collections
    • List collections
    • Array collections
    • Object collections
    • Data population
  • Relationships
    • Relationships
    • Many-to-many relationships
    • Performance options
  • Streams and Files
    • Streams
    • Files
  • Queries
    • Sets of results
    • Embedded SQL
    • Dynamic SQL
    • SQL stored procedures
    • Command line shell
    • Views
    • Other SQL features
  • Indexes and Tuning
    • Indexes
    • Indexing options
    • Collation
    • Index types
    • Query performance tuning
    • Index methods
  • Methods
    • Inherited methods
    • Scripting languages
    • Method attributes
    • OOP callback methods
    • SQL triggers
    • ProcedureBlock methods
    • Code mode
    • Special method syntax
  • Debugging
    • Debugging with Studio
    • Debugging with ZBreak

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.