If you have the site defined and the connection to the db created you should be able to add in the recordset to select the locations from your database table. Unless you have a specific advanced query in mind that you would like to use for your recordset then you should use the simple view. Using the simple view you can just specify the table that has the addresses or coordinates in it. You can test the query out with the test button to confirm the results.
Once your recordset has been crafted you can specify this recordset in the Pro Maps wizard. You then use the lightning bolt icons to select the columns from your table that hold the corresponding value.
The document that I was referring to was Creating your database connection in Dreamweaver, it is on the page linked to, it is the last entry in the list.