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 analyze massive quantities of data in Synapse SQL Pools using optimal techniques for massively parallel processing. In addition, students will issue queries and visualize 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 analyze massive amounts of data in Synapse SQL Pools
  • Deploy an Azure Synapse Analytics Workspaces Instance
  • Load and Analyze Data with Azure Synapse Studio
  • Visualize query results using Synapse Studio
  • Manage and pause compute to maximize performance and minimize costs

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

LIVE, INSTRUCTOR-LED

In Class & Live, Online Training

  • 1-day instructor-led training course
  • One-on-one after-course instructor coaching
  • Tuition can be paid later by invoice -OR- at the time of checkout by credit card
View Course Details & Schedule

Standard $790 USD

Government $790 USD

RESERVE SEAT

PRODUCT #1279

TRAINING AT YOUR SITE

Team Training

  • Bring this or any training to your organization
  • 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 FlexVouchers – A Unique Training Savings Account

Our FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.

In Class & Live, Online Training

Time Zone Legend:
Eastern Time Zone Central Time Zone
Mountain Time Zone Pacific Time Zone

Note: This course runs for 1 Day

  • Dec 13 9:00 AM - 4:30 PM PST San Francisco / Online (AnyWare) San Francisco / Online (AnyWare) Reserve Your Seat

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

  • Mar 14 9:00 AM - 4:30 PM PDT San Francisco / Online (AnyWare) San Francisco / Online (AnyWare) Reserve Your Seat

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

  • Jun 13 9:00 AM - 4:30 PM PDT San Francisco / Online (AnyWare) San Francisco / Online (AnyWare) Reserve Your Seat

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

  • Sep 19 9:00 AM - 4:30 PM PDT San Francisco / Online (AnyWare) San Francisco / 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 practice 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 Analyze Data with Azure Synapse Analytics Data Warehouse
  • Deploy an Azure Synapse Analytics Workspaces Instance
  • Load and Analyze 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.

San Francisco / Online (AnyWare)
Herndon, VA / Online (AnyWare)
San Francisco / Online (AnyWare)
Herndon, VA / Online (AnyWare)
San Francisco / Online (AnyWare)
Herndon, VA / Online (AnyWare)
San Francisco / 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:
Chat Now

Please Choose a Language

Canada - English

Canada - Français