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.
Videos
03:08
Higher Than 75 Marks | SQL Basic Select | HackerRank Solution - ...
38:22
Solving Complex SQL Query from HackerRank | SQL Interview Query ...
07:28:13
ALL Hackerrank SQL Solutions in ONE Video! | Easy Medium Hard ...
12:03
Top Competitor SQL HackerRank Challenge - Solved with Joins and ...
Select All | SQL Basic Select | HackerRank Solution
07:55
HackerRank: How to Solve the “Interviews” Problem Step-by-Step ...
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.
Top answer 1 of 17
63
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.
2 of 17
18
Maybe I'm in the minority, or perhaps it has changed recently, but I thought Hackerrank was horrendous. I can only answer the same question in a row so many times. From what I recall, I would literally get 8 questions in a row that were on the same basic topic, and it would just ask you to change the value in the WHERE clause from age > 20 to age > 30, and so on. It was a waste of time and I quickly lost interest.
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
Top answer 1 of 5
9
You can create a personal account on hackerrank to get familiar with the experience. Also, keep in mind that when you switch a tab you ll get a message saying 'this is recorded and shared with interviewer.'
2 of 5
3
I’d check there are no technical restrictions on using other sources! E.g. them monitoring other pages you have open or screen sharing. If there isn’t then google is your friend and how most people on the real world work esp if you are using multiple types of SQL flavours! Good luck!
HackerRank
hackerrank.com › challenges › 15-days-of-learning-sql › problem
15 Days of Learning SQL | HackerRank
find users who submitted a query every day.
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.
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 › 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
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.
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 › skills-directory › sql_intermediate
SQL (Intermediate) | Skills Directory | HackerRank
These concepts introduce more complex features and functionalities of SQL.
LinkedIn
linkedin.com › posts › parthasarathy-sridharan-33846328_ugh-seriously-this-whole-hackerrank-thing-activity-7320794337695428608-FOAv
The flaws of SQL tests on HackerRank
We cannot provide a description for this page right now
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 …
Udemy
udemy.com › development
SQL HackerRank Challenge: Get Gold star & 670 points
1 month ago - Learn complete MySQL & PostgreSQL. Solve HackerRank problems to get Gold star and 670 points in SQL HackerRank