MEAPSA

Create a lake database in Azure Synapse Analytics

Why choose between working with files in a data lake or a relational database schema? With lake databases in Azure Synapse Analytics, you can combine the benefits of both.

Data Engineer

Synapse Analytics

Module Objectives

After completing this module, you will be able to:

Understand lake database concepts and components
Describe database templates in Azure Synapse Analytics
Create a lake database

Units

Introduction min
Understand lake database concepts min
Explore database templates min
Create a lake database min
Use a lake database min
Exercise - Analyze data in a lake database min
Knowledge check min
Summary min

Prerequisites

Consider completing the Explore data analytics in Azure and Get started querying with Transact-SQL learning paths before starting this module. You will need knowledge of:

Analytical data workloads in Microsoft Azure
Querying data with Transact-SQL