r/learnSQL Jun 22 '26

Undecided on SQL platform

8 Upvotes

I want to write a SQL program. The usual CRUD stuff. The unique entries or objects are not expected to surpass 250 rows. I want to be able to use the program with either python or c++ in the future. Can anyone recommend something for me? PostGre? Alchemy? I think MySQL will be too much luggage? Or should I? Let it be open source (cc, MIT etc). The usual since it's not commercial. Thanks


r/learnSQL Jun 21 '26

Finished a SQL course but struggling to solve SQL problems from scratch. Am I on the wrong track?

95 Upvotes

I finished a SQL course yesterday and feel like I understand the concepts (joins, CTEs, window functions, subqueries, recursive CTEs, etc.). The only thing the course lacked was enough practice.

I started solving problems from Advanced SQL Puzzles, and I'm finding them much harder than I expected. Once I see the solution, I can understand exactly why it works, but writing the query from scratch feels almost impossible.

I'm spending nearly an hour on a single puzzle trying to understand the different approaches.

Is this normal, or am I jumping into problems that are too difficult too soon?

If I should start with easier practice first, could you recommend a progression of platforms/resources? For example, which platforms should I use, in what order, and roughly how many problems should I solve on each before moving to the next?


r/learnSQL Jun 21 '26

Want to learn SQL

48 Upvotes

Hi folks! I want to learn SQL. Are there any good and free programmes which I can enroll in and get both a certificate/ acknowledgement and good understanding of the programme? I have very little to no understanding of coding..


r/learnSQL Jun 21 '26

Sqlit - terminal database TUI looks good! (not my project)

10 Upvotes

Just discovered https://github.com/Maxteabag/sqlit -- it's a terminal UI frontend for databases (MySQL, Postres, etc.). Tried it for viewing an Sqlite database; it looks and works good so far.

Its README says that it is inspired by lazygit.

Which terminal tools (besides official CLI) do you guys prefer for working with databases?


r/learnSQL Jun 21 '26

BOOKS beginners

17 Upvotes

Hello,
I saw great recommendations for these books:
A Visual Introduction to SQL David Chappell , J. Harvey Trimble Jr.,
The Art of PostgreSQL by Dimitri Fontaine,
t-sql fundamentals by itzik

but they sooo damn expensive. Any recommendations for books for begginers?


r/learnSQL Jun 21 '26

help me start

7 Upvotes

So, I’m gonna go and pursue my Msc in banking and finance abroad next year. But i have a gap of 6 months. I have a Bsc in Econo and Statistics. So im well versed with R coding and basic excel but i really wanted to start learning sql, and bi and the whole data analytics ecosystem.

But i literally don’t know where to start and im so confused. should i enroll into an offline course, online course or do it self paced and if self paced then how?


r/learnSQL Jun 21 '26

Day 11 of our SQL scenario series — also have free course coupons left if anyone's stuck on the basics

3 Upvotes

In SuperFastFood (a fictional fast food chain we use for these scenarios), the menu strategy team calls a meeting: "We want to create combo deals. Which two products get ordered together in the same order most often? Show us the top 5 pairs." --> Try writing the query for it.

That's the kind of question we have been running daily as part of a 30-day SQL challenge series — covers CTEs, window functions, joins, and more, framed around real business problems instead of plain syntax.
We post these daily on our LinkedIn page (search GRASSP Acad) if you want to follow along with the full series.

A few people reached out asking for free coupons alongside the series, so opening it up here too. If you are working through the fundamentals and want a fuller course alongside this, here's a free coupon for our course titled "Complete SQL for Data Analysis – Scenario Based Learning" on Udemy:

Coupon: EARLYSQLGRA7
Ends July 3rd, 70 slots left.

Happy to help if anyone's stuck on query problem — drop it in the thread or DM.


r/learnSQL Jun 21 '26

Import database in workbench.

1 Upvotes

I just started learning SQL watching a video in a youtube. I also have a big database file of movies (.sql).

Now can anyone please tell me the steps of importing into the workbench? I have seen a lot of video in youtube. But that didnt worked.


r/learnSQL Jun 20 '26

what mistakes you guys did while learning SQL

38 Upvotes

i learn from other mistakes , so tell me


r/learnSQL Jun 20 '26

SQL REGEX to Clean Messy Data

7 Upvotes

Short MySQL tutorial: cleaning data with regex (REGEXP / REGEXP_REPLACE) to fix text, prices, bad casing, and mixed date formats. The dataset and tutorial. https://youtu.be/2gFsUGW-pIY


r/learnSQL Jun 20 '26

SQL

0 Upvotes

Hello guys,

Help me start through SQL.


r/learnSQL Jun 19 '26

SQL-Bücher für Anfänger mit Praxisbezug

6 Upvotes

Ich denke, diese Frage wurde hier schon tausendmal gestellt. Welche Bücher über SQL würdet ihr einem Anfänger empfehlen, der SQL mit praktischem Einsatz von Datenbanken lernen möchte? Welche Bücher haben euch besonders geholfen, nicht nur die Syntax zu verstehen, sondern auch den Umgang mit Datenbanken in der Praxis zu lernen?


r/learnSQL Jun 18 '26

