Download Microsoft SQL Server

Can use "Microsoft SQL Server 2012 Express". Download page is the following: https://www.microsoft.com/en-us/download/details.aspx?id=29062

Click download:

Want to select "SQLManagementStudio_x64_ENU.exe". This corresponds to:

(Can see the different download options by looking under "Details" in the above screenshot:)

Check the box for the desired version, as mentioned:

Select "New SQL Server stand-alone installation or add features to an existing installation":

License terms:

Check "LocalDB":

Review and click "Next":

Program will install. If it installs correctly:

Open Windows command prompt by clicking the start menu and searching for “cmd” and then clicking on “cmd.exe”:

To test that the SQL LocalDB installed correctly, type the following command after the ">" and press "Enter":

SqlLocalDb info

Should see the version number display:

If LocalDB installation was successful and you see the version number, can then create an instance of the LocalDB. The following example uses the name "sql", but you can use a different name:

SqlLocalDb create sql

Should see the following if the command was succesful:

Open SQL Server Management Studio and enter "(localdb)\LocalDB_instance_name", such as "(localdb)\sql" as in our example, for the Server Name. Then click "Connect" to connect to the server

To enter a command, click "New Query" on the toolbar.

Enter a sample command into the newly displace window, such as "select @@version":

Press "F5" or click the "Execute" button on the toolbar to execute the command return a result. This example returns the software version of SQL Server that is installed: