Advanced Analytics Tools - Exercise: Explore Azure relational database services 2

Wait for deployment to complete. Then go to the resource that was deployed, which should look like this:
Screenshot of the Azure portal showing the SQL Database page.
In the pane on the left side of the page, select Query editor (preview), and then sign in using the administrator login and password you specified for your server.
If an error message stating that the client IP address isn’t allowed is displayed, select the Allowlist IP … link at the end of the message to allow access and try to sign in again (you previously added you own computer’s client IP address to the firewall rules, but the query editor may connect from a different address depending on your network configuration.)
The query editor looks like this:
Screenshot of the Azure portal showing the query editor.
Expand the Tables folder to see the tables in the database.
In the Query 1 pane, enter the following SQL code:
sql
SELECT * FROM SalesLT.Product;
Select ▷ Run above the query to run it and view the results, which should include all columns for all rows in the SalesLT.Product table as shown here:
Screenshot of the Azure portal showing the query editor with query results.
Replace the SELECT statement with the following code, and then select ▷ Run to run the new query and review the results (which includes only the ProductID, Name, ListPrice, ProductCategoryID columns):
sql
SELECT ProductID, Name, ListPrice, ProductCategoryID
FROM SalesLT.Product;
Now try the following query, which uses a JOIN to get the category name from the SalesLT.ProductCategory table:
sql
SELECT p.ProductID, p.Name AS ProductName,
c.Name AS Category, p.ListPrice
FROM SalesLT.Product AS p
JOIN [SalesLT].[ProductCategory] AS c
ON p.ProductCategoryID = c.ProductCategoryID;
Close the query editor pane, discarding your edits.
Tip: If you’ve finished exploring Azure SQL Database, you can delete the resource group that you created in this exercise.
microsoftlearn...