I’m looking for a website where I can practice SQL by doing challenges. Like something where it provides you with some tables and you’re tasked with writing a script to achieve a certain output. I know how to do basic SELECT and UPDATE commands and stuff, but I need a way to practice writing more complex scripts. What do you guys recommend?
Codewars. It has Postgres as one of the languages.
I second this. Learn Postgres as a beginner, it’s SQL standard compliant and it has the amazing EXPLAIN feature (just add EXPLAIN in front of any query). People who start on MySQL or MariaDB have a harder time learning proper SQL concepts later.