Download & Install Free Microsoft SQL Server & Install AdventureWorks Database & Data Warehouse

How To Download Microsoft SQL Server on your Local Machine
&
Install AdventureWorks Database & Data Warehouse

 

Here we want to do the exercise of Downloading Free Version of Microsoft SQL Server on your Local Machine . Thereafter we will install the Default Database like Adventure Works / Wide World Importers ( WWI ) database in the SQL Server and then we also install the Default Sql Server Management Studio to work on the Data in our Database and also run Query on our Data

 

How To Download & Install Microsoft SQL Server Free on your Local Machine

Go to the Microsoft SQL Server Download Link

https://www.microsoft.com/en-in/sql-server/sql-server-downloads

Download the Free – Express edition

 

Once the exe is downloaded . Double click to start the installation and select Basic

Accept the default and start the installation

First all the packages get downloaded and once it is successfully done the installation starts.

The installation will continue and will take a while before you get the confirmation of Successful installation

Click on Connect Now

Install AdventureWorks Database & Data Warehouse

IN order to download AdventureWorks Databases & Data Warehouse

https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/adventure-works

Go to Install from a Backup

https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks

Download the OLTP & OLAP database & Datawarehouse full backup. And keep it in the below location

C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\Backup

If you are not able to see these folders many time these are hidden . Just copy and paste these in the browser

Go to Microsoft SQL Server Management studio and restore these backup

Select And Restore .

This completes the Installation of Microsoft SQL Server on your Local Machine and Installing AdventureWorks Database & Data Warehouse onto the Microsoft SQL Server. 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/

 

Comments

There are no entries yet.
Please enter the code
* Required fields

Subscribe to Our YouTube Channel To recieve updates on Free Learning

 

 

Visit Our Website to View the Upcoming Training Schedule

Looking for Corporate Training ? Reach out to us at Akriti.Lal@instrovate.com

Reach out to us if you are looking for Corporate Training to Build The Next Generation Analytical Workforce with an in-depth understanding of  Exploratory Data Analysis , Data Visualisation, Data Analytics , AI First , Machine Learning & Deep Learning Training & Consulting helping them to take Data Informed Decision at each stage of the business. 

We understand that At the present times , the Entire Industry is in a Tranformation stage with the Softwares  being rebuilt with Artificial Intelligence Capabilities .

We need SMART WORKFORCE for the SMART SOFTWARES to reap the maximum return . 

 

Whatsapp at +91-9953805788 or email at - akriti.lal@instrovate.com if you would like to know more . 

 

  • Corporate Tableau Training in Gurgaon
  • Corporate Data Analytics Training in Gurgaon
  • Corporate Microsoft Power BI Training in Gurgaon
  • Corporate Microstrategy Training in Gurgaon
  • Corporate Google Data Studio Training in Gurgaon
  • Corporate Python Training in Gurgaon
  • Corporate Advance Analytics in R Programming Training in Gurgaon
  • Corporate Machine Learning Training in Gurgaon
  • Corporate Deep Learning Training in Gurgaon
  • Corporate Data Visualization Training in Gurgaon

 

Address

Instrovate Technologies

Noida, Gurgaon

 

akriti.lal@instrovate.com 

Hit Your Refresh Button To Rise Higher

Subscribe to Our YouTube Channel To Receive Updates on the Latest Free Learning Video Added

Print Print | Sitemap
All rights reserved @ Instrovate Technologies
GSTIN : 09AAECI6862K1Z1

Terms Of Services    Privacy Policy    Disclaimer     Refund Policy    


Call

E-mail