Nova postagem

Pesquisar

Anúncio
· Abr. 22, 2024

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

#Certificação #Global Summit 2024 #Indexando #Tabelas Relacionais #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 Comments
Discussão (5)6
Entre ou crie uma conta para continuar
Resumo
· Abr. 22, 2024

Publicações Desenvolvedores InterSystems, Abril 15 - 21, 2024, Resumo

#Developer Community Oficial #Resumo
Abril 15 - 21, 2024Week at a GlanceInterSystems Developer Community
Resumo
· Abr. 22, 2024

InterSystems Developers Publications, Week April 15 - 21, 2024, Digest

#Developer Community Oficial #Resumo
Articles
Announcements
Questions
#InterSystems IRIS
compilation error iris terminal class not found
By Alexandra Mirzac
Extract XML from text
By Michael Lundberg
Modifying Visual Studio Code code assist results
By Maarten Van den Vreken
module 'iris' has no attribute 'arrayref' while converting a python dictionary into an array
By Pietro Di Leo
Iterate on array in a json structure
By maxime keltsma
Direct access to a global without SQL
By maxime keltsma
Pentaho Data Integration with IRIS ?
By Sylvain Guilbaud
Does Embedded SQL support Table Hints?
By Julian Matthews
Need to decompress string compressed with zlib. Can I manually add the "customized wrapper" intersystems requires for $System.Util.Decompress()
By Daniel Raderstrong
Question about IAM
By Scott Roth
initial user account
By Philip Briere
WRC direct access
By Philip Briere
OpenAPI property mismatch in Spec First approach IRIS documentation
By Ashok Kumar
There's any way to edit a SOAP header?
By Igor Barboza
#Ensemble
#HealthShare
#Caché
#InterSystems IRIS for Health
Discussions
April 15 - 21, 2024Week at a GlanceInterSystems Developer Community
Anúncio
· Abr. 22, 2024

Le programme Global Masters sera temporairement EN PAUSE à partir du 26 avril 2024

#Global Masters

Chez InterSystems, nous nous efforçons de vous offrir la meilleure qualité en tout. Y compris la réalisation de notre programme Global Masters.

Le fournisseur de cette plateforme a été racheté par une autre société et malheureusement, nous ne pourrons plus continuer à héberger notre estimé programme Global Masters sur cette plateforme. Nous évaluons actuellement de nouveaux fournisseurs de plateformes pour faciliter la transition du Global Masters Advocate Hub.

À partir du 26 avril, nous suspendrons temporairement l'accès au programme Global Masters lors de la transition vers une nouvelle plateforme.

FAQ:

VOS POINTS, BADGES ET NIVEAU

Tous les points, badges et réalisations seront sauvegardés à partir du 26 avril. Nous transférerons toutes les données vers une nouvelle plateforme.

VOS CONTRIBUTIONS À L'ÉCOSYSTÈME DE DÉVELOPPEUR

Pendant la migration, nous compterons toujours automatiquement toutes les contributions aux écosystèmes de développeurs (posts, commentaires, applications, etc.). Ces points et badges bien mérités seront ajoutés à votre profil lors du lancement d'un nouveau programme.

PRIX

Pour offrir la possibilité d'échanger des prix pendant la migration, nous prévoyons de créer une page Web spéciale avec des prix dès que possible. Cependant, nous vous encourageons à récupérer les prix que vous aviez prévu d'utiliser avant le 26 avril (le 26 avril, les prix cesseront déjà d'être publiés), car cette fonctionnalité ne sera pas disponible avant un certain temps.

ET APRÈS

Toutes les informations concernant la mise à niveau seront publiées sur Discord et sur Developer Community. Nous nous excusons pour tout inconvénient et nous nous efforcerons de terminer la migration dès que possible.

OÙ POSER DES QUESTIONS ? SUPPORT GLOBAL MASTERS 

 

Contactez Olga @Olga Zavrazhnova sur Developer Community ou posez vos questions sur une chaîne dédiée Global Masters sur Discord. Restons en contact!

NOUS VOUS METTRONS À JOUR SUR LA DATE ESTIMÉE DE LANCEMENT BIENTÔT

Au plaisir de vous retrouver bientôt sur une nouvelle plateforme !
Cordialement,
Équipe des Global Masters et de la Communauté des Développeurs
 

Discussão (0)1
Entre ou crie uma conta para continuar
Anúncio
· Abr. 22, 2024

Recordatorio webinar en español: "SMART on FHIR, extendiendo las capacidades de HealthShare"

#FHIR #Webinar #HealthShare

¡Hola comunidad! 

Aunque seguro que ya lo tenéis en vuestro calendario, os recordamos que este jueves 25 de abril, a las 4:00 PM (CEST) tendremos un muy interesante webinar: "SMART on FHIR, extendiendo las capacidades de HealthShare".

 

Sin duda, una oportunidad muy buena para adquirir nuevas competencias y seguir aprendiendo.

Sois muchos los desarrolladores, administradores de HealthShare y personal sanitario que ya os habéis registrado. Para los que aún no: 

➡️ Registro >>

¡Nos vemos el jueves!

Discussão (0)1
Entre ou crie uma conta para continuar