What's the best book for learning SQL? It could be one of these...

Подписаться 494 тыс.

Просмотров 66 тыс.

50% 1

Sponsored by Blinkist: Use my special link to start your free 7 day trial with Blinkist and get 25% off of a Premium membership www.blinkist.com/pythonprogra...
So you want to learn SQL and you're looking for a good book? I think these two books by No Starch Press and O'Reilly are both excellent introductions to SQL. But which is the best? Watch the video to find out!
Buy the books:
Practical SQL: amzn.to/3zKENPU
Learning SQL: amzn.to/3l31g6K
Learn Data Science (affiliate)
1. Data Quest - bit.ly/3yClqbZ
My Python Courses
1. Exploratory Data Analysis with Python and Pandas - bit.ly/2QXMpxJ
2. Complete Python Programmer Bootcamp - bit.ly/2OwUA09
(These contain affiliate links, which means I receive a percentage of any sales made. There is no additional cost for anybody clicking on them)
👌 SUBSCRIBE to ME!👌
/ @gilesmcmullen
Twitter
/ gilesmcmullen
Instagram
/ gilesmcmullen
#SQL

Наука

Опубликовано:

5 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 103

@gilesmcmullen 2 года назад

Sponsored by Blinkist: Use my special link to start your free 7 day trial with Blinkist and get 25% off of a Premium membership www.blinkist.com/pythonprogrammer

@fabriziopellegrini9517 2 года назад

My two cents as I'm working through Learning SQL by O'Reilly. I think it's very useful to try and write the queries while you're studying the chapters. This is because the 3 or 4 exercises at the end of each chapter are not enough to practice the things you've jus read. Sometimes you can anticipate what the author wants to achieve with the next query: try to write it yourself without looking, perhaps make a mistake, but then your mind wil absorb the concept more easily. These books are practical SQL books, the whole point is getting used to build queries in an efficient and clear way. :)

@varunnayyar3138 2 года назад

You are absolutely right. I am learning from the 3rd edition and I almost run all queries in a chapter. The end exercises aren't even challenging

@godswillogbonna9507 Год назад

Awesome tip. This is the exact technique I'm currently using and it's helping me learn SQL much more efficiently than when I began. Guys try it out, you'll be thankful.

@dhanushs6558 Год назад

Would u recommend this book for a beginner? I'm planning to learn SQL, i have only basic knowledge in coding (c and c++)..

@dhanushs6558 Год назад

@@varunnayyar3138 would u recommend this book for a beginner, I'm planning to study sql from basics, i have only basic knowledge in programming (c and c++), also would be really helpful if u give me tips on learning SQL, thank You

@adibanaazfatima7192 Год назад

Hi, I am from Non IT background and want to learn SQL. Do you suggest me to buy any one of these book or do I have to watch RU-vid videos to learn. Thank you

@mustafaaboyousif3273 2 года назад

Thanks for sharing your experience. As a person with a non-computer science background, it will be more helpful if I can find a reference that speaks about the different types of databases (relational, no SQL, graph, ...), their application types, and use cases.

@DevlogBill 2 года назад

Excellent advice and at the end I purchased the Practical SQL right after I watched your video, thank you so much for the wonderful advice. The other book by o’Reilly was ridiculous over priced in the US, $59.99. I’m halfway into chapter 1 and your correct the book is engaging. P.S. what is the difference between Machine Learning and Data Science? In reference to the study courses involved? Is the course for MachineLearning more of a challenge in comparison to Data Science? I’m guessing there is more math involved?

@johnfreeman5100 2 года назад

Thanks for the contribution that you make every day. Greetings from Spain.

@RAahmadi 2 года назад

Thank you so much for your advice !

@swindlesmccoop 2 года назад

i've never seen anybody with such dynamic and expressive eyebrows, you are amazing btw

@nikhilverma5205 2 года назад

Hello, thanks for this informative video. Can you also please make a video suggesting top five books for basic to intermediate computer science for non- computer science background guys? At least such should cover basic jargons also and background concepts of hardware, software, databases, how Internet works, etc. Thanks.

@rubayetalam8759 2 года назад

Second edition of practical sql will be released by February. Should I wait for that version?

@AhmedAlikhanUK 2 года назад

Any books you recommend for data modelling ? Transactional as well as dimensional ?

@conalmckeever9368 2 года назад

Hi Giles what is the make of the chair you sit on - looks very comfortable. Thanks

@firstname4337 2 года назад

1:26 through 1:33 -- OW ! I felt that -- nice, perfect condition ... then BEND FOLD CREASE !

@pradyumnberiwal1975 2 года назад

Which book to go for when you are intermediate at SQL?

@tingeling953 2 года назад

Hi I am starting to play around with spatial SQL, You don't happen to know of any good books going deeper into that?

@engihabit 2 года назад

Dear Klein would please suggest me reference or guideline's of probability and statistics for machine learning aspects.... thanks in advance

