Topic outline

• InterSystems SQL Overview

  InterSystems SQL Overview

  Content Type
  Course

  Duration
  30m

  Level
  Introductory

  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. Learn how to use class queries, dynamic queries, and embedded SQL queries within an InterSystems class.

  Learning Objectives

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

  Prerequisites

  • SQL experience. Suggested content:
    • SQL Tutorial (W3Schools)
    • Intro to SQL (Khan Academy)
• Start the Course

  Start the Course

  You must be logged in to view this content.

  Don't have an InterSystems account? Create a new account.
• What's Next?

  What's Next?

  You have learned the basics for using SQL in InterSystems IRIS and seen how to use the Management Portal and Terminal to test your SQL queries. You have also seen how to use class queries, dynamic SQL, and embedded SQL within InterSystems IRIS to run SQL queries.

  Continue learning with the following resources:

  • Learn more about InterSystems IRIS objects (online course, 30m).
  • Get started with InterSystems ObjectScript (online course, 1h 30m).
  • Learn how to create an InterSystems class definition (online course, 45m).
  • Read about using InterSystems SQL (documentation, 30m).

  • Share Your Feedback!