SQL (coding): intermediate level querying
This SQL coding test requires candidates to create a query on a database with medium complexity. It immerses the candidate in a realistic scenario. Solving it requires intermediate SQL querying skills.
- Intermediate level querying in SQL
This test is relevant for
Companies looking for a developer with practical knowledge of SQL and medium complexity databases and queries. Senior backend developers are expected to score well on this test.
DescriptionWorking with SQL databases is part of the day-to-day work of a backend developer. Even if your framework hides SQL behind an ORM, knowing SQL is highly recommended for backend developers.
In this 30-minute test, the candidate is presented with a real-life scenario and a database of medium complexity. The objective is to create a query that acts as a report with key insights from the database.
The candidate needs to have some experience joining and filtering results. In addition, the candidate needs to be able to manipulate the data using simple calculations, and take certain details into consideration, for example sorting the data, rounding numbers, and excluding irrelevant entries.
The test ranks your candidates using a wide set of test cases to check every corner case of the solution, involving more than 10 different test cases.