Serverless SQL in Azure Synapse Analytics

Master serverless SQL querying in Azure Synapse Analytics! This course covers setup, creating external tables/views, retrieving data from the data lake, and performing ETL using serverless SQL.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

Master serverless SQL querying in Azure Synapse Analytics! This course covers setup, creating external tables/views, retrieving data from the data lake, and performing ETL using serverless SQL.

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Description

The Serverless SQL in Synapse Analytics course is designed to teach students how to use serverless SQL to query data in Azure Synapse Analytics. The course covers topics such as setting up a serverless SQL queries, creating external tables and views, and writing SQL queries to retrieve data from files in the data lake. Students will also learn how to use serverless SQL to perform ETL with data in Synapse Analytics. The course provides hands-on experience through practical exercises and labs. Upon completion of the course, students will have a solid understanding of how to use serverless SQL in Synapse Analytics to analyze and process large amounts of data efficiently and effectively.

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

What you need to get started

Module 00 - Course Introduction 9 min.

Module 01 - What is Serverless SQL? 12 min.

Module 02 - Cost & Compute 12 min.

Module 03 - Querying with Serverless 35 min.

Module 04 - Connecting to SSMS 6 min.

Module 05 - External Tables 20 min.

Module 06 - CETAS (Create External Table As Select) 10 min.

Module 07 - Serverless Views 9 min.

Module 08 - Serverless Dataset 12 min.

Module 09 - Using Serverless SQL in ETL 11 min.

Module 10 - Using Serverless SQL in Power BI 6 min.

Wrap-up 2 min.

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Austin Libal

Data Engineer (Azure) Trainer

Austin is a Jacksonville native who graduated from The Baptist College of Florida in 2012. He previously worked as a manager in the retail service industry. He enjoys spending time with his wife and two kids. His primary focus at Pragmatic Works is on Azure Synapse Analytics and teaching the best practices for data integration, enterprise data warehousing, and big data analytics. He also enjoys helping customers learn the ins and outs of Power BI and showing people new ways to grow their business with the Power Platform.

Learn More

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

**Prerequisites** It is recommended that students first watch the Introduction to Azure Synapse Analytics course before starting this course

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion