Introduction to Azure Synapse Analytics

This course is a quick introduction to Microsoft’s Azure Synapse Analytics. It covers serverless SQL pools, dedicated SQL pools, Spark pools, and Synapse Pipelines. It does not cover more advanced topics, such as optimization and security, because these topics will be covered in another course.

Learning Objectives

  • Create and use serverless SQL pools, dedicated SQL pools, Spark pools, and Synapse Pipelines

Intended Audience

  • Anyone who would like to learn the basics of using Azure Synapse Analytics


  • Experience with databases
  • Experience with SQL (not mandatory)
  • A Microsoft Azure account is recommended if you want to do the demos yourself (sign up for a free trial at if you don’t have an account)



Welcome to “Introduction to Azure Synapse Analytics”. My name’s Guy Hummel, and I’m a Microsoft Certified Azure Expert. If you have any questions, feel free to connect with me on LinkedIn and send me a message, or send an email to

In this course, I’ll first give you an overview of what you can do with Synapse Analytics. Then I’ll give you some demonstrations of how to use it. I’m not going to cover more advanced topics, such as optimization and security. We’re going to cover those in another course.

To get the most from this course, you should have some experience with databases. It would also be helpful to have some experience with SQL, although that’s not mandatory. If you have your own Azure account, then you can do the examples yourself, too, but I’ll warn you that if you’re not careful, you’ll end up with an expensive bill from Microsoft. So use caution if you’re going to try these examples yourself.

We’d love to get your feedback on this course, so please give it a rating when you’re finished. Thanks!

About the Author
Learning Paths

Guy launched his first training website in 1995 and he's been helping people learn IT technologies ever since. He has been a sysadmin, instructor, sales engineer, IT manager, and entrepreneur. In his most recent venture, he founded and led a cloud-based training infrastructure company that provided virtual labs for some of the largest software vendors in the world. Guy’s passion is making complex technology easy to understand. His activities outside of work have included riding an elephant and skydiving (although not at the same time).