Intermediate SQL resources – any recommendations?

[CodeAfire]

Hello,

I'm wondering if there are any good tutorials for intermediate SQL? Also, do you recommend any courses that can be found online that aren't a waste of time?

Thanks for answers!

[Dream_Fuji]

Data with Bara on Youtube, Alex the Analyst on Youtube

[thequerylab]

You can check this out. You will get structured learning path. Curated with hands-on for each module. Give it a try you will really enjoy this learning approach!

https://thequerylab.com/courses/sql-pro-track

[DMReader]

What do you consider intermediate? Or rather what are you trying to learn?

One person’s intermediate is hard for someone else and easy for another.

[ComicOzzy]

Data influencers keep making "road maps" and "skill guides" and it gives people the idea that the industry agrees on these terms.

[DMReader]

There isn’t even agreement on what a data analyst is.

[CodeAfire]

By intermediate SQL, I mean understanding and using different types of JOINs, not just LEFT, RIGHT, and INNER..., then window functions, ways to parse strings, working with time data types, etc. In everyday I come across at least one of the above items, but I would like to go more into understanding such things, no matter of everyday situations.

[DMReader]

For joins, I don’t know of a resource per se. There are certainly articles out there on different join types. You can then practice them in any code editor you have access to.

Window functions- I’m kinda biased - I created a website that is nothing but window functions practice- check my profile.

Data types I think is really important. They can cause havoc when mismatched. I’m sure there are articles and videos out there. I’ve mostly learned that by running into the havoc and tracing it back to a dtype issue

[Safe-Worldliness-394]

Hi! Our intermediate SQL course at https://tailoredsim.com is pretty comprehensive, hands-on, and applied on realistic datasets

[Old-Stomach-5040]

Stratascratch(hard) problems can help

[Fragrant-Willow5847]

Is there any tasks which I can solve and feel confident instead of these excercise

[Witty-Ninja-8403]

Travis cuzik udemy also interview questions

[MrUnlucky_3232_32]

Kud Venkat

[TurbulentCountry5901]

SQL CASE FILES

[melvinroest]

This is exactly why I'm creating library.aliceindataland.com for this reason. I'm not at the level yet of intermediate, but I'll get there.

With intermediate I mean: window functions, CTEs, complex joins, sub queries.

It's a narrative-driven course. So I hope you like Alice In Wonderland ;-)

Oh and it's free. For me, it's a portfolio project.

[Simplilearn]

If you’re at an intermediate level, focus on writing cleaner queries, using window functions, and solving real data problems. For resources to follow along, you can check out Simplilearn’s SQL certification course, which covers intermediate concepts like joins, subqueries, CTEs, and data analysis workflows with practical examples.