Introduction

Completed

In this module, you will learn about some of the language capabilities that are available to create data warehouses in Azure Synapse Analytics.

In this module, you will:

  • Learn about the development tools for Synapse Analytics
  • Understand T-SQL language capabilities for Synapse Analytics
  • Work with Windowing functions
  • Work with approximate execution
  • Work with JSON data in SQLPools
  • Encapsulate T-SQL logic with Stored procedures

Prerequisites

Before taking this module, it is recommended that the student is able to:

  • Log into the Azure portal
  • Create a Synapse Analytics Workspace
  • Create an Azure Synapse Analytics SQL Pool