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.