LOADING

Type to search

Steps to Install Wide World Importers sample database in your Microsoft SQL Server Database via Sql Server Management Studio

To Know more about the Different Corporate Training & Consulting Visit our website www.Instrovate.com Or Email : info@instrovate.com or WhatsApp / Call at +91 74289 52788

Data Analytics PowerBI

Steps to Install Wide World Importers sample database in your Microsoft SQL Server Database via Sql Server Management Studio

Share

*******************************************************************************

You can watch and subscribe to the YouTube Channel to recieve Future updates : https://www.youtube.com/watch?v=KZEE7_RTuLo

If you want to know how to Download and Install free version of Microsoft SQL Server , You can read it here – https://instrovate.com/2019/05/22/download-install-free-microsoft-sql-server-install-adventureworks-database-data-warehouse/

If you want to perform some analytics and Visualization on the top of AdventureWorks DW data you can visit the below blogs

  1. How to Connect Python with Microsoft SQL Server and Query AdventureWorks DW – https://instrovate.com/2019/04/12/how-to-connect-python-with-sql-server/
  2. AdventureWorksDW – Python Series#1 – Computing & Plot Yearly Sales for a Territory – https://instrovate.com/2019/05/02/adventureworksdw-python-series1-computing-plot-yearly-sales-for-a-territory/
  3. AdventureWorks Data Warehouse Series#2 : How to Create Bar Chart Visualization Using Python – https://instrovate.com/2019/05/08/adventureworksdw-python-series2-create-bar-chart-using-python/
  4. AdventureWorks DW Series 3 : How to Create Pie Chart Visualization Using Python – https://instrovate.com/2019/05/17/adventureworks-dw-series-3-how-to-create-pie-chart-visualization-using-python/
  5.  AdventureWorks DW Series 4 : How to Create Histogram Visualization Using Python – https://instrovate.com/2019/05/20/adventureworks-dw-series-4-how-to-create-histogram-visualization-using-python/

*********************************************************************************

Steps to Install Wide World Importers sample database in your Microsoft SQL Server Database via Sql Server Management Studio ( SSMS )

Steps.

  1. Documentation : If you want to know more about Wide World Importers sample databases for Microsoft SQL Server visit the link : https://docs.microsoft.com/en-us/sql/samples/wide-world-importers-what-is?view=sql-server-2017

  2. Installation: Visit the Microsoft Github Site : https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0

  3. Download 2 Files : Steps to Install Wide World Importers sample database in your Microsoft SQL Server Database via Sql Server Management Studio 29

  4. Download these Files to the location where Microsoft SQL Server is installed in your system inside Backup ( see screenshot below ) :

C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Backup

Steps to Install Wide World Importers sample database in your Microsoft SQL Server Database via Sql Server Management Studio 30

 

  1. Now Open your Microsoft SQL Server Management Studio , connect to your SQL Server Instance , and Right Click on Database “Restore Database”

 

Steps to Install Wide World Importers sample database in your Microsoft SQL Server Database via Sql Server Management Studio 31

 

  1. The (1) Restore Database window opens up , Click on (2) Device and then click on (3) … . This opens up the Select Backup devices option and there you need to click on (4) Add

Steps to Install Wide World Importers sample database in your Microsoft SQL Server Database via Sql Server Management Studio 32

 

  1. When you Click “Add” , you need to browse to the folder location where you have downloaded the backup File. Select the backup File and

Steps to Install Wide World Importers sample database in your Microsoft SQL Server Database via Sql Server Management Studio 33

 

  1. Select your “Wide World Importers”  and click on “Ok”

 

Steps to Install Wide World Importers sample database in your Microsoft SQL Server Database via Sql Server Management Studio 34

 

  1. You can see the “Ready” button at top .

Steps to Install Wide World Importers sample database in your Microsoft SQL Server Database via Sql Server Management Studio 35

 

  1. Now click on “OK” to complete the installation of Wide World Importer Database.

Steps to Install Wide World Importers sample database in your Microsoft SQL Server Database via Sql Server Management Studio 36

 

Follow the same steps as above to install the WideWorldImporterDW

Steps to Install Wide World Importers sample database in your Microsoft SQL Server Database via Sql Server Management Studio 37

 

Tags:

You Might also Like

Leave a Comment

Your email address will not be published. Required fields are marked *