CSS is not HTML. CSS is for style sheets that determine the style of HTML elements (e.g background color, font size, alignment, etc)
Javascript is not required for most simple websites. Also, when not used very effectively,
JS can make a website look bad. So use Javascript only when there is a definite purpose. Not
just to use it.
I don't know C#. But you should read up about "server side scripting" and "client side scripting". You should know what both are and the difference between the two. ASP.NET is a server side script. PHP is also a server side script (arguably better). To connect and use a SQL database, you will need to server side scripting not client side scripting (
JS is client side).
Client side is something that is executed by the browser and server side is something that is executed by the server. You normally want server-side scripts when dealing with editing files/using databases, etc.
When you read up about ASP.NET or PHP, you will understand how they work a little better.
I would recommend PHP for many reasons: better hosts (especially if you want to use a free host for a small website), more popular at YC (by far), PHP is open-source (that shouldn't be too big of an issue if you aren't particularly interested in open-source, also this does
not mean that you cannot make closed source PHP scripts or open-sourced ASP scripts).
There is no such thing as a "correct" website. Definitely use CSS as far as possible (instead of using HTML properties).
Ensure that your site validates (
The W3C Markup Validation Service).
Make your site reasonably cross-browser compatible (if you don't have many browsers to test on
Check Browser Compatibility, Cross Platform Browser Test - Browsershots is a good place to do that. Firefox (2, 3), Opera (9), IE (5,6 and 7) should be more than enough.
Make a website that is easy to navigate through. Don't get anyone "stuck" on a page. Make it easy to find their way "back" and "around" your website.
Test your website on your computer first. But don't use absolute paths (e.g "C:\My Website\" or "/home/username/website/" etc) use relative paths (e.g "index.htm" or "http://www.youngcoders.com/images/head.png" etc) so that the paths remain the same when uploaded to a server.
You will need to buy a domain ("example.com"), unless you don't mind a free domain ("example.co.cc" or "example.ath.cx"). These aren't easy to setup if you haven't seen them before, but I would suggest trying to figure it out yourself before asking for help, because you will really learn that way.
Yes, you should not copy other people's logo and "look" (i.e. layout and style). Be original - it's fun and legal! You won't have a great site with your first try, but that's what learning is about!
Best of luck!
Umang