I came across a site, it's actually for a product, but to sell it, somebody made a really cool flash tutorial which explains the most common types of site attacks. It's a great read for security noobs, explains things in a nice and simple way.
http://www.sanctuminc.com/demo/hacking_demo_v1200.html
Enjoy.