Really good introduction to some of the more "modern" features: https://modern-sql.com/