SQL is a powerful language for querying, changing, and deleting data. Almost every person in IT will encounter SQL queries at some point in their work. Being familiar with how to use it effectively can help you achieve greater success in your current role and possibly even set you up to move into a different role. In this hands-on lab, you will work with methods of managing database objects. This includes creating, altering, and dropping items, such as tables and views.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Create a SQL Database
From the Azure portal, create a SQL database named manage_lab using the lab-provided resource group. Create a new server, and name it la-sql-lab-manage. Set the server location to be the same as your lab-provided resource group. Edit your server firewall to add your client IP.
- Connect to the Client
In Visual Studio Code, create a new SQL file. Create a connection profile, and connect to your previously created server and database. Use the login credentials you created when configuring the database.
- Create an Index for Product Name and Color
An index will improve performance for frequently used queries against specific fields. Create an index for the
NameandColorcolumns on theProducttable.- Update the Product Description View
In order to provide the analytics workers with more detail, update the
vProductAndDescriptionview to include theProductNumbercolumn from theProducttable.Hint: Use the current definition, and change
CREATEtoALTER.- Delete the Unused ErrorLog Table
The owners of the
ErrorLogtable have confirmed it’s no longer in use, and they wish to delete it. Write a statement to drop the table.
