Working with Relational Data Stores in the Cloud
Lab
Intermediate
1 h 5 m
2020-01-12
Lab Overview
The students will be able to provision an Azure SQL Database and Azure Synapse Analytics server and be able to issue queries against one of the instances that are created. They will be also be able to integrate a data warehouse with a number of other data platform technologies and use PolyBase to load data from one data source into Azure Synapse Analytics.

Related Learning Path(s):
DP-200: Implementing an Azure Data Solution
Exercises
In this exercise, you will create and configure an Azure SQL Database instance.
In this exercise, you will create and configure a Azure Synapse Analytics instance, configure the Server Firewall and pause the warehouse database.
In this exercise, you will install SQL Server Management Studio and connect to a data warehouse instance and manage database objects in the data warehouse.
In this exercise, you will create a dbo.Dates table and load the table using PolyBase from Azure Data Lake Store.
Real-Time Lab
Not Registered?
Create Account
Already Registered?
Login
What are Labs?

Labs provide a live environment to get hands-on experience using the same tools and services in the real world.


Learn More