Logo Microsoft

Data AI: Azure Synapse SQL Pool Essentials


Inhalt des Trainings

This offering presents how you can monitor, administer, optimize, and operate an Azure Synapse SQL Pool. You will examine how the SQL analytics platform allows you to scale the compute and storage elastically and independently with a massively parallel processing architecture. You will also study how Azure Synapse Analytics is a limitless analytics service that joins enterprise-grade data warehousing with Big Data Analytics.

  • Learn Massive Parallel Processing basics
  • Understand Synapse SQL Pool Architecture, Clients, and Tools
  • Load data into Synapse SQL Pool
  • Review security, storage, elasticity, scaling, and best practices for these

  • Move an Azure SQL Synapse SQL Pool and manage the workload


  • SQL Server Architects
  • Database Administrators
  • IT professionals
  • SQL Server support staff and DevOps Engineers


  • SQL Server
  • MPP
  • Azure and Synapse experience 


Day 1
  • Synapse Pool Architecture
  • Data Distribution Overview, Workloads

Data load
  • Load data to Azure Synapse SQL Pool
  • Migrate an existing database to Azure Synapse SQL Pool

Day 2
Designing for performance
  • Difference to SQL Server, data distribution, and hash distribution keys
  • Security
  • Connection security
  • Authentication and Authorization
Day 3
Administration, managing and monitoring
Manage a workload
Monitor a workload and database objects


Jetzt online buchen

  • 14.05.-16.05.2024 14.05.2024 3 Tage 3T Online
    Trainer - Alex Niculai
    Language - German
    Remote Training
    von Ihrem Computer Uhrzeiten
    • Preis  5.170,-
      • Online

Preise exkl. MwSt.

Sie haben Fragen?

Ihr ETC Support

Kontaktieren Sie uns!

+43 1 533 1777-99


Lernformen im Überblick

Mehr darüber