Management Studio

 

 

Week 3 Lab: Querying the Database With SQL

Scenario/Summary

Adventure Works Cycles is a fictional bicycle manufacturing company headquartered in Bothell, WA, that sells metal and composite bicycles to distributors in North America, Europe, and Asia. Adventure Works also sells bicycles directly to consumers via the company’s website.

Adventure Works executives are formulating a strategic plan to expand the company’s market share and are seeking information to help them. As a business analyst for Adventure Works, you will write SQL queries to retrieve the requested data from the corporate database, analyze the information, and make recommendations to management.

 

Deliverables

After completing the steps below, submit a single Microsoft Word file named LabWeek3xxx.docx (where xxx = your initials). This file will contain screenshots for five queries, showing the SQL code and results. After each screen shot, you should include at least a paragraph of text with your analysis and recommendations to management based on the results of the query.

This assignment is a Signature Assignment:

The Week 3 Lab aligns with Outcomes C, D, and E. The Lab provides an existing business (Sample) database. SQL and DML will be used to manage the database and extract data to answer business questions. The results will be reported and analyzed with a description provided. These activities are common activities that take place in businesses on a daily basis around the world. You will provide a written analysis and recommendation for each SQL query.

The focus of this Lab will be:

1. Work with a real-world Scenario and use real-world data
2. Learn how SQL is used with DML and manage the data in the database
3. Describe and analyze query results
4. Create a report on the data results

Your deliverable will be evaluated according to the rubric below.

Required Software

Microsoft SQL Server Management Studio

Adventure Works sample database

Access the software at: https://labs.azure.com (Links to an external site.).  To access SQL Server Management Studio, follow these instructions Navigation to MS SQL Server Management Studio.pdf  download

You may use either version of  Microsoft SQL Server Management Studio (2016 or 2019).

Navigation to MS SQL Server Management Studio

Select Microsoft SQL Server Tools 18