Converting to Drupal

I am brand new to Drupal and have been designing a website for the past 6 months in Photoshop. I am looking for help getting started turning my design into a Drupal site. Videos, Tutorials, anything... Everything I have found so far has been extremely vague. Thank you all for the help. Here is a link to the Homepage design if it helps!

I'm hoping someone can help me or point me in the right direction with regards to a few issues I'm having whilst developing a Drupal website!

Firstly, I'm becoming extremely confused with pages, taxonomy, menus and breadcrumbs. To me, they seem to be very disconnected and hard to organise content with.

Hi,
I’m trying to convert one of my sites into a Drupal site. The site is a travel site and has a lot of data on there, so I’m trying to convert my database tables to custom node types, but my tables are large, I have about 30 different tables with a total of about 200+ fields.

If I would just convert all the fields to CCK fields I would end up with a database with 400 to 500 tables, I don’t like that, so I’m trying to create custom node types that save to custom tables.

When converting to drupal, are there any issues with if a site has a static or dynamic IP address? I wouldn't think it mattered, but never hurts to ask. I didn't see anything in the documentation.

Thanks in advance.

I have a music web site with a couple of hundred pages in Joomla. I have converted it over to Drupal. One of the remaining issues though is I used the Joomla plugin called "ReReplacer" to replace out text while the page was being build. So, I could have in the body of articles have {Musician Name} and that would get replaced to
a href="wiki.web.site/Musician_Name" Musician Name /a

by using a lookup table built in the admin. Is there a similar module in Drupal?

Just installed Drupal, added a handful of content types, and added a lot of 'new fields' to each (text, text areas, images, etc.). Next I need to completely redesign the display/view of each of these 'content types'. I do see there are a few modules to do this, but what is the best method? How do I do this within Drupal naively?

I can do whatever needs to be done in HTML, CSS, and jQuery... I just want the 'best practice' for Drupal.

Thanks!