Test SQL - Fundamentals

Test SQL with answers to assess your knowledge and prepare for job interviews. Assess your technical level in 20 minutes.

Validate and promote your skills
Private results unless you share them
Compare your results to the developers average

Test details

Beginner
November 2023
12 minutes
🇫🇷
🇺🇸
3.8/5(21)

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.

This test consists of 20 questions randomly selected from a database of 24 questions in SQL.Discover all our interview questions and answers here
1.
developer avatar
Louis
2995 points
2.
developer avatar
Emmanuel
2907 points
3.
developer avatar
Lucille
2823 points
4.
developer avatar
Vincent
2775 points
5.
developer avatar
Bruno
2761 points

Test author : Vincent Cotro

This test was designed by the WeLoveDevs.com tech team.
We have gathered our knowledge and experience in the professional world to bring it to you.
In a nutshell, our team is made up of junior and experienced engineers and developers!

Contributors7
developer avatar
developer avatar
developer avatar
developer avatar
developer avatar
developer avatar
developer avatar

Sample question

Given the following 'employees' table:

| id | first_name | last_name | salary |
|----|------------|-----------|--------|
| 1  | John       | Doe       | 5000   |
| 2  | Jane       | Smith     | 5500   |
| 3  | Alice      | Johnson   | 5200   |

Which SQL query retrieves the list of employees with a salary greater than 5100?

See 24 test questions.Participate in test improvement

Developers ratings

developer avatar
26/02/2024🇫🇷
developer avatar
Anthony
23/02/2024🇫🇷
developer avatar
MANUELLA
15/02/2024🇫🇷
developer avatar
13/02/2024🇫🇷
Excellent quiz je recommande de le faite
developer avatar
12/02/2024🇫🇷