Topic outline

• InterSystems SQL Overview

  InterSystems SQL Overview

  Content Type
  Course

  Duration
  1h 30m

  Level
  Introductory

  Learn about the options developers have for using SQL within InterSystems IRIS® data platform, and how to use dynamic SQL, embedded SQL, and class queries in your InterSystems IRIS class definition. Gain hands-on experience writing these within an InterSystems class.

  Learning Objectives

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

  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?

  In this course, you learned about the three modes of using SQL with InterSystems IRIS. You have gained hands-on experience in using each mode in a relevant scenario as well as testing your code with the InterSystems IRIS Terminal.

  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!