Azure Synapse Analytics Training

In this course, the students will design, deploy, and manage both an Azure Synapse Analytics Data Warehouse Instance and an Azure Synapse Analytics Workspace Instance. They will also load and analyse massive quantities of data in Synapse SQL Pools using optimal techniques for massively parallel processing. In addition, students will issue queries and visualise data using Synapse Studio. Finally, students will manage compute resources, including scaling and pausing compute.

Attendees should be comfortable using, and navigating to and around, Azure Portal, especially the All Resources View. Attendees should also know how to use Microsoft SQL Server Management Studio.

Prior to attending, it would be helpful for attendees to practise using Azure Portal and Microsoft SQL Server Management Studio.

Azure Synapse Analytics Training Delivery Methods

• After-course instructor coaching benefit
• Hands-on labs included
• Customer Satisfaction Guarantee

Azure Synapse Analytics Training Course Benefits

• Design, deploy and manage an Azure Synapse Analytics Data Warehouse
• Load data into Synapse SQL Pools using the Transact-SQL COPY statement
• Issue queries and analyse massive amounts of data in Synapse SQL Pools
• Deploy an Azure Synapse Analytics Workspaces Instance
• Load and Analyse Data with Azure Synapse Studio
• Visualise query results using Synapse Studio
• Manage and pause compute to maximise performance and minimise costs

Azure Synapse Analytics Training Outline

Outline

• Understand Azure Synapse Analytics
• Deploy an Azure Synapse Analytics Data Warehouse Instance
• Load and Analyse Data with Azure Synapse Analytics Data Warehouse
• Deploy an Azure Synapse Analytics Workspaces Instance
• Load and Analyse Data with Azure Synapse Studio
• Manage Compute for Azure Synapse Analytics