Through out the video series, it's mentioned that at the end you will show how to transfer the local development site to a hosted server, but the series ends without showing this process

To which video series are you referring?

In outline form, this is what you need to do:

Prepare your database:

1. Add site aliases for the host URL using the Admin, Site Settings page
2. On the same page, set the default alias to the URL of the hosted site.
3. Set the redirection mode to none
4. Using SQL Server Management Studio, make a backup copy of the database.

Prepare your web directory:

1. Make a copy of the web directory and all of the files it contains.
2. In the copy, edit web.config and edit the two configuration strings to match the server, database, user, and password that will be required on the hosted site. You should be able to get these from your host.
3. ZIP up the copy of the web directory.

On the host site (this will vary from host to host, so get your host's help or directions):

1. Upload the database backup and restore it to the host database.
2 Upload the sip file containing the web directory, and extract it into the hosted web directory. Make sure that the files are in the correct directories -- the files in the root of you local installation should be in the root directory on your host.

The should be it. If your website is configured on the host, you should be able to browse to it.

Before you start, you might want to put a simple index.htm file in the host's rood web directory and make sure that you can browse to it. When you can, you can safely upload your site.

Many hosts will provide quite a lot of help in doing this. For example, if you happened to be hosting with PowerDNN, they provide nice instructions, show you how to configures things and, if you've uploaded your database backup and web directory zip file, just file a ticket and they'll do all the work for you ... usually in less than an your!