Yes, I've coded more dynamic sites than I care to remember.
I'd ask you one question before we even try to go any further:
Do you actually need dynamic content for processes that you cannot do with standard static HTML or XHTML pages and form handlers ?
The reason I ask is that you've opened an enormous can of worms and there is no short and easy road to doing what you want to do.
I'd also mention that if your host supports ASP, PHP and MySQL you stick with PHP and MySQL. The ASP will be Chilisoft and let's not get started on that subject when you can use PHP.
Macromedia have some sample applications that demionstrate using Dreamweaver for dynamic content: click here
There are loads of links and a couple of books I could suggest but, I'd ask you to answer my question above first.
A full tutorial on data driven sites is way beyond the scope of this forum, but I will certainly help with specifics.