When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Building Your First Data Lakehouse Using Azure Synapse Analytics
In this course, you will learn about Azure Synapse Analytics & its integrated services - Workspace, Dedicated SQL, Apache Spark, Serverless SQL, Pipelines, Synapse Link to Cosmos DB, Power BI - and how it can be used to build a Data Lakehouse.

This Course Includes
pluralsight
5 (92 reviews )
2 hour 58 minutes
english
Online - Self Paced
Expanded Courses
pluralsight
About Building Your First Data Lakehouse Using Azure Synapse Analytics
Data Lakehouse is an architecture that intends to bring the best of Data Warehouses and Data Lakes together. It helps to put together a common platform to handle huge volumes of data, process data faster, and serve multiple use cases. In this course, Building Your First Data Lakehouse Using Azure Synapse Analytics, you'll learn to use Azure Synapse Analytics. It is a totally new product that brings together data integration, enterprise data warehousing, and big data analytics together. It is a set of multiple, well-integrated, Azure Data Services - Workspace, Dedicated SQL Pool, Apache Spark Pool, Serverless SQL, Synapse Pipelines, Synapse Link to Cosmos DB, integrated Power BI workspace, and much more. First, you'll learn how to set up the Synapse workspace by bringing in multiple data sources. Next, you'll discover how to explore the data and how to work with Dedicated SQL Pool, and Apache Spark Pool to extract and transform the data. Finally, you'll explore how to ingest, transform, and orchestrate data using Synapse Pipelines, use a Serverless SQL Pool to build a logical data model, and use connected services to Synapse. By the end of this course, you'll have knowledge and skills to use Synapse Link for Cosmos DB, and the integrated Power BI experience to help to build an end-to-end Data Lakehouse.
What You Will Learn?
- Course Overview : 1min.
- Getting Started with Data Lakehouse and Azure Synapse Analytics : 28mins.
- Working with Dedicated SQL Pool : 44mins.
- Transforming Data with Synapse Spark Pool : 36mins.
- Ingesting, Transforming, and Orchestrating with Synapse Pipelines : 28mins.
- Querying Data Using Serverless SQL Pool : 19mins.
- Connecting Services with Azure Synapse Analytics : 19mins.