Understand data warehouse developer features of Azure Synapse Analytics

Intermediate
Data Engineer
Azure Synapse Analytics

Learn about the language capabilities that are available to create data warehouses in Azure Synapse Analytics.

Learning objectives

In this module, you will:

  • Explore the development tools for Azure Synapse Analytics
  • Understand Transact-SQL language capabilities for Azure Synapse Analytics
  • Work with Windowing functions
  • Work with approximate execution
  • Work with JSON data in SQL Pools
  • Encapsulate Transact-SQL logic with stored procedures

Prerequisites

  • Before taking this module, it is recommended that you complete Data Fundamentals.