I just stumbled across some excellent introductory videos which Steve Marx did while he was at Microsoft. They provide a short explanation behind some of the Azure concepts including:

What is Windows Azure?

What is SQL Azure?

What are the Access Control and Service Bus?

What is the Windows Azure Platform?

Check them out.