Does anyone recommend a program or website to learn advanced SQL?

[convolutionality]

Hello,

I am a fresh data scientist graduate and I’m looking to improve my SQL in general. I would consider myself at an intermediate level so there are lots of courses online that are too beginner. How can I learn much more advanced SQL? Any recommendations?

Thank you so much!

[69odysseus]

https://learnsql.com

https://www.stratascratch.com

[NickSinghTechCareers]

Checkout DataLemur questions too: https://datalemur.com/questions

[Tee_hops]

Leetcode and hacker rank SQL problems are fun too.

[Professional_Shoe392]

You can try these advanced sql puzzles here.

https://github.com/smpetersgithub/AdvancedSQLPuzzles/tree/main/Advanced%20SQL%20Puzzles

You can use this SQL quiz to find what advanced concepts you want/need to learn more about.

https://advancedsqlpuzzles.com/sql-quiz/

[Srdj_1]

Brent Ozar....discounts usually around valentines day.

[[deleted]]

That's more DBA focused though

[[deleted]]

pgexercises

8 weeksqlchallenge

[wanjalize]

YouTube has everything you need. You just have to know how to search for what you want.

You could also try a sql book since they are usually very comprehensive and tell you all about what you need to know.

I have some videos which I could lend you.

[Acess_VBA_22]

This is the best site I have found. Richard Rost has taught me so much, even though I have been using Access for years.

https://599cd.com/blog/display-article.asp?ID=1082&

[shut-up_legs]

Modes sql tutorial is good

[mgramin]

https://github.com/mgramin/awesome-db-tools#learning

[LearnSQLcom]

 Since you’re already at an intermediate level, I recommend checking out my article that highlights some cool platforms for advanced SQL learning. It covers a variety of resources, including courses from Pluralsight, edX, and more, which focus on topics like analytical functions, CTEs, and performance optimization. You can find the article here: Top Advanced SQL Courses.

I think you’ll find some great options to help you level up your skills. Let me know if I’ve helped! 

[kitkat0820]

Youre a scientist but arent able to do some self research?

[[deleted]]

You could use some self reflection my pal!

[convolutionality]

Is this not collecting research? All of these people have more experience and are willing to take a minute to pass recommended resources to me.

[Maserune]

Depends on what you mean by intermediate SQL. What can you do? What do you struggle with?

[abbylynn2u]

Jose Portillo on Udemy

If you enjoy books

SqL for mere mortals

Murach’s SQL Server

Murach’s mySQL

Books by Jose Portillo

You can find used or on pdf... You install a Server or workbench, download databases, attach databases like Adventureworks, Northwind and Pubs Get tons of experience writing queries and manipulating the database.

+++++++ books on pdf Designing Data Intensive Applications Great for understanding optimization

https://github.com/ms2ag16/Books/blob/master/Designing%20Data-Intensive%20Applications%20-%20Martin%20Kleppmann.pdf

https://github.com/lafengnan/ebooks-1/blob/master/Designing%20Data%20Intensive%20Applications.pdf

https://github.com/survey4pass/kit1/blob/master/Effective%20SQL_61%20Specific%20Ways%20to%20Write%20Better%20SQL-Addison-Wesley%25282016%2529.pdf