Test SQL - Fundamentals

Our SQL technical test is designed to evaluate the skills of developers in SQL. This test consists of a series of multiple-choice questions that cover various topics in SQL, including basic querying, aggregation, and table manipulation.

The test contains a total of 12 questions, each containing an example of a SQL query and a set of four possible answers. The questions are of varying difficulty, with some requiring only basic SQL knowledge, while others require a more advanced understanding of the language.

Through this test, we aim to assess the developer's ability to work with relational databases and SQL, which is a critical skill for any software developer. The test also helps developers to identify their strengths and weaknesses in SQL and work on improving their skills accordingly.

The 5 main competencies tested in this SQL technical test include:

• Basic SQL querying: the ability to write basic SQL queries to retrieve data from a table
• Aggregation: the ability to use SQL aggregate functions such as COUNT, SUM, AVG, and MAX to perform calculations on a table
• Table manipulation: the ability to manipulate tables by adding, updating, and deleting data
• Joins: the ability to join two or more tables using different join types, such as INNER JOIN and OUTER JOIN
• Subqueries: the ability to use subqueries to retrieve data from a table based on a condition.

By testing these competencies, we hope to provide developers with a comprehensive assessment of their SQL skills and help them to identify areas where they need to improve.