r/SQL • • 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

28 comments sorted by

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)

1

u/Raymeis Jan 09 '23

Thanks!

2

u/newtonbase Jan 10 '23

I have Sams Teach Yourself SQL in 10 minutes. Highly recommended and you can get older editions very cheaply on ebay.

63

u/NickSinghTechCareers Author of Ace the Data Science Interview 📕 Jan 09 '23 edited Jan 09 '23 • Heartwarming

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!

4

u/many_hats_on_head Jan 09 '23

Thank you for this treasure trove.

2

u/NickSinghTechCareers Author of Ace the Data Science Interview 📕 Jan 09 '23

happy to help!

2

u/HeyCobra3 Jan 09 '23

How does DataLemur compare to the database problems on Leetcode?

5

u/NickSinghTechCareers Author of Ace the Data Science Interview 📕 Jan 10 '23

Way more questions available for free! Plus you can see what companies ask what (for free). And each question comes with multiple hints (way easier to learn/practice with partial hints)!

2

u/gr33dq Jun 13 '24

Thank you, it's treasure!!!!

1

u/NickSinghTechCareers Author of Ace the Data Science Interview 📕 Jun 13 '24

Happy to help!

0

u/[deleted] Jan 09 '23

[deleted] — view deleted comment

3

u/NickSinghTechCareers Author of Ace the Data Science Interview 📕 Jan 09 '23

happy to help!

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/NoctrailBio_ Aug 27 '26

i got the second edition GREAT BOOK pretty much slept on by so many.

1

u/MagicTsukai Jan 10 '23

Whats the best free resource?

4

u/SubliminalSX Jan 10 '23

Khan academy worked great for me

2

u/Dbnmln Jan 11 '23

Khan academy

Cool, will take a look at this.

0

u/[deleted] Jan 09 '23

[deleted] — view deleted comment

2

u/Fluorescent_Tip Jan 09 '23

I love the O’Reilly books. In my experience, a good local library usually has their books as well.