YoVDO

Microsoft Azure Synapse for Developers

Offered By: LinkedIn Learning

Tags

Azure Synapse Analytics Courses Data Analysis Courses Cloud Computing Courses SQL Courses Data Warehousing Courses Azure Stream Analytics Courses Data Streaming Courses

Course Description

Overview

Learn how to get up and running with Azure Synapse to analyze your data and store it in the cloud.

Syllabus

Introduction
  • Data warehouses in the cloud
  • What you should know
1. Getting Started with Azure Synapse Analytics
  • Azure Synapse Analytics overview
  • Creating Azure Synapse Analytics workspaces
  • Analyzing the architecture of dedicated SQL pools
  • Provisioning dedicated Synapse Analytics pools
  • Challenge: Create a Synapse Analytics workspace with a dedicated pool
  • Solution: Create a Synapse Analytics workspace with a dedicated pool
2. Populating Dedicated Synapse Analytics Pools
  • Data loading in Azure Data Warehouse
  • Preparing your data
  • Exploring Azure Synapse Studio
  • Loading data using the copy tool
  • Load data using the COPY command
  • Load data with PolyBase
  • Transform data using data flows
  • Challenge: Loading data using the copy tool
  • Solution: Loading data using the copy tool
3. Streaming Data into Azure Synapse Analytics
  • Data streaming scenarios
  • Creating a Stream Analytics job
  • Testing data streaming using sample data
4. Querying Using Serverless SQL
  • Understanding serverless pools
  • Querying and discovering data using serverless pools
  • Using file metadata in queries
  • Building a logical data warehouse, part 1
  • Building a logical data warehouse, part 2
  • Manage statistics
  • Cost management
  • Challenge: Query partitioned data
  • Solution: Query partitioned data
5. Querying and Best Practices in Dedicated SQL Pools
  • Querying, labeling, and tracking data warehouse performance
  • Transactions in dedicated SQL pool
  • Optimizing queries with materialized views
  • Connecting using external clients
  • Creating and updating statistics
  • Analyzing data distribution
Conclusion
  • Next steps with Synapse Analytics

Taught by

Nertil Poci

Related Courses

Software as a Service
University of California, Berkeley via Coursera
Software Defined Networking
Georgia Institute of Technology via Coursera
Pattern-Oriented Software Architectures: Programming Mobile Services for Android Handheld Systems
Vanderbilt University via Coursera
Web-Technologien
openHPI
Données et services numériques, dans le nuage et ailleurs
Certificat informatique et internet via France Université Numerique