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.