We are going to install SSMS. You will need to install SQL Server Management Studio (SSMS) to be able to connect SQL Server and query SQL databases.
1 Click Install SSMS from this screen to go to the SQL Server Management Studio (SSMS) download page or simply navigate there using this link.
2 From this web page, click Download SQL Server Management Studio (SSMS) xx.x to download the media.
3 Download the media and Run the downloaded file and you will see the below screen. Check your installation location and click the install button.
4 SQL Server Management Studio (SSMS) will be installed on your Windows computer. Click Close when installation completes.
1 Start SQL Server Management Studio. The first time you run SSMS, the Connect to Server window opens. If it doesn't open, you can open it manually by selecting Object Explorer > Connect > Database Engine.
2 When the Connect to Server dialog box appears. Enter the following information:
////
Setting - Suggested values - Description
Server type - Database Engine - For Server type, select Database Engine (usually the default option).
Server name - The fully qualified server name - For Server name, enter the name of your SQL Server (you can also use localhost as the server name if you're connecting locally). If you're NOT using the default instance - MSSQLSERVER - you must enter in the server name and the instance name.
Authentication - Windows Authentication - Windows Authentication is set as default.
You can also use SQL Server Authentication to connect. However, if you select SQL Server Authentication, a username and password are required.
Login - Server account user ID - The user ID from the server account used to sign in to the server. A login is required when using SQL Server Authentication.
Password - Server account password - The password from the server account used to sign in to the server. A password is required when using SQL Server Authentication.
3 After you complete all the fields, select Connect.
To download Northwind and pubs sample databases for Microsoft SQL Server, visit the following GitHub repository.
1 Download the script instnwnd.sql for the Northwind sample database for SQL Server
2 Download the script instpubs.sql for the Pubs sample database for SQL Server
3 After downloading both scripts, you will need to run the instnwnd.sql and instpubs.sql script file to recreate the database on an instance of SQL Server by using SQL Server Management Studio. Follow the steps below based on scripting you are using.
1 Open SSMS.
2 Connect to the target SQL Server.
3 Open the script in a new query window.
4 Run the script (Click Execute).
1 Open SSDT or Visual Studio.
2 Open the SQL Server Object Explorer.
3 Connect to the target SQL Server.
4 Open the script in a new query window.
5 Run the script.
Once you click the Execute button to run the scripts, the Pubs or Northwind sample database will be restored on your local MS SQL Server. Expand the database tree and you will notice the Database Diagram, Tables, Views, etc. are all restored. The great this with the sample database as you will find out, is that the database is full of sample records you can play with as you embark on becoming an expert Transact-SQL script writer.
#Emeka - install-pubs-4.jpg
Repeat the above step to restore the other sample database on your local MS SQL Server. We will need both database to write and execute Transact-SQL scripts as we go through the exercises on LearningDub.com
1 - 2 - 3 - 4 -
Keep in Mind:
Note
