Azure Synapse Analytics Training

Level: Intermediate

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.

Key Features of this Azure Synapse Analytics Training:

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

You Will Learn How To:

  • 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

Choose the Training Solution That Best Fits Your Individual Needs or Organisational Goals

LIVE, INSTRUCTOR-LED

In Class & Live, Online Training

  • 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
View Course Details & Schedule

Standard £495

RESERVE SEAT

PRODUCT #1279

TRAINING AT YOUR SITE

Team Training

  • Bring this or any training to your organisation
  • Full - scale program development
  • Delivered when, where, and how you want it
  • Blended learning models
  • Tailored content
  • Expert team coaching

Customize Your Team Training Experience

CONTACT US

Save More on Training with Learning Tree Training Vouchers!

Our flexible, easy-to-redeem training vouchers are available to any employee within your organisation. For details, please call 0800 282 353 or chat live.

In Class & Live, Online Training

Note: This course runs for 1 Day

  • 1 Mar 9:00 AM - 4:30 PM GMT Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 7 Jun 9:00 AM - 4:30 PM BST Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 13 Sep 9:00 AM - 4:30 PM BST Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 31 Jan 2:00 PM - 9:30 PM GMT Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • 2 May 2:00 PM - 9:30 PM BST Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • 2 Aug 2:00 PM - 9:30 PM BST Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.

Important Azure Synapse Analytics Training Information

  • Prerequisites

    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.

  • Necessary Preparation

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

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

Team Training

Azure Synapse Analytics Training FAQs

  • I am new to Microsoft Azure, is this a good starting point?

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

  • Do I need any Microsoft SQL Server experience for this course?

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

Online (AnyWare)
Online (AnyWare)
Online (AnyWare)
Herndon, VA / Online (AnyWare)
Herndon, VA / Online (AnyWare)
Herndon, VA / Online (AnyWare)
Why do we require your location?

It allows us to direct your request to the appropriate Customer Care team.

Preferred method of contact:

Please Choose a Language

Canada - English

Canada - Français