Installation Guide sql server

This guide helps you to set up the software you need for the course "Working with SQL Server databases". As a database system we use Microsoft SQL Server which is one of the three market leading database technologies.  It is an enterprise class Relational Database Management System (RDBMS) that is used by approximately 139,604 companies world wide.  With the release of SQL Server 2016, this version now runs on the Linux open source operating system, a move that is quickly propelling this RDBMS to the number one spot.  It's a good time to learn about it!

Install SQL Server 2017 SP1 Express edition 

Microsoft Windows

The following are the minimum system requirements for installing the software:
Hard Disk Space: At least 6.0 GB of available disk space. 
Operating System: Windows 10, 8.1 and 8
Processor Memory: 512 MB
Processor Speed: x64 Processor: 1.4 GHz

Navigate to the download page HERE then click on the Download Now button.  After the exe file downloads to your computer run the setup file.

Select the  Basic  installation type and follow the simple setup instructions.

Select the Basic installation type and follow the simple setup instructions.

Click on "Accept"

Click on "Accept"

Click on "Install"

Click on "Install"

Select  Install SSMS  to install SQL Server Management Studio

Select Install SSMS to install SQL Server Management Studio

Click on the Download SQL Server Management Studio 17.1 link.

Click on the Download SQL Server Management Studio 17.1 link.

An executable file will be downloaded to your computer.  Run the exe when the download is completed and follow the simple setup instructions.

Click  Install  and follow the simple instructions.

Click Install and follow the simple instructions.

Click on  Restart  to restart your computer and complete the installation of SQL Server Management Studio

Click on Restart to restart your computer and complete the installation of SQL Server Management Studio

Download the Sample Database script (SQLTW_Sample_DB.sql)

We use a SQL Server sample database called SQLTW_Sample_DB for this course.  Please click the link to download it to your computer.  After it downloads, do not open it, just save it to your computer.  If you wish you can create a folder for this course "SQLTrainingWheels" and place the downloaded sample database in that folder. 

  1. Download SQLTW Sample DB Script
  2. Download SQLTW Sample DB Backup 
  3. Download SQLTW Sample DB Script (2014)

Environment Orientation

  1. After installingstart the application.
    • Windows users, go to your Start Menu and click on Microsoft SQL Server Management Studio from your list of installed programs. 
  2. You will see the following default screen:
Set the Server type, Server name, and Authentication as shown above then click on  Connect

Set the Server type, Server name, and Authentication as shown above then click on Connect

This is the graphical user interface for SQL Server databases.  This is where you will be composing your SQL statements and building your query writing confidence in SQL Server!

This is the graphical user interface for SQL Server databases.  This is where you will be composing your SQL statements and building your query writing confidence in SQL Server!