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.<p>Is there any resources, books, and especially practical exercises you could recommend?
Recently, somebody shared resources to start learning deep learning [0]. It includes learning SQL. These are some recommendations:<p>1. Book "Head First SQL: Your Brain on SQL - A Learner's Guide" by Lynn Beighley<p>2. Book "Learning SQL: Generate, Manipulate, and Retrieve Data" by Alan Beaulieu<p>3. "Learn SQL" course from Codecademy.<p>You can see the full recommendation here [1].<p>[0]: <a href="https://news.ycombinator.com/item?id=24817630" rel="nofollow">https://news.ycombinator.com/item?id=24817630</a><p>[1]: <a href="https://awesomedataengineering.com/" rel="nofollow">https://awesomedataengineering.com/</a>
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:<p><a href="https://news.ycombinator.com/item?id=18335723" rel="nofollow">https://news.ycombinator.com/item?id=18335723</a>