Nueva publicación

Rechercher

Anuncio
· 22 abr, 2024

Beta testers needed for our upcoming InterSystems IRIS SQL Specialist certification exam

#Certificación #Global Summit 2024 #Indexación #Tablas relacionales #SQL #InterSystems IRIS #InterSystems IRIS for Health

Hello IRIS Community,

InterSystems Certification is developing a certification exam for InterSystems IRIS SQL specialists, 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 on June 9 - 12, 2024 at InterSystems Global Summit 2024, but only for Summit registrants (visit this page to learn more about Certification at GS24). Beta testing will open for all other interested beta testers on June 24, 2024. However, interested beta testers should sign up now by emailing certification@intersystems.com (please let us know if you will be beta testing at Global Summit or in our online proctored environment). The beta testing must be completed by August 2, 2024.

What are my responsibilities as a beta tester?

You will be assigned the exam and will need to take it by August 2, 2024. The exam will be administered in an online proctored environment (live-proctored during Summit), free of charge (the standard fee of $150 per exam is waived for all beta testers), and then the InterSystems Certification team will 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 after 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.

Exam Details

Exam title: InterSystems IRIS SQL Specialist

Candidate description: An IT professional who uses InterSystems IRIS SQL to:

  • design InterSystems IRIS SQL applications,
  • manage InterSystems IRIS SQL operations,
  • and load and efficiently query datasets in InterSystems IRIS SQL.

Number of questions: 47

Time allotted to take exam: 2 hours

Recommended preparation: Review the content found in the table below before taking the exam

Designing InterSystems IRIS SQL Applications

Using InterSystems IRIS SQL

Managing InterSystems IRIS SQL Operations

 

 

Recommended practical experience:

  • Basic experience with standard ANSI SQL
  • 1 to 2 years of experience with designing and managing InterSystems IRIS SQL applications or expertise in other SQL platforms and has 1 year experience with managing InterSystems IRIS SQL applications.

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 (note that laptops will be provided and configured to meet these requirements at Global Summit)

  • 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 InterSystems IRIS SQL applications

 

1. Designs a SQL schema
  1. Identifies role of bitmap extent index
  2. Determines use cases for indexes
  3. Distinguishes use cases for different index types​
  4. Distinguishes primary, unique, and ID keys
  5. Identifies properties for foreign key relationships
  6. Identifies behavior of referential actions for update and delete
  7. Identifies tradeoffs for adding ever more indexes
  8. Identifies use cases for composite indexes

 

2. Designs advanced schemas
  1. Distinguishes the differences between date/time data types

 

3. Loads data
  1. Uses LOAD DATA command
  2. Uses SQL diagnostics tables (%SQL_Diag)
  3. Identifies options for exporting data (physical vs logical)
 

4. Writes business logic
  1. Defines stored procedures
  2. Defines triggers
  3. Identifies language options for writing business logic
 

5. Develops object/relational applications
  1. Recalls default object/relational mapping
  2. Recalls SQL best practices when defining classes
 

6. Deploys SQL applications
  1. Lists mechanisms for deploying SQL applications
  2. Determines what needs to be part of a deployment

2. Uses InterSystems IRIS SQL

1. Manages InterSystems IRIS query processing
  1. List considerations made by the optimizer
  2. Differentiates syntax and runtime errors
  3. Uses Statement Index to find statement metadata
  4. Distinguishes between the use of parameters and constants in a query

 

2. Interprets query plans
  1. Identifies ways to view query plans for a statement
  2. Identifies Full Table Scans in a query plan
  3. Identifies the use of indexes in a query plan
  4. Distinguishes between loops and lookups in a query plan
  5. Distinguishes modules called once vs repeatedly in a query plan
  6. Recalls role of table statistics in query planning
  7. Uses hints to troubleshoot query planning
  8. Identifies opportunities for indexes, based on a query plan
  9. Recalls the meaning of relative cost

 

3. Uses InterSystems IRIS SQL in applications
  1. Defines InterSystems IRIS connections
  2. Identifies prepare/execute steps
  3. Recalls how proper use of parameters can guard against SQL injection
  4. Leverages explicit transaction controls effectively

 

4. Uses InterSystems IRIS-specific SQL capabilities
  1. Uses SelectMode appropriately
  2. Uses arrow syntax for implicit joining

 

5. Uses transactions effectively
  1. Determines appropriate transaction boundaries
  2. Uses CommitMode appropriately
  3. Recalls impact of large or long-running transactions

3. Manages InterSystems IRIS SQL operations

1. Manages SQL operations
  1. Uses SQL Process view to monitor SQL activity (2022.2+)
  2. Gathers table statistics
  3. Uses the runtime stats in the Statement Index to find statements with optimization opportunities

 

2. Manages SQL Security
  1. Assigns SQL privileges to users and roles
  2. Differentiates SQL privilege checking and application security
  3. Identifies impact of enabling SQL auditing
 

