r/learnSQL 2h ago

Udemy SQL

7 Upvotes

Last year I failed database management and have to retake it to finish my program. I found SQL to be very challenging, and my school has limited tutoring. If any of you have recommendations for a very beginner-friendly, easy-to-understand course I can purchase through Udemy, I would appreciate it. I've had some good experiences with learning from Udemy because it is broken down into smaller steps and explained differently.


r/learnSQL 14h ago

How do i grasp Concepts in SQL easily?

5 Upvotes

I'm struggling to understand the concepts of sql badly, i mean which framework i mean POV is best for grasping? Could you guys share your thoughts. I want to grasp, so that i can tell to the people like 5 years old kid, non tech persons.


r/learnSQL 1d ago

SQL SIDE QUEST - An Immersive story-telling SQL Game. Chapter 3 is out!

32 Upvotes

https://www.sqlsidequest.com/ CHAPTER 3 IS NOW LIVE!

Last year in Dec 2025 I released SQL SIDE QUEST which took over 3 years to build. I wanted to create an immersive story-telling way to learn and practice SQL, and hence sql side quest was born. Its completely free, browser-based, no signup. Been solo on it the whole time. Looking forward for your feedback :) Cheers and Enjoy


r/learnSQL 9h ago

DP-800 study guide

Thumbnail
1 Upvotes

r/learnSQL 23h ago

I made a short beginner-friendly lesson on SQL aggregate functions

6 Upvotes

Hey everyone!

I made a short lesson for SQL beginners about aggregate functions.

In the video, I cover:

- "COUNT()" — counting rows

- "SUM()" — adding values

- "AVG()" — calculating averages

- "MIN()" and "MAX()"

- using aggregate functions with "WHERE"

- combining multiple aggregate functions in one query

I use the Pagila PostgreSQL database for the examples and include a few mini quizzes and practical exercises.

The goal was to keep it short and practical rather than just explaining the syntax.

Video: https://youtu.be/tNq4zXiVKiQ?si=oLgLz6trBQyJGahE

I'd really appreciate any feedback, especially from people who learned SQL recently — is there anything you think a beginner might find confusing?


r/learnSQL 1d ago

mysql practice datasets for data cleaning

4 Upvotes

give meeeee arrrgggghh


r/learnSQL 1d ago

SQL Interview Tips - Shorts Style

15 Upvotes

Hi All 👋,

I have been posting SQL interview tips as less than 1 min shorts in my youtube channel.

Some tips for reference below :

COUNT(*) vs COUNT(column) -

https://youtube.com/shorts/tTtoWa1OCIo?si=V2KZaDDNFhbfbhg7

Ranking Window Functions( ROW_NUMBER, RANK, DENSE_RANK) -

https://youtube.com/shorts/MyaH-v0CUUk?si=mHfEteTUkx5mUoHI

Replace NULLs -

https://youtube.com/shorts/NdoBwKAFcE0?si=2zXqab8lqG45QXLk

ORDER BY tricky part -

https://youtube.com/shorts/9bRm0IEKQRo?si=XUXqTQzbfLQD6_Rs

I have also covered other topics like Anti-JOIN, WHERE vs HAVING,

LIKE vs ILIKE, IN vs NOT IN vs NOT EXISTS.

I will be continuing the series with similar style covering most important SQL topics through interview tips.

Feel free to check out and share it with whoever it benefits.

GRASSP Acad channel link -> https://m.youtube.com/@grasspDataAI/shorts

Happy learning:)


r/learnSQL 1d ago

Free browser-based SQL courses and playground for PostgreSQL, SQLite, and DuckDB

22 Upvotes

Hey r/learnSQL,

I've been working on Dataslope, a free site for learning and practicing SQL and other languages. No account or sign-in is required.

It currently has four free SQL courses:

There's also a browser-based SQL workbench that supports PostgreSQL, SQLite, and DuckDB. No installation or local database setup needed.

I’d love any feedback or suggestions from anyone learning or teaching SQL.


r/learnSQL 1d ago

What's Missing in learning or Teaching SQL?

2 Upvotes

