Nouvelle publication

查找

Annonce
· Mai 12

Do you have the InterSystems IRIS SQL Specialist certification? Beta testers needed for our upcoming InterSystems IRIS SQL Professional certification exam

Hello IRIS community,

InterSystems Certification is currently developing a certification exam for InterSystems IRIS SQL professionals, and if you match the exam candidate description given below, we would like you to beta test the exam! The exam will be available for beta testing starting May 19, 2025.

Please note: Only candidates with the pre-existing InterSystems IRIS SQL Specialist certification are eligible to take the beta. Interested in the beta but don’t have the SQL Specialist certification? Take the SQL Specialist exam!

Eligible candidates will receive an email from the certification team on May 19, 2025 with instructions on scheduling the exam.

Beta testing will be completed June 30, 2025.

What are my responsibilities as a beta tester?

You will schedule and take the exam by June 30th. The exam will be administered in an online proctored environment free of charge (the standard fee of $150 per exam is waived for all beta testers). The InterSystems Certification team will then perform a careful statistical analysis of all beta test data to set a passing score for the exam. The analysis of the beta test results will take 6-8 weeks, and once the passing score is established, you will receive an email notification from InterSystems Certification informing you of the results. If your score on the exam is at or above the passing score, you will have earned the certification!

Note: Beta test scores are completely confidential.

How is this exam different from the InterSystems IRIS SQL Specialist exam?

This new exam - InterSystems IRIS SQL Professional - covers higher-level SQL topics and is recommended for candidates with 4 to 6 years of relevant experience, compared to the 1 to 2 years recommended for the SQL Specialist exam.

Interested in participating? Read the Exam Details below.

Exam Details

Exam title: InterSystems IRIS SQL Professional

Candidate description: A developer or solutions architect who

  • Designs IRIS SQL applications
  • Manages IRIS SQL operations
  • Uses IRIS SQL
  • Loads and efficiently queries datasets stored in IRIS SQL

Number of questions: 38

Time allotted to take exam: 2 hours

Recommended preparation: Review the content below before taking the exam.

Online Learning:

Recommended practical experience:

  • 4 to 6 years of experience developing and managing IRIS SQL applications is recommended.
  • At least 2 years of experience working with ObjectScript and globals in InterSystems IRIS is recommended.

Exam practice questions

A set of practice questions is provided here to familiarize candidates with question formats and approaches.

Exam format

The questions are presented in two formats: multiple choice and multiple response. Access to InterSystems IRIS Documentation will be available during the exam.

DISCLAIMER: Please note this exam has a 2-hour time limit. While InterSystems documentation will be available during the exam, candidates will not have time to search the documentation for every question. Thus, completing the recommended preparation before taking the exam, and searching the documentation only when absolutely necessary during the exam, are both strongly encouraged!

System requirements for beta testing

  • Working camera & microphone
  • Dual-core CPU
  • At least 2 GB available of RAM memory
  • At least 500 MB of available disk space
  • Minimum internet speed:
    • Download - 500kb/s
    • Upload - 500kb/s

 

Exam topics and content

The exam contains questions that cover the areas for the stated role as shown in the exam topics chart immediately below.

 

Topic

Subtopic

Knowledge, skills, and abilities

1. Designs IRIS SQL applications 1.1 Designs a SQL schema
  1. Distinguishes use cases for row vs columnar table layout
  2. Distinguishes use cases for different index types
  1.2 Designs advanced schemas
  1. Recalls anatomy of Globals (subscript and value)
  2. Interprets relationship between table structure and Globals
  3. Distinguishes the (Globals) level at which mirroring/journaling operates from the SQL layer
  4. Distinguishes the differences between date/time data types
  5. Interprets the overhead associated with stream data
  6. Identifies use cases for text search
  1.3 Writes business logic 
  1. Identifies use cases for UDFs, UDAFs, and SPs
  1.4 Develops Object/Relational applications
  1. Recalls SQL best practices when defining classes
  2. Uses Object access to interact with individual rows
  3. Identifies SQL limitations with class inheritance
  4. Uses serial and object properties
  5. Identifies use cases for collection properties
  6. Distinguishes class relationships from Foreign Keys
  1.5 Deploys SQL applications
  1. Determines what needs to be part of a deployment
2. Uses IRIS SQL   2.1 Manages IRIS query processing
  1. Identify benefits of the universal query cache
  2. List considerations made by the optimizer
  3. Differentiates client and server-side problems
  4. Uses Statement Index to find statement metadata
  5. Distinguishes between the use of parameters and constants in a query
  6. Distinguishes between transaction and isolation levels
  2.2 Interprets query plans 
  1. Identifies the use of indices in a query plan
  2. Identifies vectorized (columnar) query plans
  3. Uses hints to troubleshoot query planning
  4. Identifies opportunities for indices, based on a query plan
  2.3 Uses IRIS SQL in applications
  1. Distinguishes use cases for Dynamic SQL and Embedded SQL 
  2.4 Uses IRIS-specific SQL capabilities 
  1. Uses arrow syntax for implicit joining
  2. Determines use cases for explicit use of collation functions
3. Manages IRIS SQL operations 3.1 Manages SQL operations
  1. Identifies use cases for purging queries and rebuilding indices
  2. Recalls impact of purging queries and rebuilding indices
  3. Identifies use cases for un/freezing query plans, including automation
  4. Identifies use cases for (bitmap) index compaction
  5. Uses the runtime stats in the Statement Index to find statements with optimization opportunities
  3.2 Configures InterSystems SQL options 
  1. Recalls relevant system configuration options (e.g. lock threshold)
  2. Differentiates scale-out options, ECP, and sharding
  3.3 Manages SQL security
  1. Recalls to apply SQL privilege checking when using Embedded SQL
  3.4 Uses PTools for advanced performance analysis  
  1. Identifies use cases for using PTools

