Installing Microsoft SQL Server and SSMS

Select Yes

Select Basic

Select Accept

Unless you have a reason to do otherwise, accept the default location.

Select Install

The files will be downloaded and installed.

Eventually …

There is a button to install SSMS, but you can ignore that.

Select Close

Select Yes

Select Install

Select Close

See Microsoft SSMS - Settings for instructions on setting up SSMS

If necessary, click on the Connect Object Explorer button

• Server Name: …\SQLEXPRESS
• Authentication: Windows Authentication
• ☑️ Trust Server Certificate

Create a New Document: CtrlN
Enter the following code:

USE master;
CREATE DATABASE artworks;

Execute the code: F5

Open the sample-db-….sql file.

Select the new database from the toolbar menu.

Execute the code: F5