HackerRank SQL offers a structured learning path and coding challenges to practice SQL skills, ranging from Basic to Advanced levels. The platform includes domains like Basic Select, Aggregation, Joins, Subqueries, Window Functions, and Performance Tuning, helping users build proficiency for real-world data analysis and job interviews.

  • Key Features:

    • 15 Days of Learning SQL: A beginner-friendly challenge series that introduces core concepts through daily problems.

    • Skill Certification: Offers a SQL (Basic) Skills Certification Test to validate foundational knowledge.

    • Problem Types: Covers simple queries (e.g., SELECT, WHERE, ORDER BY) to complex tasks like recursive CTEs, correlated subqueries, and advanced joins.

  • Popular Challenges:

    • Weather Observation Station series: Focuses on filtering, aggregation, and string functions.

    • Top Earners: Requires calculating salary * months, grouping, and identifying maximum earnings.

    • 15 Days of Learning SQL: Involves daily submissions analysis using window functions and conditional logic.

  • Community & Resources:

    • GitHub Repositories (e.g., Thomas-George-T/HackerRank-SQL-Challenges-Solutions) provide verified solutions using MySQL.

    • YouTube Tutorials (e.g., "ALL Hackerrank SQL Solutions in ONE Video!") walk through problems step-by-step.

    • Reddit Discussions highlight pros (structured practice) and cons (some problems feel like brain teasers, not real-world scenarios).

  • Tips for Success:

    • Start with basic syntax (W3Schools, official docs like MySQL) before jumping into HackerRank.

    • Use official documentation for advanced functions instead of relying solely on memorization.

    • Practice with real output formatting—HackerRank’s output can be hard to interpret due to code-like display.

Recommendation: Use HackerRank for structured practice, but supplement with StrataScratch or DataLemur for interview-style, business-relevant problems.

Yeah it's fine. HackerRank and LeetCode both have vastly improved their SQL content recently. But it's still mostly rote syntax that you'll learn. What you really want to do is test job interview questions (Stratascratch and Datalemur, the owner of the latter hangs out in this sub). Unlike usual software interview questions, the ones that pertain to SQL are actually taken straight from real business use cases. These are actual problems that real companies are facing so they just confront any applicant directly with it. And that's when you need more than syntax. You need to be able to unpack a problem and solve it in separate parts to finally put it all back together again. That's where the real growth is. Answer from Thefriendlyfaceplant on reddit.com
🌐
HackerRank
hackerrank.com › domains › sql
Solve SQL Code Challenges
SQL · Solve Challenge · Solve Challenge · Solve Challenge · Solve Challenge · Solve Challenge · Solve Challenge · Solve Challenge · Solve Challenge · Solve Challenge · Solve Challenge · Status · Solved · Unsolved · Skills · SQL (Basic) SQL (Intermediate) SQL (Advanced) Difficulty ·
🌐
HackerRank
hackerrank.com › skills-verification › sql_basic
SQL (Basic) Skills Certification Test
The HackerRank Skills Certification Test is a standardized assessment to help developers prove their coding skills.
🌐
Reddit
reddit.com › r/sql › is hackerrank good for practicing sql?
r/SQL on Reddit: Is HackerRank good for practicing SQL?
April 19, 2023 -

Are there any other sites or resources you would recommend? I know the basics but I want to work on getting more fluent. I often have to look things up while I’m at work, and I want to get to the point where I can write most of my scripts without having to check the syntax of half my commands! Thank you!

I gave this a MySQL flair but I’m not tied to it.

🌐
HackerRank
hackerrank.com › skills-directory › sql_basic
SQL (Basic) | Skills Directory | HackerRank
Activities involved: Setting up a database environment and understanding SQL’s purpose and use cases.
🌐
HackerRank
hackerrank.com › challenges › weather-observation-station-5 › forum
Weather Observation Station 5 Discussions | SQL | HackerRank
4 days ago - Write a query to print the shortest and longest length city name along with the length of the city names.
🌐
Reddit
reddit.com › r/sql › sql screening test on hackerrank
r/SQL on Reddit: SQL Screening test on HackerRank
February 7, 2024 -

I have been asked to undergo SQL Screening test at HackerRank by a company where I had applied as a Data Analyst. The test is for 60 mins and I can't pause after starting so I have to finish in one go.

If any one has used HackerRank can you please advise me what to expect from this test?

Am I allowed to choose which database I wanty to use i.e Oracle, PostgreSQL etc?

I would say I am proficient enough in SQL that I can understand the problem and formulate the queries and I only need to Google for looking up syntax for advanced functions if working on different database.

Any pointers will be really helpful

