First, as an example of engaging use of machinima and also an edifiying and entertaining tutorial on the camera:
Slurl to AngryBeth's machinima tv studio with camera switcher (25 L$). You'll need basic prim movement and cam skills to use this.
Building tools on the SL wiki
Script Me, please! 3greenseggs.com autoscript generator. But if you plan on doing any real building or using scripts, you are going to have to learn the basics of lsl, Linden Scripting Language, and how scripts work, so you can figure out what is going wrong when it does, or how to tweak a script you get from a generator, from the wiki, or another source. Simon Kline runs terrific classes in Second Life (see: Kline Labs), and there are other ways to learn as well.