Simon Wheatley has a really nice slidedeck that dissects WordPress URLs and shows you what they really mean, do, and how to play with them.
The “URL to query” concepts in WordPress are really powerful to fully understand.
You can check out Simon’s slides on his blog post, and there’s an accompanying presentation on WordPress.tv from WordCamp London.