Hire the hottest SQL talent with DbRank from HackerRank [Tutorial]

Key Takeaways

Hello hackers, welcome to Hackerank. Today I will be showing you how to create a DB rank question on the Hackerank platform. DBrank will be a great way to help you evaluate candidates for roles like data scientists, DB admins, and more. We can start by logging with our credentials. Go to the test that needs a DB rank question and click new question. We will select DB rank for this video. We begin creating our question by giving it a name and a score. We can also add tags for organization. In the problem statement, we want to be clear to the candidate what we are looking for in this problem. First, a description of what we are looking for. Then a simple example of schema. Once that's done, let's save and proceed to the next step. In the second step, we create the schema or tables. do this by uploading a CSV file with the necessary format and data. Here's a look at the CSV files I will be using. Give the table a name and we've got our first table. Repeat for any additional tables necessary. Make any last minute changes. Save and proceed. In the last step, we enter the expected output from the candidates's query. Once we've entered our expected output and select any additional settings, we are able to prepare any stubs for the candidate. For this challenge, we'll choose not to provide any. That's it. This question is ready to go, but let's test it just to make sure. Let's enter the correct SQL query and run our solution. Great. Looks like this challenge is ready to go. Thanks for watching and happy coding.