SQL (coding): complex queries
This SQL coding test requires candidates to create a query on a complex database structure. It immerses the candidate in a realistic scenario. Solving it requires deep SQL querying skills.
- Advanced level querying in SQL
This test is relevant for
Companies looking for a developer with deep knowledge of SQL and an ability to manage complex queries. These would generally be senior backend developers.
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 working with complex data structures.
In this 30-minute test, the candidate is presented with a real-life scenario and a complex database structure. The objective is to create a query that acts as a report with key insights from the database.
The candidate needs to have deep knowledge about joining and filtering results. In addition, the candidate needs to be able to manipulate the data using simple calculations, and take many details into consideration, for example sorting the data, rounding numbers, excluding irrelevant entries, and filling gaps in the data.
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.