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

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 :

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

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

6. 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

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

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

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

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

Follow the same steps as above to install the WideWorldImporterDW