The purpose of this assignment is to build a stored procedure that allows
Just Click on Below Link To Download This Course:
http://bit.ly/2O1hy11
MIS 605 Topic 8 Stored Procedures GCU
The purpose of this assignment is to build a
stored procedure that allows for the compression of data and the ability to run
a process repeatedly over time.
For this assignment, continue to assume the
role of a data analyst at Adventure Works Cycling Company. Your manager is
waiting for you to deliver your analysis of why the company is losing money on
its popular model “LL Road Frame-Black 60.” As you are preparing your final
report, your manager asks you to save your final queries from Topic 6 (the two
nontemporary queries) as a stored procedure so you can periodically check on them
from time to time. To do this, you will need to complete the steps below.
Please note that when SQL queries are run,
results are generated in the form of data. This data should be exported and
saved to Excel for a visual check of accuracy.
Create a Word document that includes the SQL
query code used to explore the database tables.
- Drop all ORDER_BY statements from the query.
- Label one as PriceHistory723.
- Label the other as SalesOrderDetailbyDate723.
Compile the Excel data file and Word document
containing the SQL queries into a .zip file and submit to your instructor.
APA style is not required, but solid academic
writing is expected.
This assignment uses a rubric. Please review
the rubric prior to beginning the assignment to become familiar with the
expectations for successful completion.
You are not required to submit this
assignment to LopesWrite.
Comments
Post a Comment