HN Explorer

Ask HN: How to Learn SQL?

4 points by yanis_t ↗ HN
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

[ 8.4 ms ] story [ 19.8 ms ] thread
frompdx
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.
0x54MUR41
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/