submitted 1 year ago* (last edited 1 year ago) by sleepingoddish@lemmy.zip to c/sql@programming.dev

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

you are viewing a single comment's thread
view the rest of the comments

[-] cosmictrickster@lemmy.world 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).

this post was submitted on 09 Nov 2023

13 points (100.0% liked)

SQL

469 readers

1 users here now

Related Fediverse communities:

#sql on Mastodon
#postgresql on Mastodon
c/PostgreSQL on programming.dev

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

founded 1 year ago

MODERATORS

Ategon@programming.dev

jnovinger@programming.dev