This video shows you how the Celestial Sphere works.

This next video is on Stargazing the Cosmos: How the Sky Works

Here is a link to Google Sky: http://www.google.com/sky/
Here is a link to Sky-Map.org: http://www.sky-map.org/