Test SQL - Fundamentals
Test SQL with answers to assess your knowledge and prepare for job interviews. Assess your technical level in 20 minutes.
Test details
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.
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!
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?
Developers ratings
Recommended tests
- Our interview questions for Développeur Back-end