Azure Synapse Analytics Training

Course 1279

  • Duration: 1 day
  • Labs: Yes
  • Language: English
  • Level: Intermediate
Get This Course £495
  • 1-day instructor-led training course
  • One-on-one after-course instructor coaching
  • Tuition fee can be paid later by invoice -OR- at the time of checkout by credit card
#1279
  • Aug 2 2:00 PM - 9:30 PM BST
    Herndon, VA or AnyWare
  • Sep 13 9:00 AM - 4:30 PM BST
    AnyWare
  • Oct 31 1:00 PM - 8:30 PM GMT
    Herndon, VA or AnyWare
  • Dec 13 9:00 AM - 4:30 PM GMT
    AnyWare
  • Jan 23 2:00 PM - 9:30 PM GMT
    Herndon, VA or AnyWare
  • Mar 14 9:00 AM - 4:30 PM GMT
    AnyWare

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

  • 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

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Course FAQs

No, please start with a Microsoft Azure Fundamentals class, like Microsoft Azure Fundamentals Training (AZ-900T00) prior to taking this 1-Day class.

You should be familiar with using Microsoft SQL Server Management Studio to create databases, tables, and queries.