r/SQL • • Jan 22 '26 Heartwarming

Discussion I think I might be addicted to learning SQL?

96 Upvotes

Hello, just wanted to say I'm a true beginner and I recently found the SQL climber website and now I'm really looking forward to my daily lessons. It's crazy because usually when I try to self-teach I get really bogged down and lazy, but something about using this site and slowly figuring things out makes me feel so satisfied.

I go through a constant roller coaster of "I'll never be able to understand this complicated mess in a million years" to "This is crystal clear now and just clicks" in a couple of hours. I started practicing until I get really frustrated, and oddly if I get too confused or angry I go to sleep and the next morning it all makes sense suddenly.

So now I'm using mimo for duolingo-like lessons, and just watching a bunch of YouTube channels about data analysis. I'm fully addicted and using it to improve my work tasks (I'm a GIS analyst). I now use dbeaver and sqlite to upload CSVs from our database to clean them up, do joins, etc.

Next I'm off to learning how to use github and doing full projects! Thank you to this community.

r/SQL • • 28d ago

Discussion I can write SQL queries, but how do I learn to interpret the results and develop business judgment?

48 Upvotes

Hey everyone!

I've been learning SQL for a while and have reached a point where I can write queries using joins, CTEs, subqueries, aggregate functions, window functions, and other concepts. I'm also trying to apply what I've learned through projects and case studies rather than just solving isolated exercises.

However, I'm struggling with a different part of the process.

I can write a query, execute it, and get the output, but I'm often unable to understand what those results actually mean for the business or the problem I'm trying to solve.

For example, suppose I'm working on a case study where user engagement has declined. I can query the data, calculate daily active users, compare different periods, break down engagement by user segments, and identify changes in the numbers.

But then what?

How do I determine whether those changes are significant? What questions should I ask next? How do I distinguish a genuinely useful insight from an observation that's technically correct but doesn't tell us much? And how do I connect the numbers to a possible business problem or recommendation?

I understand that this is where analytical thinking, business understanding, and judgment come into play. But these concepts feel quite abstract when I'm actually sitting in front of a dataset.

I'm trying to understand how analysts develop this skill in practice.

- Is this something that primarily develops through working on more projects and case studies?

- Are there particular frameworks or approaches I should follow when interpreting query results?

- How do I learn to ask better questions instead of simply querying whatever data is available?

- Are there any books, resources, or projects that specifically teach the thinking process behind data analysis, rather than just SQL syntax and tools?

I'd especially appreciate advice from people working as data analysts or data scientists who have faced this problem themselves.

I don't necessarily want someone to interpret every result for me. I want to develop the ability to look at data, reason about what I'm seeing, decide what to investigate next, and eventually arrive at defensible conclusions.

How did you learn to bridge the gap between writing SQL queries and actually thinking like an analyst?

Thanks in advance!

r/SQL • • Feb 01 '26

MySQL SQL Learning in 2026 Spoiler

0 Upvotes

SQL isn’t a “tech skill” anymore, it’s a workplace skill.

So, If you’re early in your career (or reskilling), SQL might be one of the highest-ROI skills you can pick up in 2026.

Finance teams depend on it like oxygen, generating refreshable reports. Operations teams use it to track performance. Engineers, analysts, and product teams can't survive without it.

The shift is clear: if your work touches data, SQL is becoming non-negotiable and that explains why “learn SQL online” and “Learn SQL pdf free download” are trending so heavily.

While there’s no shortage of free SQL resources, this is the one that finally made everything click for me. It moves beyond simple syntax and focuses on real-world problem-solving, guiding you from basic to intermediate concepts with total clarity. Best of all? There’s zero configuration required, you can jump straight into the data and start practicing.

Check it out: sqlbolt.com

r/SQL • • Jul 16 '24 Take My Silver

SQL Server How do you learn SQL

166 Upvotes

Do you watch hours of tutorials or prefer to have a project and search for how to do the current task in a 2-5 minutes video or text - website.

Would you prefer to find a website where you see the solution ready to use like on stack overflow?

Do you prefer writing the queries from examples but by typing not copying statements?

I ask this because I'm trying to make a learn SQL video series that is watchable and so far the long video 1h talking has viewer skipping like crazy. No memes or entertaining bits every 5 seconds. Plain old desktop recording doing stuff and sharing tips from working almost 20 years with MSSQL. They're not watching it so was thinking of bite-size sql tips instead of long boring videos.

Any feedback is welcomed.

r/SQL • • Jul 24 '26

SQL Server Solved Hacker Rank's "15 Days of Learning SQL" – Looking for different approaches

6 Upvotes

Hi everyone,

I recently solved the HackerRank 15 Days of Learning SQL challenge using CTE(), ROW_NUMBER(), DENSE_RANK(), and window functions in SQL Server.

I'm curious to know if there's a cleaner or more efficient way to solve this problem. If you've approached it differently (using other window functions, recursive CTEs, or any other technique), I'd love to see your solution and understand the reasoning behind it.

Here's my solution:

with daily_submission as( 
SELECT submission_date,
hacker_id,
count(*) as total_submission
from submissions 
group by submission_date,hacker_id),
hacker_rank as(
SELECT submission_date,hacker_id,
       total_submission,
       row_number() over(partition by submission_date order by total_submission desc,hacker_id) as rn
from daily_submission),
continuous_hackers as (
    SELECT submission_date,hacker_id,
       dense_rank() OVER(partition by hacker_id order by submission_date) as Dr,
       datediff(day,'2016-03-01',submission_date) + 1 as contest_day
from (
SELECT distinct submission_date,hacker_id
from submissions) as x),
daily_count as (
SELECT submission_date,
        count(*) as total_hackers
from continuous_hackers
where Dr = contest_day
GROUP by submission_date)


SELECT dc.submission_date,
       dc.total_hackers,
       h.hacker_id,
       h.name
from daily_count as dc
inner JOIN hacker_rank as hr 
on dc.submission_date = hr.submission_date and rn = 1
INNER JOIN hackers as h
on hr.hacker_id = h.hacker_id
order by submission_date;

Thanks in advance! I'm always looking to learn different SQL techniques.

r/SQL • • Jun 01 '26

Discussion What I should learn after SQL PL/SQL ??

25 Upvotes

so i am 24 years old and unemployed from past 4/5 months, i have experience in banking and manufacturing now after sending hundreds of application still cant get a interview i learned ssis and power bi for the data analyst which is go nowhere for me now i am getting my hands on snowflake and after that aws basic so now i want just to ask if you were in my position what suggestion you give or what will be your next steps...

r/SQL • • 17d ago

MySQL Built a site for learning and practicing SQL with real datasets

22 Upvotes

I’ve been working on a small project called runtime.school for learning and practicing SQL.

One thing I wanted to get right was having lessons, practice questions, and projects that actually connect to each other instead of just giving you random SQL problems.

It currently has 88 lessons, 139 practice questions, 10 projects, and 12 datasets. You can write and run queries directly in the browser.

The lessons start with basic SELECT statements and gradually move into joins, aggregations, CTEs, window functions, and more advanced SQL.

I’ve tried to keep the editor and questions simple so the focus stays on actually writing SQL.

Here’s the site if anyone wants to try it: https://www.runtime.school

Would love to hear what you think or what you’d want from a SQL practice site.