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.
Videos
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.
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