What email address or phone number would you like to use to sign in to Docs.com?
If you already have an account that you use with Office or other Microsoft services, enter it here.
Or sign in with:
Signing in allows you to download and like content, and it provides the authors analytical data about your interactions with their content.
Embed code for: CIS 336 DeVry Week 6 iLab Latest
Select a size
CIS 336 DeVry Week 6 iLab latest
Downloading is very simple, you can download this Course here: http://mindsblow.us/question_des/CIS336DeVryWeek6iLabLatest/4569
Contact us at: firstname.lastname@example.org
CIS 336 DeVry Week 6 iLab Latest
.equella.ecollege.com/file/1f23e4c7-a182-4f52-bc25-6092065bf68b/22/CIS336_W6_iLab.html">iLab> STEP 1: Download the Week 6 Lab Instructions and Answer Sheet
Lab 6 of 7: Group Functions and Sub queries
Downloading is very simple, you can download this Course here:
Contact us at:
.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=" title="Listen to this page using ReadSpeaker">Listen
Lab 6 will introduce group or aggregate functions and sub queries. Make sure to follow the instructions provided by each step.
NOTE Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html">step-by-step instructions. (See the Syllabus section "Due Dates for Assignments & Exams" for due dates.)
The deliverable for this lab will include the following.
The Student Answer Sheet file that you will download below provides a place for each query and the output of the query. You will copy and paste this information from your MySQL environment. Be sure your name, course number, and lab number are in your file which will be submitted to the iLab Dropbox for Week 5.
Microsoft Office: Word
Use a personal copy or access the software at.devry.edu/">https://lab.devry.edu. All Steps
Access the software at.devry.edu/">https://devry.edupe.net:8300
PRELIMINARY STEP: If You Have Not Created the Database Yet, Please Complete.
This lab will utilize the tables that were created in Lab 4. If you have not yet created these tables, you can create the database and tables (used in labs 4–7) by downloading the following files. ·
.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/CIS336_CreateOMTables.docx">CreateOMTables.docx (Instructions) ·
.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/create_OM_db.sql">create_OM_db.sql (Database Script)
STEP 1: Download the Week 6 Lab Instructions and Answer Sheet
Follow the instructions to complete the lab by downloading the following files. ·
Be sure to refer to the ERD for the database in.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/OM_ERD.docx">OM_ERD.docx when creating your queries.
STEP 2: Submit Your Answer Sheet
Complete the answer sheet to show your queries and results, and submit according to the lab instructions.
This is the end of Lab #6