Data AI: Azure Synapse SQL Pool Essentials

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

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

• SQL Server
• MPP
• Azure and Synapse experience 

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