<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

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.

Serverless SQL in Azure Synapse Analytics
  • Course Info
  • Instructor
  • What to know beforehand
  • System Requirements

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.

Course Outline ( Free Preview)

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 of training
  • 13 Modules
  • * Access on mobile and browser
  • Certificate of Completion