I found the jooq blog (not affiliated) excellent for understanding the concepts of SQL properly.

This article is a great starting point:

https://blog.jooq.org/2016/03/17/10-easy-steps-to-a-complete...

there are many other articles worth reading on there