Subqueries, EXISTS, IN Operators
Miscellaneous: Foreign Key, UNION Operator, NULLs
Grouping, Aggregate Functions, HAVING Clause
Kandio’s assessment tests let you assess the candidates, employees, agencies or freelancers you have concerning any MySQL task you might have.
Remember that Kandio offers guidelines on which programmers to proceed with, and which ones to discard. Kandio will give you reliable directions about things programmers should know about, but a programmer can be excellent, even if he does not know about all of these things.
We suggest that you use our tests before your interview process to know which ones actually to talk to. The final Kandio report should be a piece of conversation with the strong candidates, rather than a disqualifying process in a late stage interview process.
This assessment test will suggest the quality of any MySQL developer, and let you know his proficiency in several vital areas of MySQL like Joins, Queries, Grouping, Aggregate Functions, HAVING Clause among others. See the full list of assessment chapters to the right.
To excel in this test, the developer would need to have significant experience with development, setup, and installation on the MySQL platform.
It will require proficiency in both SQL, MySQL and databases in general.
All of which will result in an accurate picture of a specific developer assessment.