the data analyst for Adventure Works Cycling Company.
Just Click on Below Link To Download This Course:
http://bit.ly/32BdIPl
MIS 605 Topic 5 Advanced Queries GCU
The purpose of this assignment is to conduct
advanced queries for the creation of separate reports.
For this assignment, continue to play the
role of the data analyst for Adventure Works Cycling Company. Your manager has
asked you to localize query results into a temporary table to avoid running the
same queries repeatedly and to better track the data. This will also free up
network resources for the company. Saving queries is of the utmost importance
since temporary tables are lost soon when you disconnect from the server.
Failing to save a query will result in the need to rebuild the code for the
temporary table.
Using the queries completed in the Topic 4
assignment, complete the steps below and address the questions.
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 and answer the following
questions.
- Create a basic temporary table from work done in Topic 4, question
5 and call it “MyTempTable.” Write a SELECT statement to query the new
data.
- Order the results on MyTempTable by SalesOrderID.
- Add a timestamp field called “DateRan” and update it to the current
date.
- Explain how to drop the table and start over.
- Explain how the table can be re-added?
Compile the Excel data file and Word document
containing the SQL queries and answers to the questions 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