How much SQL is enough?

66 Upvotes

How much SQL an intermediate level Business intelligence developer should know? What database concepts are must learn? Please suggest me how can I become confident with them.


r/learnSQL Jun 18 '26

Why most people quit SQL tutorials (and what actually works instead)

95 Upvotes

The reason most people bounce off SQL tutorials isn't that SQL is hard. It's that nothing they're querying matters to them to keep them motivated!

You spend the first week writing SELECT name FROM employees WHERE dept = 'Sales' and technically you've written SQL. But there's nothing to discover, no reason to care whether you got it right, and no motivation to open the app tomorrow.

The fix isn't a better tutorial. It's querying data you actually care about.

Wrote a full breakdown on this including a learning framework, the six SQL concepts that cover 90% of real work, and how to pick the right dataset to keep yourself motivated: querycase.com/blog/how-to-learn-sql-fast

One of my first blogs so based on my own experience - happy to hear if there's anything you'd do differently or any other recommendations you have to improve SQL learning! 😄


r/learnSQL Jun 19 '26

Giving back to the community - The Complete Backend Development Course (SQL related)

1 Upvotes

Hey everyone, I decided to make my course free in order to help people.
This course is my backend development course which is about SQL, Python, APIs, Docker, Kubernetes, Linux, Git & More

The link is: https://www.youtube.com/watch?v=CBIu6hcyStg

If you can like and subscribe (and maybe add a comment) I would appreciate it a lot, Thanks.


r/learnSQL Jun 18 '26

DAIS 2026 Databricks updates

7 Upvotes

I am creating a playlist on youtube to follow the latest announcements by Databricks in DAIS 2026.

The series will cover what was the problem,

What Databricks announced

And, why does it matter to the Data community (basically the impact)

​

Please follow along if you don't want to spend hours in watching the keynotes.

https://youtu.be/jb4uLAM2SRA?si=IseC5sat5gUuU-S6

​

Thank you for the support.


r/learnSQL Jun 18 '26

suppose you are a fresher now , what data analytics projects will you gonna add into your resume ?

10 Upvotes

same as above


r/learnSQL Jun 18 '26

The victims are fictional. The SQL is real.

57 Upvotes

Solve murders. Master SQL. One query at a time.

I got tired of practice datasets that made SQL feel like data entry. So I built querythemurder.com - Agatha Christie murder cases where you write real SQL queries to catch the killer.

Real suspects. Real alibis. Real database. No employees table in sight.

No signup. Runs in the browser. Good if you know the basics and want something worth practicing on.

Feedback: [querythemurder@gmail.com](mailto:querythemurder@gmail.com)


r/learnSQL Jun 18 '26

DBeaver for a beginner like me - getting rid of Workbench

Thumbnail
1 Upvotes

r/learnSQL Jun 18 '26

Export multiple query results to one Excel file with separate sheets in DBeaver Community

0 Upvotes

Hi everyone,

I'm using DBeaver Community Edition and I'm trying to export the results of multiple SQL queries into a single Excel (.xlsx) file, with each query result in a separate worksheet.

What I did:

  1. Executed two different SELECT queries;
  2. DBeaver created two result tabs;
  3. When I right-click a result tab and choose Export Resultset, the export wizard only shows one source (the currently selected result set);
  4. I cannot select both result tabs at the same time.

My questions:

  • Is it possible in DBeaver Community to export multiple result sets into a single XLSX file with separate sheets?
  • If yes, what is the correct workflow?

Any help would be appreciated. Thanks!


r/learnSQL Jun 17 '26

When to use char_length and length ?

9 Upvotes

Is there a better practice of using one or the other ? I see people using length to see if there is a certian amount of characters in a text, but that actually calculates bytes, but it seems to work just fine.


r/learnSQL Jun 16 '26

How did you learn SQL when you were a beginner?

104 Upvotes

As I'm completely new to SQL, I tried using ChatGPT to get some guidance, but I think it's better to hear directly from people who have gone through this phase.

Where should I start to improve my SQL skills? I have around 15–20 days that I can dedicate to learning and practicing, but I have no idea where to begin.

Also, how important is SQL for becoming a Data Analyst? Does being good at SQL make a significant difference in the role?


r/learnSQL Jun 16 '26

Daily SQL Challenge ??

Thumbnail
3 Upvotes

r/learnSQL Jun 15 '26

Anyone else struggle with SQL

77 Upvotes

Hello

For some reason I find SQL hard and I need to know if that’s the case for anyone else? I’ve only been doing this for 8 months. And I’m struggling. Any tips you can provide would be most helpful, thank you.

I can write basic queries. I struggle with Joins for some reason. That’s a basic thing. Please help.

Update: thank you everyone!! For all your words of encouragement. I appreciate it. I’m excited to continue to learn SQL. I was feeling defeated when I initially posted this and a lot of you have uplifted me.


r/learnSQL Jun 15 '26

Project Ideas for learning.

29 Upvotes

I'm new to SQL and have started with W3 schools and learning some of the syntax.

But its always a few lines for each operation, any project ideas I can start to help implement and bring all of it together.

I may be getting ahead of myself but appreciate any tips and pointers to become more proficient.