@kojimasan444 2 года назад

Can you share the best Python courses/books as of now? Are there any updates since your videos back in 2019?

@adityakrishna11 2 года назад

Hi Giles! I read Fundamentals of Database System by Elmasri Ramez, Navathe Shamkant, every now and then. And, as a part of my work, I require to be proficient in MySQL, MongoDB and perhaps Neo4J in the near future. Which books would you recommend on the subject? Thanks for this review by the way!

@manishsingh900 2 года назад

Have been waiting for this🥺🥺

@sergioramos3437 2 года назад

I feel like I have the basics down pretty good but I feel in a bit over my head at times with SQL ... Would these still be good to review ?

@n.ganadily8973 2 года назад

Please Review Grokking Books: - Algorithms for AI, Deep learning & Reinforcement learning

@pascal831 11 месяцев назад

Thank you sir!

@Sonyc902shots Год назад

Would you recommend SQL Cookbook 1st edition or 2nd edition?

@connorp2402 2 года назад

Just for reference O'Reilly learning SQL is £19.99 currently. (I'm on an Amazon prime account as they gave me a free 30 days again at the moment - whether that changes prices or not I'm not sure). Thanks for your Vid. Amazingly I just looked on your channel a few days ago for an SQL book review because I wasn't sure where to start and I ended up finding all the free resources from another of your videos instead! and then suddenly you've uploaded this!

@RussellSmith-nv2je 2 года назад

Thanks for another helpful video. Do you have any advanced SQL learning recommendations?

@LearnWithBahman 2 года назад

Awesome question

@maxd1744 2 года назад

Guess this is a blessing in disguise. I was searching for the English book you once recommended that wasn't about coding at all, but just amazingly written and great for learning English. Although I found this archived video, so guess I'm going to look at those sql books first... Do you remember in which video you recommended that book?

@gilesmcmullen 2 года назад

I don't remember which video it was in. I think I uploaded it in June. I do remember the author, as he's a favourite of mine: P. G. Wodehouse, anything by him. You could start with 'The Blandings Omnibus'.

@Brandon_letsgo 2 года назад

@@gilesmcmullen Please, remember the title of the book.

@maxd1744 2 года назад

@@gilesmcmullen thank you very much kind sir, the video was the one about a free couse about data science

@zaidouardi7901 2 года назад

Please can you do a review of : "Python Basics : A Practical Introduction to Python 3".

@andybecker5001 Год назад

Mastering oracle and sql plus by lex dehan is the best book out there for sql. Starts with database history and design

@Bryan-bh7cy 2 года назад

Hi, do I need to learn both book?

@jonl316 2 года назад

Great review.

@r.e.434 2 года назад

can you make a video on how you work with this books?

@tejeswarreddytadi3289 2 года назад

Hello Mate ,Thanks for your contribution.Learning a lot everyday ..Have a question, what is your take on SQL from now on and do you think is there any scope for next coming 10 - 15 years from learning SQL. I just want to start my carrier with this...thnq mate

@TheSilentNeon 2 года назад

Go ahead and learn it. It's not going away anytime soon. It is estimated to be around until 2050. Even if it doesn't the concepts you learn will serve you for a lifetime.

@varunnayyar3138 2 года назад

It has been around for 40 years, will be probably for 40 more. And you should not depend on just 1 skill. There will come times like such where you would need to learn an entirely new skill for some task. You can't complaint that it's not going to help you in the long run

@LuigiZambetti 2 года назад

How much do you spend in books every month? Seems you have a huge library.

@kenhaley4 2 года назад

What do these books say about database design--including table normalization, enforcement of referential integrity, and the use of triggers and functions to ensure data integrity? In my 40+ years of SQL database design and development, I've found that these are the most important aspects of a successful SQL database. (I have not looked at these, but most books I've seen are sorely lacking in these areas.)

@Atlas92936 2 года назад

I'm currently going through the book Learning SQL and in Chapter 2 there is a section on data types and it's proceeded by normalization, and thinking about how the content of your tables might affect how you design it, and an example. I haven't came across the other things you've mentioned, but if I do, I will certainly mention it in this thread.

@ayeshaali6462 Год назад

What book do you recommend?

@staynjohnson4221 Месяц назад

Kindly share which book/resource/way do you recommend?

@stanleyfloradin5415 Год назад

I don’t know which one to choose 😭😭 can somebody help me

@harshitaaggarwal4836 2 года назад

Pls recommend any book for c# and game development

@satyanarayana.n4133 2 месяца назад

Sir Thank You very much.

@Nik-yn4hd 2 года назад

Appreciate your effort"s

@email16v 2 года назад

A new version of no starch press version is in the works

@olusegunolakonipekun4729 2 года назад

Hello guys, what books can you recommend for someone just starting out in the data analytics field without prior background knowledge in computing. Also which is more acceptable btw mysql workbench and sql server management system. Thanks

