I’ve started to take an intro SQL class but I want to find more places to practice. Do any of you have recommendations for sites that I can use to practice creating queries based on pieces of information someone is looking for?
Any other advice to give to a brand new SQL learner?
Thanks in advance for any guidance.
Edit: Thanks a ton for the responses, I really appreciate it. I’ve bookmarked these pages and started to go through these sites.
https://www.kaggle.com/learn/intro-to-sql
https://www.kaggle.com/learn/advanced-sql
https://www.kaggle.com/datasets?fileType=sqlite
https://www.kaggle.com/datasets?fileType=bigQuery
https://www.databasestar.com/sql-practice/
Keep in mind that every database uses a common core of SQL but they are all using slightly different implementations of SQL. For example, SQLilte and bigQuery and MariaDB are likely to have very similar but slightly different syntax to accomplish the same task.
Have a look at SQLServerCentral.com. Lots of articles and forums there. Of some importance is to think about doing things in sets, not one by one. For example, if you need to do the same thing to a bunch of rows, don’t write a loop to do them one at a time - you can usually do them all at once. Lookup RBAR (Row By Agonising Row).
w3schools.com has a good SQL tutorial for beginners.
Here are some great sites for combined practice and learning:
https://8weeksqlchallenge.com/
I’m no dev, but when I needed to learn SQL for work I found w3schools to be a great resource. They have guided lessons that are fairly well done and examples to practice the things they show. At the very least it may help reinforce concepts you learn in class and introduce you to some of the more complicated features of query construction ahead of time.
