Ask HN: How to Learn SQL?

Posted by yanis_t on Friday October 16, 2020 @11:07AM
from the ask-hn dept.

Hey guys! I have some understanding on how to write SQL queries and add some indexes when they are slow, but I'd like to learn deeper.

Is there any resources, books, and especially practical exercises you could recommend?

( 4 comments | 4 points | on HN )

Re:Ask HN: How to Learn SQL? by 0x54MUR41 on Monday October 19, 2020 @11:49AM (#24827457)

Recently, somebody shared resources to start learning deep learning [0]. It includes learning SQL. These are some recommendations:

1. Book "Head First SQL: Your Brain on SQL - A Learner's Guide" by Lynn Beighley

2. Book "Learning SQL: Generate, Manipulate, and Retrieve Data" by Alan Beaulieu

3. "Learn SQL" course from Codecademy.

You can see the full recommendation here [1].

[0]: https://news.ycombinator.com/item?id=24817630

[1]: https://awesomedataengineering.com/

[ Parent | on HN ]

Re:Ask HN: How to Learn SQL? by frompdx on Friday October 16, 2020 @07:40PM (#24806086)

Take a look at "Database Modeling and Design: Logical Design". It covers planning relational databases in depth. I found it useful when I was first learning about SQL/relational databases.

[ Parent | on HN ]

Re:Ask HN: How to Learn SQL? by Slightofhand on Friday October 16, 2020 @08:23PM (#24806361)

I had this on my bookmarks but never used them:

https://news.ycombinator.com/item?id=18335723

[ Parent | on HN ]

Re:Ask HN: How to Learn SQL? by yanis_t on Sunday October 18, 2020 @11:11AM (#24818402)

That's awesome! Thanks!

[ Parent | on HN ]