NEED HELP? TALK TO AN EXPERT (904) 638-5743

Introduction to Azure Synapse Analytics

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • The basics of how to deploy an Azure Synapse Workspace in the Azure portal
  • 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
  • Connect it all together with Power BI
This course includes:

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.

Outline

 

Module 00 | Setup (Environment Setup)

 

Module 01 | Introduction

 

Module 01A | Introduction (Introduction to ASA Services)

 

Module 01B | Introduction (Why Synapse Analytics)

 

Module 01C | Introduction (Provisioning ASA)

 

Module 02 | ADLS

 

Module 02A | ADLS (Provisioning ADLS)

 

Module 02B | ADLS (Bring Your Own Data)

 

Module 03 | Serverless – SQL On-Demand

 

Module 04 | SQL Pools

 

Module 05 | ETL

 

Module 05A | ETL (Introduction to ETL in Synapse)

 

Module 05B | ETL (Creating Your First Pipeline)

 

Module 06 | Notebooks

 

Module 06A | Notebooks (Apache Spark Pools)

 

Module 06B | Notebooks (Introduction to Notebooks))

 

Module 07 | Power BI

 

Module 07A | Power BI (Connecting from Power BI Desktop)

 

Module 07B | Power BI (Connecting to Power BI Workspaces)

Instructor

MITCHELL PEARSON

Training Content Manager
Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.

 

Click Here To Learn More About Mitchell And See Certifications And Reviews

System Requirements

  • Microsoft Azure Account (Paid or Trial)

What to Know Before Class

  • This course assumes you have no or minimal prior knowledge of Azure.
REVIEWS

Pending reviews - check back later

Pending reviews - check back later

Pending reviews - check back later

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.

 

Bonus:

• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!