How to Learn SQL?

Question

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?

0x54MUR41 · Accepted Answer

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/

frompdx · Answer

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.

Slightofhand · Answer

I had this on my bookmarks but never used them:https://news.ycombinator.com/item?id=18335723

How to Learn SQL?

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?

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.

I had this on my bookmarks but never used them:
https://news.ycombinator.com/item?id=18335723