@jeekakrishna Месяц назад

learn workbench and read from o reilly book

@rajattyagi610 2 года назад

Sir, what do you think about this book "SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL".

@The.gm63 2 года назад

Great book for beginners.

@jeekakrishna Месяц назад

i just love your videos for no reason...sometimes it is hard to get hands on these in my country India

@techstack2765 2 года назад

Sir could u share some good free resources on how to be a power BI developer , tableau developer , spark developer?

@rbharij7619 2 года назад

Thanks Giles, very helpful - will certainly look into the recommendations. For a complete beginner, would you recommend MySQL or PostgreSQL? (purely from a learning perspective)

@The.gm63 2 года назад

Mysql

@rbharij7619 2 года назад

@@The.gm63 Thanks!

@varunnayyar3138 2 года назад

MySQL without a doubt

@varunnayyar3138 2 года назад

@@rbharij7619 even companies use MySQL workbench

@Kicsa 2 года назад

Your videos inspire, but I wish I was more motivated to go head on.

@darlenpenaponceano3094 Месяц назад

is this book a good option to learn SQL for beginners?

@Dr.Munshi-Naser 2 года назад

What is the best book to learn R basics for beginner level...Sir???

@chrlemes 2 года назад

If you do allow me, I suggest "Hands-On Programming with R", by Garrett Grolemund, followed by "R for Data Science ", by Hadley Wickham &Garrett Grolemund.

@joshuddin897 2 года назад

I have the alain Beaulieu sql book

@LuigiZambetti 2 года назад

Never books on C#?

@rafaelv.valadares2721 Год назад

No doubt the first one is the best one.

@elobservador7155 2 года назад

Good video, could you please add subtitle the videos, sería de mucha ayuda. +1

@gradientO 2 года назад

I don't know, I have both downloaded 🏴‍☠️

@-vis-2492 2 года назад

if you know, you know ;)

@user-ok3gj9dm6q 3 месяца назад

I request arden university berlin for my application sent and no feedback up to now please get me into RU-vid

@DarkHorse2305 2 года назад

Thanks Giles! Another great video. Have you looked into SQL Cookbooks from O'Reilly. I have personally found it quite useful. Would be great to know your thoughts on it :) Keep up the good work. Cheers!

@DarkHorse2305 2 года назад

SQL Cookbook by Anthony Molinaro is the one I meant

@gilesmcmullen 2 года назад

That one was part of the Humble Bundle I just bought and made a vid about a couple of days ago. I haven't started reading it yet!

@DarkHorse2305 2 года назад

@@gilesmcmullen Oh okay. Looking forward to your review then. BTW I did pick up practical sql based on your suggestion. Loving it so far 🙂

@sunithadevi667 2 года назад

PDF file is available no need to buy in Amazon

@ozoyaohilebo7455 2 года назад

Where can I get the pdf file

@user-ok3gj9dm6q 3 месяца назад

arden university berlin studying logistics management supply chain management and logistics

@manavkumar500 2 года назад

make a video, about ur accent. plzz sir

@user-ok3gj9dm6q 3 месяца назад

I request arden university berlin for my application sent and no feedback up to now please get me into RU-vid logistics and supply chain and management

@TheNotes03 Год назад

practical SQL is book not for beginners its more focus on intermediate queries. why it has very small section editing and modifying database a very critical requirements on handling database. Most of the chapter failed to explain why you would do this queries its like he is doing for fun or to showoff complex queries. The samples most you can't relate. its not for beginners.

@fozemohammed9485 10 месяцев назад

10x

@manavkumar500 2 года назад

which Accent u speak . help me

@9asyhd9sahgdsahd59 2 года назад

bree-ISH

@johnsnow007 Год назад

A Bot of wat...

@keithprice1950 2 года назад

You lost me at PostJizz

@jakepyrett1715 2 года назад

The hundred page ML book I bought from your reco has been trash. The decision tree details use ID3 as optimization instead of entropy/information gain. The nearest neighbors section is literally half a page. The linear regression part does not use theta notation in the gradient descent for optimization parameters. It does not solve closed form / normal equation either. I'm taking the online ML course thru Carnegie Mellon U and Everytime I pick up the book. It is not as good as my class notes and is collecting dust.

@The.gm63 2 года назад

Sorry to hear

@HARSHRAJ-2023 2 года назад

I think SQL Cookbook is better than Learning SQL.

@vikasmaurya5199 2 года назад

True

@jimbocho660 2 года назад

SQL Cookbook is more of a second SQL book though, isn't it?

@user-ok3gj9dm6q 3 месяца назад

I request arden university berlin for my application sent and no feedback up to now please get me into RU-vid

@user-ok3gj9dm6q 3 месяца назад

I request arden university berlin for my application sent and no feedback up to now please get me into RU-vid logistics and supply chain and management