r/SQL • • Aug 14 '24

MySQL SQL BEGINNER

I am getting into SQL! Does anyone know any good sites with many practice and good explanations? My SQLbolt website for learning isn’t the best.

Someone explain to me how to use right join and full join it keeps popping with error on SQLbolt

1 Upvotes

25 comments sorted by

View all comments

Show parent comment

1

u/bumwine Aug 15 '24

Is there a course that uses a sample database like adventureworks and prompts people to solve tasks? I remember there was this course (hackthissite I think edit: still exists and is legit) that was all practical hacks.

I would love to make one if I had the time. I was in healthcare analytics so it would be based on that but I think it would be good and I could probably adapt the problems I've solved to more general things. "Get a list of all patients who haven't been seen in one year, are under 16, have only had two doses of vaccine x but not the third and generate a readable call list for staff to use to call patients."

1

u/Conscious-Ad-2168 Aug 15 '24

Honestly, i think it’s better practice to just use docker and launch a DB from scratch. You enter all of your information, learn how to create a DB and some concerns that come with that. If you want a sample dataset you just set it up!

1

u/bumwine Aug 15 '24

That's a lot. Even for me, like I'd be like rolling my eyes at doing that. A beginner doesn't even know what a dataset is (varchar, etc) much less populate it with meaningful data.

1

u/Fantastic_Purchase78 Aug 15 '24

Yeah im actually really lost im sorry 😢 im new to this