BIS 345 Week 3 Ilab Multi-Table Queries, Subqueries and Views

Published on January 2018 | Categories: Science Fiction & Fantasy | Downloads: 219 | Comments: 0 | Views: 656
of 1
Download PDF   Embed   Report

Lab 3 of 7: Multi-Table Queries, Subqueries and Views · iLab Overview Scenario/Summary Using the Northwind database, you have been requested to select data for specific needs. Once selected, your data will be presented to management. You will have to determine which fields are the most appropriate to be selected. Do not include any fields that management does not need to see. Upon completing this lab, you will be able to 1.join tables, 2.use subqueries in a SELECT query, and 3.use view parts (month, day, year) and perform date related calculations. Deliverables NOTE Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read thesestep-by-step instructions. (See the Syllabus section "Due Dates for Assignments & Exams" for due dates.) Following along with an instruction file, you will document your completion of the following tasks: Section Deliverable Points Part A Join two tables 4 Part B Join two tables and apply WHERE clause 4 Part C Inner join two tables 4 Part D Inner join two tables and apply WHERE clause - Practice #1 5 Part E Inner join two tables - Practice #2 5 Part F Inner join two tables - Practice #3 5 Part G Join two tables with subquery - Practice #1 5 Part H Join two tables with subquery - Practice #2 5 Part I Single table join 5 Part J Complex join 5 Total Points 47 Remember This! Connect to the iLab here. Lab Steps Preparation 1.DownloadGuide_to_SQL_Server_Management_Studio_2008.docxfrom DocSharing. 2.DownloadBIS345_Lab3_Questions.docxfrom DocSharing and save a copy using the naming structureLastName_FirstName_Lab3_Questions.docx. You will answer the questions and provide printscreens as required for each part of the lab. 3.To login to the Citrix remote lab, follow the instructions located in the iLab item under Course Home. 4.Follow the steps inGuide_to_SQL_Server_Management_Studio_2008.docxto ostart SQL Server Management Studio, ocreate a new project, oadd a query file, and oget the required output. Steps Complete the steps for this lab as directed inBIS345_W3_iLab_instructions.docx. Submit your work Submit your completedLastName_FirstName_Lab3_Questions.docxto the Week 3 iLab Dropbox. Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read thesestep-by-step instructions.

Comments

Content

Lab 3 of 7: Multi-Table Queries, Subqueries and Views · iLab Overview Scenario/Summary Using the Northwind database, you have been requested to select data for specific needs. Once selected, your data will be presented to management. You will have to determine which fields are the most appropriate to be selected. Do not include any fields that management does not need to see. Upon completing this lab, you will be able to 1.join tables, 2.use subqueries in a SELECT query, and 3.use view parts (month, day, year) and perform date related calculations. Deliverables NOTE Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read thesestep-by-step instructions. (See the Syllabus section "Due Dates for Assignments & Exams" for due dates.) Following along with an instruction file, you will document your completion of the following tasks: Section Deliverable Points Part A Join two tables 4 Part B Join two tables and apply WHERE clause 4 Part C Inner join two tables 4 Part D Inner join two tables and apply WHERE clause - Practice #1 5 Part E Inner join two tables - Practice #2 5 Part F Inner join two tables - Practice #3 5 Part G Join two tables with subquery - Practice #1 5 Part H Join two tables with subquery - Practice #2 5 Part I Single table join 5 Part J Complex join 5 Total Points 47 Remember This! Connect to the iLab here. Lab Steps Preparation 1.DownloadGuide_to_SQL_Server_Management_Studio_2008.docxfrom DocSharing. 2.DownloadBIS345_Lab3_Questions.docxfrom DocSharing and save a copy using the naming structureLastName_FirstName_Lab3_Questions.docx. You will answer the questions and provide printscreens as required for each part of the lab. 3.To login to the Citrix remote lab, follow the instructions located in the iLab item under Course Home. 4.Follow the steps inGuide_to_SQL_Server_Management_Studio_2008.docxto ostart SQL Server Management Studio, ocreate a new project, oadd a query file, and oget the required output. Steps Complete the steps for this lab as directed inBIS345_W3_iLab_instructions.docx. Submit your work Submit your completedLastName_FirstName_Lab3_Questions.docxto the Week 3 iLab Dropbox. Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read thesestep-by-step instructions.

Sponsor Documents

Or use your account on DocShare.tips

Hide

Forgot your password?

Or register your new account on DocShare.tips

Hide

Lost your password? Please enter your email address. You will receive a link to create a new password.

Back to log-in

Close