<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Introduction to Azure Synapse Analytics

This course covers deployment, data querying with serverless and dedicated SQL pools, ETL with pipelines and data flows, multi-language Notebooks, and more in a unified environment.

Introduction to Azure Synapse Analytics
  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

Azure Synapse Analytics is a limitless analytics service that brings together data integration, enterprise data warehousing, and big data analytics into a unified enviornment. In this course you will start with the basics of how to deploy an Azure Synapse Workspace in the Azure portal, look at the options for querying data within Synapse with serverless SQL pools and dedicated SQL pools, perform ETL with pipelines and data flows, work with multiple code languages in Notebooks, and connect it all together with Power BI. Synapse is a vast and powerful tool and this is the perfect introduction for where to begin.

Course Outline ( Free Preview)

What you need to get started

Module 00 - Environment Setup 12 min.

Module 01A - Introduction (Introduction to ASA Services)

Module 01B - Introduction (Why Synapse Analytics)

Module 01C - Introduction (Provisioning ASA) 18 min.

Module 02A - ADLS (Provisioning ADLS) 21 min.

Module 02B - ADLS (Bring Your Own Data) 9 min.

Module 03 - Serverless - SQL On-Demand 20 min.

Module 04 - SQL Pools 24 min.

Module 05A - ETL (Introduction to ETL in Synapse) 15 min.

Module 05B - ETL (Creating Your First Pipeline) 24 min.

Module 06A - Notebooks (Apache Spark Pools) 25 min.

Module 06B - Notebooks (Introduction to Notebooks) 16 min.

Module 07A - Power BI (Connecting from Power BI Desktop) 9 min.

Module 07B - Power BI (Connecting to Power BI Workspaces) 7 min.

This course includes:

  • 3+ hours of training
  • 15 Modules
  • * Access on mobile and browser
  • Certificate of Completion