Find elsewhere
🌐
Medium
medium.com › data-science › 9-tips-that-helped-me-clear-all-hackerrank-sql-challenges-in-2-weeks-479eb0084862
9 Tips That Helped Me Clear All HackerRank SQL Challenges in 2 Weeks | by Michael Li | TDS Archive | Medium
November 7, 2021 - It took me a bit more than two weeks (on and off between work, workout, and taking the kid to day school, etc.) to finish all the 58 SQL challenges on the site, and I gained quite some insights from the journey (and having quite some fun doing that!). This article could be read by anyone who wants to get into the data science world or prepare for your next SQL interview using a coding site like HackerRank or LeetCode, Even if you still don’t have any prior SQL knowledge.
🌐
GitHub
github.com › Thomas-George-T › HackerRank-SQL-Challenges-Solutions
GitHub - Thomas-George-T/HackerRank-SQL-Challenges-Solutions: The solutions of all SQL hackerrank challenges using MySQL environment · GitHub
The solutions of all the SQL challenges for all easy, medium and hard challenges on HackerRank executed on MySQL environment compiled with helpful Resources & references related to the challenges.
🌐
GitHub
github.com › MahedeiHasan › Hackerrank-SQL-Intemediate-Skills-Certification-Test-Solutions
GitHub - MahedeiHasan/Hackerrank-SQL-Intemediate-Skills-Certification-Test-Solutions: Solved queries for the Hackerrank SQL (Intermediate) Skills Certification Test 🎓.
Solved queries for the Hackerrank SQL (Intermediate) Skills Certification Test 🎓. - MahedeiHasan/Hackerrank-SQL-Intemediate-Skills-Certification-Test-Solutions
Starred by 6 users
Forked by 7 users
🌐
Medium
katherineamunro.medium.com › medians-with-sql-how-to-solve-these-hackerrank-problems-like-you-actually-know-what-youre-doing-ea262daaca25
Medians with SQL: How to solve these HackerRank problems like you actually know what you’re doing | by Katherine Munro | Medium
May 10, 2023 - I first asked StackOverflow how to query the median with SQL, but the answers were about as succinct — and as decipherable — as a badly translated fortune cookie. So I started with this simple query: SELECT LAT_N, COUNT(LAT_N) OVER () AS Cnt, ROW_NUMBER() OVER (ORDER BY LAT_N) AS RowNum FROM STATION · If you run this in the HackerRank terminal, you’ll see it outputs three columns:
🌐
HackerRank
hackerrank.com › skills-verification
HackerRank
Join over 28 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews.
🌐
HackerRank
hackerrank.com › skills-directory › sql_advanced
SQL (Advanced) | Skills Directory | HackerRank
Reason: Prepared statements are needed to efficiently handle dynamic queries and evaluate strings while ensuring data is accurately parameterized, reducing the risk of SQL injection.
🌐
Medium
hangmortimer.medium.com › hackerrank-sql-in-3-days-f3c360dc9fcc
[DATABASE] HackerRank SQL in 3 days | by Hang Nguyen | Medium
May 12, 2022 - [DATABASE] HackerRank SQL in 3 days Hi folks! My pleasure for your visit to this post! Long story short, the story is that I have finished the SQL track in HackerRank within 3 days. And here are some …
🌐
HackerRank
hackerrank.com › challenges › earnings-of-employees › forum
Top Earners Discussions | SQL | HackerRank
SQL · Aggregation · Top Earners · Discussions · Problem · Submissions · Leaderboard · Discussions · recency · Please Login in order to post a comment · hemanth6_u 1 day ago+ 0 comments · SELECT (months*salary)as total_sal,count(*)as cnt from employee group by 1 order by 1 desc limit 1 ·
🌐
GitHub
github.com › topics › hackerrank-sql-solutions
hackerrank-sql-solutions · GitHub Topics · GitHub
Contains solved queries for the Hackerrank SQL (Basic) Skills Certification Test 🎓.
🌐
Medium
ntrang.com › solving-sql-problems-on-hackerrank-the-good-the-bad-and-the-ugly-307cf9399205
Solving SQL problems on HackerRank— The Good, the Bad, and the Ugly. | by Trang Nguyen | Medium
January 2, 2024 - I solved over 150 SQL problems on Leetcode and HackerRank, not including SQL puzzle books. There are 58 free SQL questions on HackerRank and 100 on Leetcode, including 50 free of charge and 50 problems for premium accounts.
🌐
Medium
medium.com › @datasciencewithnish › top-sql-interview-question-hackerrank-top-competitors-2fc42287dcce
Top SQL Interview Question — HackerRank | TOP COMPETITORS | by Nishtha Nagar | Medium
June 14, 2024 - Top SQL Interview Question — HackerRank | TOP COMPETITORS Julia just finished conducting a coding contest, and she needs your help assembling the leaderboard! Write a query to print the respective …