Level:<p>From CS background,Expert in C/C++, efficient with relational DBs, great with Unix/Linux, some familiarity with Python, familiar with web protocols, new to JavaScript, CSS and all fancy stuff!<p>Target: To be able to develop a website with lovely UI and scalable/optimized back-end.No decisions made about technologies.<p>Million ton question: <i>where to start? </i>
First, realize that web dev and web design are two different (although connected) fields.<p>You should have very little trouble with web dev, based on your coding and database background.<p>To get better at design, read and practice! Alistapart.com, csszengarden.com, etc., are all great places to find inspiration. 37 signals is another.<p>Finally, don't spend too much thought on the "scalable/optimized back-end". The only time you'll ever need to worry about that is if you're successful, which will depend primarily on your idea, execution, speed, etc., and much less on if your system scales.<p>So to sum: read design journals. Look for inspiration (include real life). Practice your basic frontend skills. Don't waste brain cycles optimizing.
If you know some Python, get Django and start playing with it. Worry about 'scalable' last, and keep 'beautiful' as an ongoing goal that you work on over time.