3. Uses PTools for advanced performance analysis
  1. Distinguishes between performance metrics "time spent", "global references" and "commands executed"

Interested in participating? Email certification@intersystems.com now!

5 comentarios
Comentarios (5)6
Inicie sesión o regístrese para continuar
Anuncio
· 22 abr, 2024

The Global Masters Program will be temporarily PAUSED from April 26th

#Global Masters

Access for Global Masters:

Please access Global Masters via ➡ this link.

Log in using InterSystems SSO ("Login with InterSystems" button on the left). 

At InterSystems, we strive to give you the best quality in everything. Including the realization of our Global Masters program. 

The vendor of this platform has been acquired by another company, and unfortunately, we will no longer be able to continue hosting our esteemed Global Masters program on this platform. We are currently evaluating new platform providers to facilitate the transition of the Global Masters Advocate Hub.

Beginning April 26th, we will temporarily suspend access to the Global Masters program as we transition to a new platform.

FAQ:

YOUR POINTS, BADGES AND LEVEL

All points, badges and achievements will be saved as of April 26th. We will transfer all data to a new platform.

YOUR CONTRIBUTIONS TO DEVELOPER ECOSYSTEM 

During the migration, we will still be counting all contributions to Developer Ecosystems (posts, comments, applications, etc) automatically. These well-deserved points and badges will be added to your profile upon the launch of a new program.

PRIZES

To provide an opportunity to redeem prizes during the migration, we plan to build a special webpage with prizes as soon as possible. However, we encourage you to redeem prizes you had planned to redeem before April 26th (on April 26th prizes will be already unpublished), as this functionality will not be available for some time.

WHAT'S NEXT

All information regarding the upgrade will be published in the Discord and Developer Community channels. We apologize for any inconvenience and will endeavor to complete the migration as soon as possible. 

WHERE TO ASK QUESTION? GLOBAL MASTERS SUPPORT 

Reach out to Olga @Olga Zavrazhnova in DM here or ask questions in a dedicated Global Masters channel on Discord. Let's stay in touch!

WE WILL UPDATE YOU ON THE ESTIMATE DATE OF LAUNCH SOON

We are looking forward to meeting you soon on a new platform!
Sincerely yours, 
Global Masters and Developer Community team

4 comentarios
Comentarios (4)4
Inicie sesión o regístrese para continuar
Anuncio
· 22 abr, 2024

InterSystems 编程大赛：Vector Search, GenAI 与 ML

#Artificial Intelligence (AI) #Machine Learning (ML) #Eventos #Concurso #InterSystems IRIS #IRIS contest

Hi 开发者们，

我们非常高兴地邀请大家参加新的 InterSystems 在线编程竞赛，此次编程大赛关注生成式AI（GenAI）, 向量搜索（Vector Search ）与机器学习（Machine Learning）！

🏆 InterSystems 编程大赛：Vector Search, GenAI 与 ML 🏆

时间：2024年4月22日 - 5月19日 （美国东部时间）

奖金池： $14,000


主题

使用InterSystems IRIS或InterSystems IRIS for Health或IRIS Cloud SQL开发任意使用生成式AI和/或机器学习的解决方案。

为了让此次竞赛变得更有趣，通过向量搜索（Vector Search）开发的最具创新性的项目作者将被邀请参加InterSystems 2024 全球峰会*(最多3人)！

*受邀开发者将获得全球峰会的免费门票和免费酒店住宿。

一般要求

  1. 应用程序或库必须功能齐全。该应用程序不应该是另一种语言中已有库的导入或直接接口（C++ 除外，您确实需要做大量工作来为 IRIS 创建接口）。不允许对现有应用程序或库进行复制粘贴。
  2. 有效应用程序：100%全新的Open Exchange  Apps或已有的应用程序（但有显著提升）。所有参赛者/团队提交的应用程序只有经过我们团队的审核之后才会被批准参赛。
  3. 该应用程序应在 IRIS Community Edition 或 IRIS for Health Community Edition 上运行。两者都可作为host (Mac, Windows)版从Evaluation Site下载，或者可以按从InterSystems Container Registry或Community Container中提取的容器形式使用： intersystemsdc/iris-community:latest 或 intersystemsdc/irishealth-community:latest 。
  4. 该应用程序需开源并在GitHub上发布。
  5. 应用程序的README文件应为英文，包含安装步骤，并包含视频demo或/和应用程序如何运行的描述。
  6. 一名开发者只允许提交 3 份作品。

注意：我们的专家将根据申请的复杂性和实用性标准对是否批准参加比赛拥有最终决定权。他们的决定是最终决定，不得上诉。

奖品

1. 专家提名奖（Experts Nomination）——获奖者由我们特别挑选的专家团选出：

🥇 第一名 - $5,000 

🥈 第二名 - $3,000 

🥉 第三名 - $1,500

🏅 第四名 - $750

🏅 第五名 - $500