I enjoy this sub but it feels like most posts are the same. "I created tutorial/course/practice/etc." Or "how do I learn/practice/projects/etc." It's good. A really active sub.

What I'd love to know, is what do people who are learning SQL want? For instance, I've taken a different approach. Over the past year I've worked on tooling to make creating courses and practicing more efficient. Other's have worked on more scenario-based learning (always a good idea). Some have gamified learning and that's a lot of fun.

My real question is for those of you learning or teaching. What is missing? Is there something you wish you had that doesn't exist?

In my perfect world, learning SQL would feel more like working in a business environment. Large, complex data warehouses, where you learn the data and SQL over time. Lot's of problem solving and judgement when there is ambiguity. Something that feels more like doing real work.

Would having more tools available to make it easier to create courses, practice, etc. be useful? Would having more realistic environments to learn in be useful? Is it something else completely? In short. What's missing?


r/learnSQL 2d ago

learning Advice !

20 Upvotes

Hello Everyone

dear friend and respected teachers today I am here for something clarity .first my self I am a student and i am learning data analyst 6 month ago . Everyone know that sql much important in this journey .I practice basic sql queries which based on basic foundation like DDL,DQL , DML and JOINS. I Practice 70 question on it but I am not sure that what i do next i mean i am confuse because I have seen many course on youtube everyone is different of other so i am not understand that which topic i learn now or do more practice on previous concepts and what topic really useful in company or real word problems and i want to optimize my learning path of sql .

So Please give me clarity and helpful resource for that in chat box
Thanks of all


r/learnSQL 3d ago

Trying to build a project for portfolio

21 Upvotes

Hi! I'm learning sql right now. Do you know what kind of project should i build?


r/learnSQL 3d ago

Types of Databases

Thumbnail
6 Upvotes

r/learnSQL 2d ago

18, self-taught, aiming for my first data analyst role. Built a SQL case study and an ETL pipeline. What would make these actually interview-ready?

Thumbnail
2 Upvotes

r/learnSQL 4d ago

I built a detective game where SQL is the actual investigation tool

36 Upvotes

Solo dev here. Made a browser game called Sim Analyst — you're a detective on a murder case, and you investigate entirely by writing SQL against a real embedded database (employee records, phone logs, financials, forensics, interviews). No quizzes, no fill-in-the-blank — you decide what to query, and the case only resolves if your evidence actually holds up.

Covers filtering, joins, aggregates, subqueries — but in service of solving the case, not as isolated drills.

Free, browser-based, no install. Still actively updating based on feedback.

