Domain resolution doesn’t have anything to do with XHTML or CSS or any other web language.

If you want a domain name such as mysite.com, you’re going to have to pay for it from a domain registry service, such as

http://www.internic.ca/

Otherwise you have to use a subdomain (mysite.wordpress.com).

There are URL redirection services, such as
http://kickme.to

but those are also subdomains and are mainly used for simplicity. A wordpress subdomain is pretty simple as it is.

You must know PHP!! You don’t need to know SQL at all.

To set up wordpress directly to a domain name (mysite.com), I guess you’ll have to upload all of your wordpress files in your home directory. In other words, DO NOT put the wordpress files into their own folder. It’ll be a little crowded, but it’ll get you the results you want.

But if you don’t mind loading your wordpress in a “mysite.com/wordpress” format, then upload your wordpress files into a new directory called wordpress, for instance.

In the wordpress files, there’s index.php. You will have to make this index file, your index file. You have to edit it and customize it to look exactly the way you want your front page to look.
That’s why you need to know PHP! It’s really simple actually and won’t take long to understand, especially if you have experience with say, C++, or Java, or even Javascript.

But even without that, you should understand! Tizag.com has an excellent PHP tutorial that covers all the basic knowledge.