Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Microsoft Azure Synapse for Developers

via LinkedIn Learning

Overview

Get up and running with Azure Synapse (formerly known as Azure SQL Data Warehouse), a powerful analytics service that blends big data analytics with data warehousing.

Data powers decision-making. And to effectively leverage data to support business insights, companies must be able to query data and run analytics at a large scale. Azure Synapse, formerly known as Azure SQL Data Warehouse, can help. This powerful analytics service blends big data analytics with data warehousing, offering organizations a way to store large amounts of incoming data for a reasonable cost. In this course, instructor Nertil Poci helps developers get up and running with Azure Synapse and build their first data warehouse. Nertil goes over the benefits that Azure Synapse offers, as well as how to provision a data warehouse, load and query data, and leverage best practices to minimize costs and optimize your data warehouse. Along the way, he shares challenges that allow you to practice your new skills.

Syllabus

Introduction
  • Create your data warehouse
  • What you should know
1. Getting Started with Azure SQL Data Warehouse
  • Cloud data warehouses
  • Azure SQL Data Warehouse overview
  • Provision Azure SQL Data Warehouse instances
  • Challenge: Provision SQL Data Warehouse
  • Solution: Provision SQL Data Warehouse
2. Populating Azure SQL Data Warehouse
  • Data loading in Azure SQL Data Warehouse
  • Loading methods in data warehousing
  • Load data with PolyBase
  • Load data using the COPY command
  • Load data with Azure Data Factory
  • Load data using an SSIS package
  • Challenge: Evaluate data load methods
  • Solution: Evaluate data load methods
3. Consuming the Data Warehouse
  • Querying, labeling, and tracking data warehouse performance
  • Query concurrency and concurrency slots
  • Monitoring concurrency for queries in real time
  • Transactions in Azure SQL Data Warehouse
  • Scaling and performance
  • Challenge: Track and monitor queries
  • Solution: Track and scale to match workload
4. Best Practices
  • Transactions and transaction sizes
  • Azure SQL Data Warehouse maintenance operations
  • Azure SQL Data Warehouse distribution methods and keys
  • Minimizing Azure SQL Data Warehouse costs
  • Challenge: Determine the correct distribution method
  • Solution: Determine the correct distribution method
Conclusion
  • Next steps with data warehouses

Taught by

Nertil Poci

Reviews

Start your review of Microsoft Azure Synapse for Developers

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.