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

SQL

473 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
[email protected]
[email protected]
12
Learning SQL (lemmy.zip)
submitted 1 year ago* (last edited 1 year ago) by [email protected] to c/[email protected]
4 comments fedilink hide all child comments
 

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 4 comments
sorted by: hot top controversial new old
[–] [email protected] 3 points 1 year ago

w3schools.com has a good SQL tutorial for beginners.

[–] cosmictrickster 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)

Here are some great sites for combined practice and learning:

https://sqlbolt.com/

https://8weeksqlchallenge.com/

https://sqlzoo.net/wiki/SQL_Tutorial

https://selectstarsql.com/

[–] [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/