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
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. :)
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.
@@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
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 TH-cam videos to learn. Thank you
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.)
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.
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.
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?
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.
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?
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'.
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!
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
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.
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
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!
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.
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
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)
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.
I request arden university berlin for my application sent and no feedback up to now please get me into TH-cam logistics and supply chain and management
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!
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.
I request arden university berlin for my application sent and no feedback up to now please get me into TH-cam logistics and supply chain and management
![เกิดใหม่ทั้งทีก็เป็นสไลม์ไปซะแล้ว ซีซั่น 3 - ตอนที่ 69 [ซับไทย]](http://i.ytimg.com/vi/QuodflInQT8/mqdefault.jpg)
![🎤 ไปกันต่อออ! จับฉลากร้องเพลง x P’ #XXSIVK [EP.2] (1/2) เพลงของใครจึ้งสุดน้าา 💓🎤 #MXFRUIT](http://i.ytimg.com/vi/mLI_K0sAS4o/mqdefault.jpg)
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
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. :)
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
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.
Would u recommend this book for a beginner? I'm planning to learn SQL, i have only basic knowledge in coding (c and c++)..
@@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
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 TH-cam videos to learn.
Thank you
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.)
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.
What book do you recommend?
Kindly share which book/resource/way do you recommend?
i've never seen anybody with such dynamic and expressive eyebrows, you are amazing btw
Which book to go for when you are intermediate at SQL?
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.
Please Review Grokking Books: - Algorithms for AI, Deep learning & Reinforcement learning
Thanks for another helpful video. Do you have any advanced SQL learning recommendations?
Awesome question
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?
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.
1:26 through 1:33 -- OW ! I felt that --
nice, perfect condition ... then BEND FOLD CREASE !
Second edition of practical sql will be released by February. Should I wait for that version?
Dear Klein would please suggest me reference or guideline's of probability and statistics for machine learning aspects.... thanks in advance
Thanks for the contribution that you make every day. Greetings from Spain.
Sir, what do you think about this book "SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL".
Great book for beginners.
Mastering oracle and sql plus by lex dehan is the best book out there for sql. Starts with database history and design
Any books you recommend for data modelling ? Transactional as well as dimensional ?
Thank you so much for your advice !
I don’t know which one to choose 😭😭 can somebody help me
Hi Giles what is the make of the chair you sit on - looks very comfortable. Thanks
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?
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'.
@@gilesmcmullen Please, remember the title of the book.
@@gilesmcmullen thank you very much kind sir, the video was the one about a free couse about data science
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!
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
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.
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
Thank you sir!
Would you recommend SQL Cookbook 1st edition or 2nd edition?
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!
Can you share the best Python courses/books as of now? Are there any updates since your videos back in 2019?
Hi I am starting to play around with spatial SQL, You don't happen to know of any good books going deeper into that?
is this book a good option to learn SQL for beginners?
i just love your videos for no reason...sometimes it is hard to get hands on these in my country India
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 ?
A new version of no starch press version is in the works
Have been waiting for this🥺🥺
Great review.
Please can you do a review of :
"Python Basics : A Practical Introduction to Python 3".
Appreciate your effort"s
Sir Thank You very much.
can you make a video on how you work with this books?
Hi, do I need to learn both book?
How much do you spend in books every month? Seems you have a huge library.
Pls recommend any book for c# and game development
What is the best book to learn R basics for beginner level...Sir???
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.
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
learn workbench and read from o reilly book
Sir could u share some good free resources on how to be a power BI developer , tableau developer , spark developer?
No doubt the first one is the best one.
Never books on C#?
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)
Mysql
@@Eliel10268 Thanks!
MySQL without a doubt
@@rbharij7619 even companies use MySQL workbench
I don't know, I have both downloaded 🏴☠️
if you know, you know ;)
PDF file is available no need to buy in Amazon
Where can I get the pdf file
arden university berlin studying logistics management supply chain management and logistics
I have the alain Beaulieu sql book
Your videos inspire, but I wish I was more motivated to go head on.
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.
I request arden university berlin for my application sent and no feedback up to now please get me into TH-cam
10x
I request arden university berlin for my application sent and no feedback up to now please get me into TH-cam logistics and supply chain and management
Good video, could you please add subtitle the videos, sería de mucha ayuda. +1
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!
SQL Cookbook by Anthony Molinaro is the one I meant
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!
@@gilesmcmullen Oh okay. Looking forward to your review then. BTW I did pick up practical sql based on your suggestion. Loving it so far 🙂
You lost me at PostJizz
make a video, about ur accent.
plzz sir
which Accent u speak .
help me
bree-ISH
A Bot of wat...
I think SQL Cookbook is better than Learning SQL.
True
SQL Cookbook is more of a second SQL book though, isn't it?
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.
Sorry to hear
I request arden university berlin for my application sent and no feedback up to now please get me into TH-cam
I request arden university berlin for my application sent and no feedback up to now please get me into TH-cam logistics and supply chain and management