In these exercises, you$$ll use SQL Server Management Studio to create the

MyGuitarShop database, to review the tables in the MyGuitarShop database, and to enter

SQL statements and run them against this database.

Create the database

$1.$ Start SQL Server Management Studio and open a connection using either Windows

or SQL Server authentication.

$2.$ Open the script file named CreateMyGuitarShop.sql that$$s in the MGS Exercise

Starts directory by clicking the Open File button in the toolbar and then using the

resulting dialog box to locate and open the file.

$3.$ Execute the entire script by clicking the Execute button in the SQL Editor toolbar or

by pressing F$5.$ When you do$,$ the Messages tab indicates whether the script executed

successfully.

Review the database

$4.$ In the Object Explorer window, expand the node for the database named

MyGuitarShop so you can see all of the database objects it contains. If it isn$$t

displayed in the Object Explorer window, you may need to click on the Refresh

button to display it$.$

$5.$ View the data for the Categories and Products tables.

$6.$ Navigate through the database objects and view the column definitions for at least the

Categories and Products tables.

Enter and run SQL statements

$7.$ Open a new Query Editor window by clicking the New Query button in the toolbar.

Then, select the MyGuitarShop database from the Available Databases dropdown

menu $($Crtl $+$ U$)$ to choose it as the default database.

$8.$ Enter and run this SQL statement:

SELECT ProductName FROM Products

$9.$ Delete the e at the end of ProductName and run the statement again. Note the error

number and the description of the error.