I don't want to advertise and am not affiliated in any way. For a first cursory understanding I do recommend the 'Mode Analytics' tutorial [0] to juniors interested in starting sql.

[0]: https://mode.com/sql-tutorial/introduction-to-sql/