🌟 第六名-第十名 - $100

2. 社区提名奖（Community Nomination）- 获得总票数最多的应用程序：

🥇 第一名 - $1,000 

🥈 第二名 - $750 

🥉 第三名 - $500

🏅 第四名 - $300

🏅 第五名 - $200

如果几位参与者获得相同数量的选票，他们都将被视为获胜者，奖金由获胜者分享。 

谁可以参加？

任何开发者社区的成员均可参加，InterSystems内部员工除外（InterSystems contractor员工可以参加）。

✅  还没有账号？点击此处创建一个账号!            

👥开发人员可以组队创建协作应用程序。一个团队允许 2 到 5 名开发人员。

请注意，要在您的README文件中标注您的团队成员——社区用户profile。

重要截止日期：

🛠 应用程序开发和注册阶段：

  • 2024年4月22日 （美国东部时间 00:00）：比赛开始。
  • 2024年5月12日（美国东部时间 23:59）：提交截止日期。

✅投票期限：

  • 2024年5月13日（美国东部时间 00:00）：投票开始。
  • 2024年5月19日（美国东部时间 23:59）：投票结束。

注意：在整个参赛期间（开发与投票期间），开发者可持续编辑、提升其应用。

    资源助力：

    ✓ 文档

    ✓ 应用示例与资料：

    ✓ 在线课程：

    ✓ 视频：

    ✓ IRIS初学者：

    ✓ ObjectScript Package Manager (IPM) 初学者：

    ✓ 如何将您的APP提交给大赛：

    需要帮忙？

    加入 InterSystems Discord 服务器上的竞赛频道或在本文评论中留言告诉我们。

    期待您的精彩项目——加入我们的编码马拉松吧！

    ❗️参加本次比赛即表示您同意此处列出的比赛条款。请在继续之前仔细阅读它们。 ❗️

    Comentarios (0)1
    Inicie sesión o regístrese para continuar
    Artículo
    · 21 abr, 2024 Lectura de 1 min

    Dynamic <call> target in BPL

    #Proceso empresarial #InterSystems IRIS #InterSystems IRIS for Health #Health Connect

    Hi all,

    When making a Business Process reusable, I needed to make the target of a <call> configurable as a business host setting. This can be done through indirection. Here's how:

    Property TargetConfigName As Ens.DataType.ConfigName;

    Parameter SETTINGS = "TargetConfigName:Basic";

    /// BPL Definition
    XData BPL [ XMLNamespace = "http://www.intersystems.com/bpl" ]
    {
    <process language='objectscript' request='Ens.Request' response='Ens.Response' height='2000' width='2000' >
    <sequence xend='200' yend='450' >
    <call name='Call configurable target' target='@process.TargetConfigName' async='1' xpos='200' ypos='250' >
    <request type='Ens.Request' >
    <assign property="callrequest" value="request" action="set" />
    </request>
    <response type='Ens.Response' >
    <assign property="response" value="callresponse" action="set" />
    </response>
    </call>
    <sync name='Wait' calls='Call configurable target' type='all' xpos='200' ypos='350' />
    </sequence>
    </process>
    }
    5 comentarios
    Comentarios (5)3
    Inicie sesión o regístrese para continuar
    Pregunta
    · 20 abr, 2024

    There's any way to edit a SOAP header?

    #API REST #SOAP #XML #Caché #Ensemble #Health Connect #InterSystems IRIS

    Hello everyone, I need some help. 

    I have to send some events for a government WebService that I already imported the WSDL and XSD's and It worked fine and I'm able to build the message and connect into the service, but It has been rejected with the message that the XML is wrong and the only diference between the Caché SOAP message to all the examples that the government gave us is the header:

       

    This is how the Government is expecting the message:

    <?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:xsd="http://www.w3.org/2001/XMLSchema"
	xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
	<soap12:Body>
		<cteDadosMsg
			xmlns="http://www.portalfiscal.inf.br/cte/wsdl/CTeStatusServicoV4">
			-----------------Dynamic XML Body------------------
		</cteDadosMsg>
	</soap12:Body>
</soap12:Envelope>

     

    And this is how It's generate in Cache:

      <  ?xml version="1.0" encoding="UTF-8" ?>
    <SOAP-ENV:Envelope
               xmlns:SOAP-ENV='http://www.w3.org/2003/05/soap-envelope'
                xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
              xmlns:s='http://www.w3.org/2001/XMLSchema'>
              <SOAP-ENV:Body>
                         <cteDadosMsg
                                  xmlns="http://www.portalfiscal.inf.br/cte/wsdl/CTeRecepcaoEventoV4">
                                  -----------------Dynamic XML Body------------------ 
                         </cteDadosMsg>
             </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>  

     

     

    So, there's any way to edit It before invoke the webMethod or any configuration that made it during the process?

    Thank you so much!!

    10 comentarios
    Comentarios (10)2
    Inicie sesión o regístrese para continuar