Interested in participating? Eligible candidates will receive an email from the certification team on May 19th with instructions on how to schedule and take the exam.

3 Comments
Discussion (3)2
Connectez-vous ou inscrivez-vous pour continuer
Résumé
· Mai 12

Publications des développeurs d'InterSystems, semaine Mai 05 - 11, 2025, Résumé

Mai 05 - 11, 2025Week at a GlanceInterSystems Developer Community
Annonce
· Mai 12

Technology Bonuses for the InterSystems FHIR and Digital Health Interoperability Contest 2025

Hi Developers!

Here are the technology bonuses for the InterSystems FHIR and Digital Health Interoperability Contest 2025 that will give you extra points in the voting:

  • InterSystems FHIR usage - 3
  • Digital Health Interoperability - 4
  • Vector Search - 3
  • LLM AI or LangChain usage: Chat GPT, Gemini and others - 3
  • Embedded Python - 2
  • Docker container usage - 2 
  • IPM Package deployment - 2
  • Online Demo - 2
  • Implement InterSystems Community Idea - 4
  • Find a bug in InterSystems FHIR server - 2
  • Find a bug in InterSystems Interoperability - 2
  • New First Article on Developer Community - 2
  • New Second Article on Developer Community - 1
  • First Time Contribution - 3
  • Video on YouTube - 3

See the details below.<--break-><--break->

<--break->InterSystems FHIR usage - 3 points

Implement InterSystems FHIR server in your application either as a standalone cloud FHIR server or as a component of InterSystems IRIS for Health and collect 3 bonus points!

Digital Health Interoperability - 4 points

Collect 4 bonus points if your application is a healthcare interoperability solution that uses InterSystems Interoperability to transfer or/and transform healthcare data via messages or it uses healthcare format data transformation. Here are a couple of examples: one, two, three.

Vector Search - 3 points

Starting from the 2024.1 release, InterSystems IRIS contains a new technology vector search that allows building vectors over InterSystems IRIS data and performing a search of already indexed vectors. Use it in your solution and collect 3 bonus points. Here is the demo project that leverages it.

LLM AI or LangChain usage: Chat GPT, Bard, and others - 2 points

Collect 3 bonus expert points for building a solution that uses LangChain libs or Large Language Models (LLM) such as ChatGPT, Bard and other AI engines like PaLMLLaMA, and more. AutoGPT usage count,s too.

A few examples already could be found in Open Exchange: iris-openai, chatGPT telegram bot, rag-demo.

Here is an article with langchain usage example.

Embedded Python - 2 points

Use Embedded Python in your application and collect 2 extra points. Base template, example application with Interoperability.

Docker container usage - 2 points

The application gets a 'Docker container' bonus if it uses InterSystems IRIS  running in a docker container. Here is the simplest template to start from.

ZPM Package deployment - 2 points

You can collect the bonus if you build and publish the ZPM(InterSystems Package Manager) package for your Full-Stack application so it could be deployed with:

zpm "install your-multi-model-solution"

command on IRIS with ZPM client installed. 

ZPM client. Documentation.

Online Demo of your project - 2 points
Collect 2 more bonus points if you provision your project to the cloud as an online demo at any public hosting.  

Implement Community Opportunity Idea - 4 points

Implement any idea from the InterSystems Community Ideas portal which has the "Community Opportunity" status. This will give you 4 additional bonus points.

Find a bug in InterSystems Digital Health Interoperability  - 2 points
We want the broader adoption of InterSystems Interoperability engine so we encourage you to report the bugs you will face during the development of your interoperability application with IRIS in order to fix it. Please submit the bug here in a form of issue and how to reproduce it. You can collect 2 bonus points for the first reproducible bug.

Find a bug in InterSystems FHIR Server - 2 points
We want the broader adoption of InterSystems FHIR, so we encourage you to report the bugs you will face during the development of your FHIR application in order to fix them. Please submit the bug here in a form of an issue and how to reproduce it. You can collect 2 bonus points for the first reproducible bug.

New First Article on Developer Community - 2 points

Write a brand new article on Developer Community that describes the features of your project and how to work with it. Collect 2 points for the article.

New Second Article on Developer Community - 1 point

You can collect one more bonus point for the second new article or the translation regarding the application. The 3rd and more will not bring more points but the attention will all be yours.

First-Time Contribution - 3 points

Collect 3 bonus points if you participate in InterSystems Open Exchange contests for the first time!

Video on YouTube - 3 points

Make new YouTube videos that demonstrate your product in action and collect 3 bonus points for each.

The list of bonuses is subject to change. Stay tuned!

Good luck in the competition!

Discussion (0)2
Connectez-vous ou inscrivez-vous pour continuer
Article
· Mai 12 1m de lecture

Introducing Smart Clinical Copilot: An AI-Powered Decision Support System for Modern Healthcare

Introducing Smart Clinical Sidechick — the intelligent, no-drama partner your EHR wishes it could be. She reads FHIR data in real time, interprets lab results without ghosting, and explains clinical alerts like she actually cares. Built with GPT-4 brains and YAML sass, she’s not here to replace your main EHR—just to make it look bad. Tired of irrelevant alerts and cryptic warnings? Sidechick serves up real, explainable insights, not vague “elevated risk” vibes. And when your backend crashes, she doesn’t panic—she self-heals. Secure, responsive, and (unlike your last vendor) emotionally available. Slide into GitHub and make her official. 

Discussion (0)1
Connectez-vous ou inscrivez-vous pour continuer