this post was submitted on 09 Nov 2023
13 points (100.0% liked)

SQL

469 readers
1 users here now

Related Fediverse communities:

Icon base by Delapouite under CC BY 3.0 with modifications to add a gradient

founded 2 years ago
MODERATORS
13
Learning SQL (self.sql)
submitted 1 year ago* (last edited 1 year ago) by sleepingoddish to c/[email protected]
 

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.

top 5 comments
sorted by: hot top controversial new old
[–] [email protected] 5 points 1 year ago

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.

[–] [email protected] 3 points 1 year ago

w3schools.com has a good SQL tutorial for beginners.

[–] [email protected] 3 points 1 year ago

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).

[–] [email protected] 3 points 1 year ago* (last edited 1 year ago)
[–] [email protected] 1 points 1 year ago* (last edited 1 year ago)

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.

https://www.w3schools.com/sql/