You have a lot of questions in here.  For starters if you want to learn about developing modules I would go to dotnetnuke.adefwebserver.com and look at the tutorials available there.  Otherwise, you might look at my book "Professional DotNetNuke Module Programming" as another reference.

For skinning there are a number of websites with tutorials.

Lastly for the pages, all items are stored in the database.