Setup for Introduction to SQL Training using SQL Server
Required Software
- Windows 10 or later.
- Microsoft SQL Server Express - Microsoft's free edition of their SQL Server RDBMS.
- SQL Server Management Studio - The client interface for connecting to SQL Server.
Instructions
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. This will create a folder called ClassFiles.
Install the Software
- Download Microsoft SQL Server Express from this page.
- Run the installer.
- Select the Basic installation and click through the installer.
- When the installation is finished, you'll see a screen like the one below with an Install SSMS button at the bottom.
- Click the Install SSMS button to go to the SQL Server Management Studio download page. You may then close the SQL Server 2017 Express Edition window.
- Download the current General Availability (GA) version of SQL Server Management Studio.
- Run the installer.
Install the Northwind Database Used in Class
- Open SSMS:
- Connect using Windows Authentication:
- Select File > Open > File…
- Open the Northwind-SQLServer.sql file from the setup folder within your class files.
- Run the file by clicking the Execute button or by pressing the F5 key:
- After running the file, you should see a Northwind database in the Databases folder in the Object Explorer:
- Right-click on Northwind and select New Query:
- In the file that opens up, enter:
SELECT * FROM Employees
- Run the file by clicking the Execute 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.