Adventureworks database 20123/14/2024 ![]() ![]() This data set was imported from my Adventureworks database in SQL Server. Adventureworks is a free publicly available database for a fictional bike company created by Microsoft.īelow is simply a sample of the data. For more information about samples, see the Samples GitHub repository. The entire database is quite large and for this dashboard only details relating to sales and staff were targeted. This article provides direct links to download AdventureWorks sample databases, and instructions for restoring them to SQL Server, Azure SQL Database, and Azure SQL Managed Instance. The Sales Dashboard contains filters for Country/region and year/quarter, pie chart for region, net revenue stats and graphs, table detailing product quantities and sum net revenue as well as net revenue proportions per territory.įiltering the dashboard by sales made in Australia in the previous two quarters.ĭrilling down into Bikes to further investigate the performance of Road bikes, Mountain bikes and Touring bikes. database backup of the AdventureWorks database: BACKUP DATABASE AdventureWorks TO DISK 'C:AdventureWorks.bak' 5. Road bikes appear to generate the most revenue as well as the highest order quantities, while Touring bikes is the lowest generator of sales within the Bike area. #Adventureworks database sql server 2012 generator# Using filters once again to find out more information about ‘Road Bikes’ sales in quarter 2 of 2008 within the Central Region. This project is special version of the AdventureWorks 2012 sample databases for use with the SQL Server 2012 Developer Training Kit. Please update existing links to point to the GitHub release location. It can also be noted that Bikes generate 13.73% of revenue in this region by looking at the bottom right stacked bar chart.ĭigging into United Kingdom, 2008, Quarter 2 sales within the clothing category. Status: Stable Modified: 11:38:37 -07:00 AdventureWorks downloads are available in the url: SQL Server Samples repository on GitHub. Clothing represents 23.85% of sales revenue under this selection with a net revenue of nearly 1.4$ million and 4076 units sold. ![]() Jerseys were the top performing clothing item here. #Adventureworks database sql server 2012 generator#.You should post these to /r/learnsql instead. Be sure to execute a USE AdventureWorks command to switch to that database before executing any of the examples in this chapter. Note /r/SQL does not allow links to basic tutorials to be posted here. An AdventureWorks database can be installed by attaching the database, or using the CREATE DATABASE statement. Please view the Wiki for online resources. Learning SQLĪ common question is how to learn SQL. SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3įor those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this: This will greatly increase your chances of receiving the help you desire. If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. We will gladly help where we can as long as you post the work you have already done or show that you have attempted to figure it out on your own. If you are a student or just looking for help on your code please do not just post your questions and expect the community to do all the work for you. These information we can easily download from Googling itself. While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform. As mentioned by AlexKudryashev in the comment section, you can download the AdventureWorks2012.bak file from the below link. Click the Downloads tab to download a copy of the latest release. Please post any feedback regarding this version of AdventureWorks on our UserVoice Forum. When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so: This project is special version of the AdventureWorks 2012 sample databases for use with the SQL Server 2012 Developer Training Kit. The goal of /r/SQL is to provide a place for interesting and informative SQL content and discussions. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |