I really like the books and videos at sitepoint.com. They have books on design and programming. I use PHP and MySQL and that allows me to build sites that pull data from a database - which you need to be able to do if you want to deal with lots of information like the sites you mentioned. PHP is a very easy to learn scripting language.