Hi, I am completely new to web development but have had lots of experience with programming in C++, Java, C#, and various scripting languages like Python and bash. I was wondering if you had suggestions for a good GUI for web development that will let me incorporate SQL queries into my website (can't seem to do this with Dreamweaver or iWeb...). I've been working in Notepad and it's driving me nuts... for a complete beginner, I don't think Notepad is the way to go.

Also, might anyone recommend some teaching material, preferably free and available online? There's a lot of old tutorials that use deprecated code (even some modern tutorials use deprecated code...) so it isn't trivial to find a good source. I'd appreciate one that's targeted at programmers rather than complete computer newbies.