The Houdini 9 demo reel is now available here, you can as well download it directly following this link Download Video – 37MB [3.5 Min.] The is a great demo reel what Houdini 9 can do. I liked the fluid effects.
Houdini 9 workflow videos are available here.
You can get Houdini 9 beta here (different OS are supported). Houndini 9 video tutorials can be found in the H9 blog. If you have question on the Houndini 9 beta software you may find the Houdini Installation FAQ or Houdini 9 Forum helpful.