Introducing DbRank: Assessing SQL made easy

We’re very excited to announce the launch of DbRank, our latest automated platform for assessing SQL skills. It simplifies your hiring for a variety of database-related roles like Data Analysts, Business Analysts, Data Scientists, Application Developers and many more. The platform supports four of the most commonly used databases: Oracle, MS SQL server, DB2 and MySQL.

 

How DbRank works?

DbRank is a new question type in HackerRank for Work, such that when you create a new question you’ll select “DbRank” as your question type.

Screen Shot 2015-05-08 at 9.22.15 pm

Step 1:

Write the problem description (just like you would for any other new question)

Step 2

Select a set of databases that the candidates will be allowed to leverage to write their queries. Next, create a set of tables which will be available to the candidates in their test database. This involves writing the SQL queries for table definitions and inserting data in these tables as needed.¬†There’s also an option to generate the SQL automatically by uploading a CSV file.

Screen Shot 2015-05-08 at 9.22.26 pm

Step 3

Define the expected output which will be used to automatically grade the question by matching it against the output from candidates’ queries.

 

How will candidates solve DbRank questions?

Candidates will solve DbRank questions in the same way that they solve any other Coding question.¬†They’ll choose the database they want to use from the available options and then write their SQL queries in our online editor (which also supports syntax highlighting). The queries are written on the tables which were created as a part of the question. They’ll run their queries to see if their output matches the expected output.

Screen Shot 2015-05-08 at 9.22.41 pm

 

DbRank now makes it very easy for you to assess database skills in an automated way without waiting for an in-person interview. We would love for you to try this new offering by HackerRank and share your comments and feedback with us.

Leave a Reply

Your email address will not be published. Required fields are marked *