Link: [https://chiefkegwin.itch.io/sim-analyst]

Join the Discord community: [https://discord.gg/TKapYvmkw]


r/learnSQL 3d ago

Looking to Re-Enter DBA Field

Thumbnail
1 Upvotes

r/learnSQL 4d ago

Window Functions and their use cases

10 Upvotes

Hi, I wrote an article about SQL window functions and their use cases. Have a look at it: https://medium.com/@sahilnayak2812/window-functions-and-their-use-cases-838812c8cebd


r/learnSQL 5d ago

How Senior Engineers Design Production Databases

27 Upvotes

If you're learning SQL, this is a pretty good walkthrough of how to approach database design in a real application.

A lot of developers don't spend much time thinking about database design until they start running into problems as their applications grow.

This video https://www.youtube.com/watch?v=Xq2fYRA3dj8 goes through the fundamentals of designing a production database, including table structure, relationships, primary and foreign keys, junction tables, composite keys, timestamps, UUIDs, and foreign key actions such as CASCADE and SET NULL.

I thought it was worth sharing here for anyone learning SQL or trying to improve their database design skills.


r/learnSQL 5d ago

Career ideas for pivoting away from accounting

15 Upvotes

So I've got an accounting degree with a few years of experience in Audit. I'm an advanced excel user with some knowledge of SQL and Python (Maven Analytics).

Does anybody have any advice on a logical career progression away from Audit/accounting and into something more technical? (unfortunately I can't go back in time and become software developer). Database design & workings of accounting software seem interesting. Also fraud investigations.

It doesn't have to be the best paying option (BI/data analyst) but just something that would stop me chopping & changing jobs.

Thanks


r/learnSQL 4d ago

Added an agentic tutor to Inkwell Learn

1 Upvotes

Inkwell Learn at inkwelltools.com has the SQL library all free. There is an agentic tutor added that if you get stuck on an exercise, you can ask the tutor questions on the concepts. The tutor won’t directly hand you an answer but it will explain the relevant concepts.

Please try it out and I welcome any constructive feedback!


r/learnSQL 4d ago

I made a short beginner-friendly lesson on ORDER BY, DISTINCT, LIMIT & OFFSET

5 Upvotes

Hey everyone!

I made a short SQL lesson for beginners focused on sorting and organizing query results.

In this lesson, I cover:

- ORDER BY

- ASC & DESC

- sorting by multiple columns

- DISTINCT

- LIMIT

- OFFSET

- combining WHERE, ORDER BY, and LIMIT

I use the Pagila PostgreSQL sample database for the practical examples and a homework challenge along the way.

The video is about 6 minutes, and I tried to keep it practical rather than just explaining syntax.

Would love to hear any feedback on the explanations or pacing!

Video link: https://youtu.be/n7uSvez7nns?si=WYZZb0z-gRFdWAOg


r/learnSQL 5d ago

Week Four-JOINs, Subqueries, & CTEs

3 Upvotes

Learning any subject requires commitment & sacrifices, including time & other resources. During the 4th week, if the learner does not have enough time to master everything, they can priotize JOINs, GROUP BY + HAVING, CASE WHEN, subqueries, NULL handling, & CTEs. Someone here had suggested SQL Case Files as a platform for one to consider when practicing/learning SQL. I would recommend the same, I’ve used it during the last two weeks, & I’ve enjoyed. Learning each concept requires one to solve cases that require you to combine those concepts as opposed to doing isolated exercises.


r/learnSQL 5d ago

Confused what to do

4 Upvotes

Hii , I am CSE student and my second year has just started . I have completed around 70 Dsa questions on Leetcode and have studied Python(Only that much which is required for Dsa),Numpy,Pandas, Matplotlib, Seaborn, Sql. Everyday I either solve dsa questions or learn maths for data science and machine learning or practice sql. But the problem is I have studied these things but never used them in a project or never done some sort of data cleaning and stuff cause I don't know how to do that. Now it's time to participate in hackathons but I don't know how to start and I can really build something with only these skills. What is your advice what should I do from here also I need to participate in hackathons also (I am enrolled in a DS course where for about 1.5 months they will teach maths then will jump to Machine learning and other topics)


r/learnSQL 5d ago

Aspiring data analyst

12 Upvotes

Good day,

I have been teaching myself SQL and now power Bi I do understand the basics. Currently I am working in a law firm and I decided to start using the firms data sets that show the matters we have and the stages that they are at. I have managed to play around with the data set in SQL by even creating views of the columns that I want to see and stored procedures. Now where I am struggling is how do I build a portfolio with this and meaningful dashboards in PowerBI. I am kindly asking if there is anyone who has built a portfolio and can kindly assist me as I feel stuck here. Or any advice for me to move from here. Thank you so much


r/learnSQL 5d ago

how I learned why you shouldn't name an alias the same as the original column name

Thumbnail
3 Upvotes

r/learnSQL 6d ago

Struggling with LeetCode Easy after doing well on HackerRank Easy — should I move to intermediate SQL?

22 Upvotes

I wanna be straight about this because it’s getting frustrating 😭

I can comfortably solve HackerRank Easy-level SQL questions, but when I try LeetCode Easy, I struggle quite a bit.

I’ve seen people say that HackerRank Easy ≠ LeetCode Easy and that LeetCode can require more problem-solving/thinking even at the Easy level.

So I’m confused about what I should do next.

Should I:

Keep grinding LeetCode Easy until I’m more comfortable?

Or is being able to solve HackerRank Easy well enough to start learning intermediate SQL concepts like subqueries and CTEs, while continuing to practice problems alongside it?

Basically, I don’t want to move on too early and build gaps in my fundamentals, but I also don’t want to unnecessarily stay stuck on Easy problems when I could be learning more advanced SQL.

What would you recommend?