Tilt-shift simply means the camera is somehow being moved or tilted, often for selective focus. I’ll let Wikipedia give you a more detailed explanation. The result is that a photo will look like a miniature and they can look really cool.
Want some examples? Smashing Magazine posted 50 Beautiful Examples of Tilt-Shift Photography. Look over the examples and I think you’ll be impressed.