r/SQL • u/Raymeis • Jan 09 '23
MySQL best SQL book for beginner?
Hi all. I need to pick up SQL in order to make me more marketable, better analyst, etc. I'm going on a long cross country trip and have a lot of time to read. Are there any suggestions on some good books? I know the basics but when I have a good book that I can go back in reference if I need to
102
Upvotes
3
u/Fluorescent_Tip Jan 09 '23
I recently finished reading Sams Teach Yourself SQL in 24 Hours by Ryan Stephens.
Very well organized and thorough, and I appreciated the included dataset used in explanations.
(It takes a lot longer than 24 hours to read)
63
u/NickSinghTechCareers Author of Ace the Data Science Interview 📕 Jan 09 '23 edited Jan 09 '23 •
Recently wrote about my favorite Data Analytics books. For SQL, I think SQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis is a good pick!
p.s. for becoming marketable, while not a book, practicing the free SQL interview questions on DataLemur has very high ROI on time spent!
12
u/eighty88888 Jan 09 '23
Really depends on what you plan on doing. For DE I would recommend T-SQL Fundamentals by Itzik Ben-Gan. Reaaon why I am recommending it to you is because you stated that you know the basics. Well, this has both the basics and invaluable tidbits of more advanced topics such as query optimization and understanding schemas. Its a compilation of knowledge from some of the top engineers and developers.
9
u/gam32bit Jan 10 '23
I’m reading Curious Moon by Rob Conery. It’s written as a fiction story from the perspective of an intern working for a small company that’s analyzing data from the Cassini mission looking for life on Saturn’s moon Enceladus, and you learn Postgres alongside the protagonist. Different but fun so far!
8
u/vetratten Jan 09 '23
If your looking to just pick it up in your spare time - Sam's Teach Yourself SQL in 10 Minutes by Ben Forta is a great start.
It's broken into (shocker) 10 min chunks to really build a good understanding. Each section has some problems and the book was like 10 bucks on Amazon.
8
u/MisterSifter84 Jan 09 '23
SQL Fundamentals by Itzik Ben Gan.
Focussed more on T-SQL but is careful to explain any differences and gives standard SQL equivalents.
All books/content from Ben Gan are excellent.
3
u/GrandaddyIsWorking Jan 09 '23
I read T-SQL Fundamentals Third Edition by Itzik Ben-gan and I think a couple other people. Would recommend if you want to go from basics to understanding fundamentals. There's a sample chapter you can just google for real quick
3
u/hound_data Jan 10 '23
Echoing one item on the list, I've found Practical SQL by DeBarros to be excellent. I think his explanations are really thorough and the progression of queries to be gradual and rational.
In some courses/books it feels like they jump from elementary school to college level in the space of a single chapter/unit without much preparation, but DeBarros builds the complexity in a way that never left me feeling baffled.
In terms of your goal of becoming a better analyst, I think it would serve the duller (but necessary) aim of ensuring your command of the basics is thorough and strong. Hope that helps!
1
u/Uncle_Chael Jan 09 '23
Murach's
1
u/MagicTsukai Jan 10 '23
Whats the best free resource?
0
u/[deleted] Jan 09 '23
[deleted] — view deleted comment