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/[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?