Doing this type of thing with a database-driven site is relatively straightforward, but don't expect to be able to do it overnight. You have a relatively long learning path ahead.
Dreamweaver supports three server-side technologies: ASP, ColdFusion, and PHP. Forget about ASP. Microsoft stopped developing it 10 years ago. Although it's still widely used, it will eventually die out, facing you with the problem of moving to another server-side technology. ColdFusion and PHP are both powerful, but PHP is by far the more widely used. Note: I'm biased because I write books about Dreamweaver and PHP (for more details, see http://foundationphp.com/dwcs4/).
To develop with CF or PHP, you will need to create a development environment. There are instructions for both languages in the Adobe Developer Connection:
There's also a tutorial on creating your first database-driven website at http://www.adobe.com/devnet/dreamweaver/articles/first_dynamic_site_pt1.html. In theory, you should be able to follow the tutorial using either ColdFusion or PHP, but all the code in the examples is exclusively PHP.
Once you have gained experience with working with the server-side technology of your choice, you might want to look at Cartweaver, a commercial extension that builds shopping carts in Dreamweaver. There are also free shopping cart solutions. OSCommerce is one that many people recommend. It runs on PHP only.
For help with database-driven websites, please ask questions in the Dreamweaver Application Development forum.
Thank you so much, this was the exact response I was looking for. I did the Jon Varese tutorial to learn mostly html and CSS, I find that the tutorials here are extremely comprehensive. I'm sure these links will show me all I need to see.
Keep up the good work and thanks again.