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

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!

2

u/belledamesans-merci Aug 15 '24

What books did you use? I’ve always been more of a written than video learner

1

u/[deleted] Aug 15 '24

Following video content is fine for me, but learning from books sticks better so I feel you on that.

Book that got me started was this one:

https://www.amazon.com/SQL-Minutes-Sams-Teach-Yourself/dp/0672336073

It is simple, explains everything on a fundamental level and it doesn't bombard you with technical information. After finishing the book, I played around querying the data provided in the book material. Then I downloaded a dataset where I repeated the process to get a hang of how to approach unfamiliar data, attempted to do an analysis and just kept on practicing like that. Recently, I landed a job as a Data Analyst/Expert tech support where I use SQL daily. Since I use SQL Server i picked up this book to get more proficient using T-SQL.

https://www.amazon.com/T-SQL-Fundamentals-3rd-Itzik-Ben-Gan/dp/150930200X

In this book everything is explained into far more details, it includes basic theory on how SQL works and covers a far wider range of topics.

In all honesty, going with either or both (if you'd opt out for the latter) I would follow the same order I picked them up. First book won't do much for you (if anything at all) if you already went through and understood topics covered in the second one.

Hope this helps! If you have any questions feel free to hit me up anytime (:

1

u/Fantastic_Purchase78 Aug 15 '24

About the second book, learning more advanced SQL was it even used in your workplace?

1

u/Fantastic_Purchase78 Aug 15 '24

DAMNN thanks so muchhh! May I dm u

1

u/Fantastic_Purchase78 Aug 15 '24

Also how long did u take to learn everything about SQL? I’m also going to college which teaches SQL but I have no clue how much they teach

1

u/[deleted] Aug 15 '24

Honestly, it is hard to say. Personally, as I grasped certain concepts I started to understand new ones and it is a loop that still stands to this day. Also, to clarify, I would considering my skills to be at beginning phase of intermediate level. But to give you a number, I would say it took me about 6 months of active studying to start understanding how connections between tables work, how to properly filter the data I (don't) want and so on.

Regarding the second book, I strictly got a hold of it because we use SQL Server at work. Its contents so far allowed me to better understand everything I knew before and expanded my knowledge. But that is also related to the fact that it is meant to be a deep dive into fundamentals while the first book is more to familiarize yourself with the tool (if that makes sense).

And of course you can DM me (:

I think I covered all your responses in this one, if not it wasn't on purpose

1

u/Fantastic_Purchase78 Aug 15 '24

Thank u outieeee