The SQL - Basic (Short) assessment is designed to measure the foundational SQL knowledge and skills of job candidates and employees, focusing on the core concepts and syntax required for entry-level to mid-level programming roles in business environments. The test evaluates six key areas: SELECT Statements and Filtering, JOIN Operations, Aggregate Functions and GROUP BY, INSERT, UPDATE, and DELETE Statements, Table Definition and Constraints, and Subqueries and NULL Handling. It assesses the ability to write and interpret SQL scripts, define and modify database structures, apply constraints, use aggregate functions, handle NULL values, and combine result sets using UNION, INTERSECT, and EXCEPT operations.

The assessment uses a variety of question types, including Multiple Choice, Multiple Correct Answer, and Essay Composition questions, and draws from a large question pool to minimize the risk of cheating. One or more questions are scored using artificial intelligence, and certain questions are subject to individual time limits to further deter cheating and enhance the predictive accuracy of results. Together, these features make the SQL - Basic (Short) test a comprehensive and secure tool for evaluating practical SQL proficiency.

The specific attributes measured include:

Following completion, the test produces a Candidate Selection Report that includes an overall score and detailed scores for each attribute.

The Candidate Selection Report also provides expert interview questions that help you probe critical or low-scoring areas, along with a guide for noting your evaluation of the candidate's responses. Consistent use of an interview guide is an important part of gaining better candidate insights and making better hiring decisions.

Note that while the SQL - Basic (Short) assessment is a useful and efficient instrument for confirming a base level of skill or knowledge about this important topic, it is not intended to pinpoint the exact level of candidate or skill. We recommend that skills tests, like this one, be used in parallel with other measurements, such as cognitive ability, job fit, and behavioral history. Each different type of test provides a valuable piece of information you can use when evaluating potential job performance.