Logo Microsoft

Data AI: Azure Synapse SQL Pool Essentials

Trainings-ID:
MPW-DataAIAZSQL

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.

Objectives
  • 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

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

Zielgruppen

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

Vorkenntnisse

  • SQL Server
  • MPP
  • Azure and Synapse experience 

Detail-Inhalte

Day 1
Architecture
  • 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

Downloads

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

Hidden
Hidden
Hidden

Lernformen im Überblick

Mehr darüber