Setup for Introduction to SQL Training using SQL Server

• Windows 10 or later.
• Microsoft SQL Server Express - Microsoft's free edition of their SQL Server RDBMS.
• One of the following SQL editors:
  • Azure Studio (recommended)
  • SQL Server Management Studio

Creating the Webucator Folder

The first step to setting up for your course is to create the folder in which you will store your class files: Create a new folder named Webucator wherever you want, but make sure you remember where it is.

Getting the Class Files for Introduction to SQL

Download the Introduction to SQL class files and unzip them into the Webucator folder and rename the unzipped folder "SQL101".

Install Microsoft SQL Server Express

1. Download Microsoft SQL Server Express from this page.
2. Run the installer.
3. Select the Basic installation and click through the installer.
4. When the installation completes, close the installer.

Install Azure Studio

While you can use SQL Server Management Studio, we recommend using Azure Studio, which is lighter and easier to work with.

1. Download the x64 Windows User installer of Microsoft Azure Studio from this page. You may need to scroll down to see the installer:
   
2. Run the installer, selecting the Basic type and then accepting all the defaults.
3. When the installer completes, check Launch Azure Data Studio and click Finish.
4. Create a new connection:
   
5. Within the Connection dialog panel, choose your SQL Express installation, typically named localhost, and click the Connect button:
   

Install the Northwind Database Used in Class

1. In Azure Studio, select File > Open Folder...
2. Navigate to your SQL101 folder and open it.
3. On the left bar, click the Explorer icon (looks like two sheets of paper) and then open setup\Northwind-SQLServer.sql:
   
4. Click the Run button:
   
5. On the left bar, click the database icon and expand the Northwind database to see the tables it contains:
   
6. Right-click the Northwind database and select New Query:
   
7. In the file that opens up, enter: SELECT * FROM Employees  
8. Run the file by clicking the Run button or by pressing the F5 key. You should get a result set like the one below:
   

Congratulations. You are all set for your course.