In this Houdini course, Rich Nosworthy creates an intricate and detailed flower shot from start to finish, 100% in Houdini. This is based on techniques used for full studio and client work, and will demonstrate a whole bunch of workflow tips for setting up your scenes efficiently.
With over 8 hours of training, Rich covers modelling, animation, instanced geometry and alignment, VEX programming, Proxies for efficient workflow, and full lighting, camera, shaders and rendering all within Redshift Renderer. Rich also covers more advanced topics such as quaternion functions and matrix transformations, which while they are complex topics, can be very useful with a few different techniques he'll go over.
This covers a huge amount of knowledge all within SOPS to help you push you Houdini skills to the next level.
While this isn't a complete beginners course, there's a range of topics that should hopefully provide insight for everyone.
Homepage

https://helloluxx.com/products/training/learn-houdini-in-bloom/