SQL (coding): entry-level database operations
This SQL coding test requires candidates to manipulate a database with low complexity and/or create a query that satisfies the given requirements. It immerses the candidate in a realistic scenario. Solving it requires entry-level SQL skills.
- Entry-level SQL database operations
This test is relevant for
Companies looking for a developer with practical knowledge of SQL and low complexity databases and queries. Junior 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 10-minute test, the candidate is presented with a real-life scenario and a database of low complexity. The objective is to manipulate the database and creating a query in such a way that the given requirements are satisfied
The candidate needs to be able to manipulate the data using simple calculations, and take certain details into consideration, for example sorting the data and excluding certain entries. The test evaluates the result using a set of test cases that checks standard and corner cases of the solution.