Assignment:
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
Required Software
Microsoft SQL Server Management Studio
Adventure Works sample database
Access the software at: https://labs.azure.com. 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
Attachment:- Accessing Azure Labs.rar