Ask HN: How to Learn SQL?

4 pointsby yanis_t6 yıl önce4 comments

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

0x54MUR416 yıl önce

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/

frompdx6 yıl önce

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.

Slightofhand6 yıl önce

I had this on my bookmarks but never used them:

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

yanis_t6 yıl önce

That's awesome! Thanks!