Topic outline

  • InterSystems SQL Overview

    Learn about the options developers have for using SQL within InterSystems IRIS® data platform, and how to use class queries, dynamic SQL, and embedded SQL in your InterSystems ObjectScript classes.

    This course contains three instructional lessons and several quiz questions. The videos and simulations are best viewed in full-screen mode.

    Version Updates The instructional content of this course has not changed from previous versions. Updates include:

    • Updated for InterSystems IRIS data platform

    Prerequisite Learning or Experience SQL experience.

    Audience This course is intended for anyone who wants an introduction to using SQL within InterSystems IRIS.

    Learning Objectives By the end of this course, you will be able to:

    • Test an SQL query using both Terminal and the Management Portal.
    • Determine whether to use a class query, dynamic SQL, or embedded SQL in your application.
    • List the steps needed to implement a class query, dynamic SQL, or embedded SQL in your application.

    Duration 30 minutes.

    Grading CriteriaThis course is not graded; quiz questions are provided for self-assessment.

    Resources Needed None.

    Note:
    This course is being updated; it currently uses the Atelier extension for the Eclipse IDE, and Atelier has been deprecated. We recommend using the InterSystems ObjectScript Extension Pack in Visual Studio Code instead. See instructions for using the VS Code extension.