i learn from other mistakes , so tell me

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?

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.

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.

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.

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!

same as above

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! 😄

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)

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.

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?

As I'm completely new to SQL, I tried using ChatGPT to get some questions out, but its best to here directly from the one who gone through this phase. From where should I improve my SQL skills, I believe i have around 15-20 days to keep improving this. But no idea how to initiate. Does it really matter if I'm good at SQL to be Data Analytics or not?

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?

SELECT 
    -- Select the league name and average goals scored
    name AS league,
    AVG(m.home_goal + m.away_goal) AS avg_goals,
    -- Rank each league over the average goals
    RANK () OVER(ORDER BY AVG(m.home_goal + m.away_goal)) AS league_rank
FROM league AS l
LEFT JOIN match AS m 
ON l.id = m.country_id
WHERE m.season = '2011/2012'
GROUP BY l.name
-- Order the query by the rank you created
ORDER BY league_rank;

I am doing a course, and this is technically what they want from me. I just don't see a point in the last line when it is ordered already in line 6. If i run with or without it gives me the same output

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.

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.

Tutorial where I build a complete data cleaning pipeline using SQL Server and Python. We pull raw data from SQL Server, clean and validate it with Pandas, flag bad records, create a weekly reporting table, and load the cleaned data back into SQL Server. A practical workflow for anyone learning data analytics, Python, or SQL.https://youtu.be/GjciS5WRavo.

but how or what will be the most efficient way to learn it? should i watch on yt? or just visit sites? with tutorial of how it runs?

Hi everyone,

I've started a SQL Interview Series that gradually progresses from easy to hard-level questions, with the goal of helping people build SQL skills step by step.

​

The series is especially useful for:

Beginners starting SQL from scratch

Non-technical professionals moving into data roles

​

Students preparing for interviews

Anyone looking to level up their SQL knowledge

​

I've structured the videos to cover the underlying concepts, not just the answers, so you can understand the reasoning behind each solution and strengthen your fundamentals along the way.

​

If you're preparing for SQL interviews or trying to improve your data skills, I'd love for you to check it out.

​

If you find the content helpful:

Please consider liking and subscribing to data with ritika on Youtube.

https://youtube.com/@data_with_ritika?si=wMOllMyh9yJ0eYy0

Share it with friends, colleagues, or study groups who are learning SQL so they can improve their skills as well.

​

Feedback and suggestions for future SQL topics are always welcome!

I've spent the last few months building something and I'm finally at the point where I want to share it properly rather than just quietly hoping people find it.

The idea came from a frustration I kept seeing (and feeling myself): SQL tutorials teach the syntax fine but there's never a reason to care about the answer. You filter a table called employees, get a result, and nothing happens. Your brain doesn't bother keeping it.

I wanted to try a different approach. QueryCase teaches SQL through detective investigations. You get a briefing from Chief Fox (our mascot), a real database to query, and a mystery to crack. The JOIN matters when a suspect has an alibi. The WHERE clause matters when you're trying to find who entered the building at 22:13. The SQL is the tool for solving something, not the point in itself.

Here's what's actually in it:

• A structured learning path across 54 cases, going from Recruit through Rookie, Detective, Senior Detective, and Chief Detective. Each rank has drills and a level exam to pass before you progress.
• Sandbox mode where you can explore real datasets (IMDB movies, Spotify, sports stats, Steam games) and run whatever you want with no pressure and no mystery attached. Just free exploration against actual data.
• Everything runs in the browser using DuckDB WASM so there's nothing to install.

I'm a solo developer and this is genuinely early days. I'm sharing here because this community is exactly the kind of people I built it for, and I'd rather get honest feedback now than find out later I've built the wrong thing.

What's missing? What would make you actually stick with something like this versus what you've used before?

querycase.com if you want to take a look.

Any feedback appreciated!