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.
• 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 SQL Server Management Studio

1. Download SQL Server Management Studio.
2. Run the installer (vs_SSMS.exe).
3. Select the Basic type and accept all the defaults.
4. When the installer completes, click the Launch  button adjacent to SQL Server Management Studio 22.

5. Create a new connection using the Object Explorer in the upper left hand corner of the screen: 

   

6. Within the Connection dialog panel, specify localhost, as the Server Name if it's not filled in already and set Encrypt to Optional:

   

7. Click the Connection String tab.

8. Fill in the connection string as shown below:

   

9. Click Connect.

Install the Northwind Database Used in Class

1. Select File > Open File...
2. Navigate to SQL101\setup\Northwind-SQLServer.sql. Click Open.

3. Click the Execute button on the toolbar: 

   

4. In the Object Explorer, expand Databases and then expand Northwind.  Under Northwind, expand Tables to view the tables: 

   

5. Right-click the The Northwind database in the Object Explorer and select New Query:  

   

6. Type in select * from Employees; and then click the Execute icon.  Here is the result you should see: 

   

   
   
   
    

Congratulations. You are all set for your course.