Exercise - Use subqueries

Completed

Now it's your chance to try the Transact-SQL techniques you've learned about for yourself.

Set up Azure SQL Database

Note

To use Azure SQL Database, you will need a Microsoft Azure subscription in which you have administrative access.

To set up a database for this exercise, sign into your Azure subscription and follow the setup instructions to provision Azure SQL Database.

Set up SQL Server

To complete the exercise using Microsoft SQL Server, you'll need to follow these setup instructions to install Microsoft SQL Server and the required tools and database.

Set up Microsoft Fabric SQL Database

Note

You need access to a Microsoft Fabric capacity in which you have sufficient permission to create a Fabric SQL Database. See Getting started with Fabric.

To complete the exercise using Microsoft Fabric SQL Database, you'll need to follow these setup instructions to create a Fabric SQL Database for the lab.

Complete the exercise

Launch the exercise and follow the instructions.

Button to launch exercise.