Topic outline

• Testing SQL Queries

  Testing SQL Queries

  See how to test SQL queries using the Management Portal and Terminal directly within InterSystems IRIS® data platform. Validating queries before using them in an InterSystems class ensures that you retrieve the result you expect.
• Code Used in This Video

  Code Used in This Video

  Reference	Timestamp	Code
  Simple query example to retrieve all columns	0:56	select * from University.CourseCatalog
  Example query to filter by term and year using an implicit join	1:11	select CourseID, CourseSection, CourseID->CourseName, Instructor, Instructor->FullName from University.CourseCatalog where TermYear = 'Spring2018'
  Command to test SQL in Terminal	1:35	do $system.SQL.Shell()
• What's Next?

  What's Next?

  To learn more about SQL options within InterSystems IRIS, take the online course InterSystems SQL Overview (30m).