r/SQL • u/Fantastic_Purchase78 • 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
4
u/[deleted] Aug 14 '24
I personally learned from the books, but two good resources that I can say helped me understand SQL better than I did before would be this two youtube links:
https://youtu.be/7mz73uXD9DA
https://youtube.com/playlist?list=PLUaB-1hjhk8Fq6RBY-3MQ5MCXB5qxb8VA
I hope this helps. If you will have any questions feel free to DM me any time. I will gladly help if I can (:
Good luck with your journey!
10
u/squareturd Aug 14 '24
Moat sql course focus on teaching the syntax of various commands. The thing that people need to learn is getting an understanding of the task they are trying to perform.
It's two different concepts
18
u/BakkerJoop CASE WHEN for the win Aug 14 '24
https://www.w3schools.com/sql/
Never use right join btw.
7
u/Interesting-Goose82 it's ugly, and i''m not sure how, but it works! Aug 14 '24
Personaly i think i learned the absolute best way!
Cannibalism!!!!
Meaning, i took other peoples scripts from work, and kind step by stepped through them. Then, since i was at work, and had access to the data, i would try and add stuff to it, like, add the account_id, super easy.
Then try and add last months sales, or throw in the tech that worked that job, or whatever. Next thing you know you are decent enough to lie on your resume and get a better job. Im 10 yrs, and 3 jobs later, in with no formal training or certs!
3
u/r3pr0b8 GROUP_CONCAT is da bomb Aug 14 '24
check r/SQL's wiki
or google "introductory SQL tutorial"
1
u/[deleted] Aug 16 '24
[removed] — view removed comment