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?

    • lemmyvore@feddit.nl
      link
      fedilink
      English
      arrow-up
      6
      ·
      11 months ago

      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.