Category: MySQL

Hide Assignment Information
Instructions
Instructions:
Watch the Introduction to

Hide Assignment Information
Instructions
Instructions:
Watch the Introduction to Databases video by Dr. Jennifer Widom of Stanford University and respond to the items in Part 1. Feel free to pause the video to respond to the items and rewatch segments as necessary. Alternatively, you may prefer to view the presentation once through and then again to complete the assignment. The presentation is 13 minutes long.
Part 2 of the assignment is not specifically related to the video, but it will require additional investigation and research.
Note that this presentation is part of a database course for computer science students at Stanford University. When Dr. Widom states “in this course, we will cover” or that “we will cover” a given topic in greater detail later in the course, she is referring to her course, not ours.

Hide Assignment Information
Instructions
Instructions:
Watch the Introduction to

Hide Assignment Information
Instructions
Instructions:
Watch the Introduction to Databases video by Dr. Jennifer Widom of Stanford University and respond to the items in Part 1. Feel free to pause the video to respond to the items and rewatch segments as necessary. Alternatively, you may prefer to view the presentation once through and then again to complete the assignment. The presentation is 13 minutes long.
Part 2 of the assignment is not specifically related to the video, but it will require additional investigation and research.
Note that this presentation is part of a database course for computer science students at Stanford University. When Dr. Widom states “in this course, we will cover” or that “we will cover” a given topic in greater detail later in the course, she is referring to her course, not ours.

Instructions
In case you missed it in Week 1, please take the time to read the a

Instructions
In case you missed it in Week 1, please take the time to read the attached ‘Clarification’ document which explains the difference between Weeks 1,2,5 SQL Check Assignments (grading and feedback) vs Week 6-8 SQL assignments.
This assignment is a continuation of the Week 1 Mythical Creatures assignment.
This assignment is composed of two deliverables, a Word document (fill in the attached template) and an SQL Check online quiz to verify your answers. The directions for both deliverables are in the attached document.
The first deliverable guides you to produce a Word document with SQL code and screenshots of execution. You will attach that here.
The second deliverable, Week 2 SQL Check Mythical Creatures II, is verification of your SQL results using our automatically graded online quiz.You may take the Week 2 SQL Check three times and your highest score will be posted to the Grades area. You are given multiple attempts so you can rework the SQL on the questions you miss. Do NOT attempt the quiz again without spending some time with your SQL queries; this is central to the learning process.
In order to earn full credit, you MUST do them both! Note if the first deliverable, the submitted Word document is incomplete, your posted grade for the Week 2 SQL Check will be modified. You should consider that a complete Word document, with SQL queries and screenshots is 50% of your grade on this assignment.
In this Week 2 assignment, we introduce you to a single-table database. It requires you to
download and run an SQL script to set the database up on your work area
write and execute several SQL queries to demonstrate mastery
Attached to this assignment is the Word document containing your instructions, plus a script (“MythicalCreatures.sql”) containing instructions your computer will need to create the database so you can do this week’s assignment.
In other tutorials this week, you use the Khan Academy website to work through tutorials, create databases and queries and test code. In this assignment and in other assignments in the course, we’ll be using a different website called SQLiteonline.com.
Instructions for how to access SQLiteonline.com, create a database, run queries and check output of the queries are found in the attached file Setting_Up_SQLiteonline_com.docx. Those instructions will provide information on how to take snippets of your output to cut and paste into Word for submission.
If you have questions, ASK.

Instructions
In case you missed it in Week 1, please take the time to read the a

Instructions
In case you missed it in Week 1, please take the time to read the attached ‘Clarification’ document which explains the difference between Weeks 1,2,5 SQL Check Assignments (grading and feedback) vs Week 6-8 SQL assignments.
This assignment is a continuation of the Week 1 Mythical Creatures assignment.
This assignment is composed of two deliverables, a Word document (fill in the attached template) and an SQL Check online quiz to verify your answers. The directions for both deliverables are in the attached document.
The first deliverable guides you to produce a Word document with SQL code and screenshots of execution. You will attach that here.
The second deliverable, Week 2 SQL Check Mythical Creatures II, is verification of your SQL results using our automatically graded online quiz.You may take the Week 2 SQL Check three times and your highest score will be posted to the Grades area. You are given multiple attempts so you can rework the SQL on the questions you miss. Do NOT attempt the quiz again without spending some time with your SQL queries; this is central to the learning process.
In order to earn full credit, you MUST do them both! Note if the first deliverable, the submitted Word document is incomplete, your posted grade for the Week 2 SQL Check will be modified. You should consider that a complete Word document, with SQL queries and screenshots is 50% of your grade on this assignment.
In this Week 2 assignment, we introduce you to a single-table database. It requires you to
download and run an SQL script to set the database up on your work area
write and execute several SQL queries to demonstrate mastery
Attached to this assignment is the Word document containing your instructions, plus a script (“MythicalCreatures.sql”) containing instructions your computer will need to create the database so you can do this week’s assignment.
In other tutorials this week, you use the Khan Academy website to work through tutorials, create databases and queries and test code. In this assignment and in other assignments in the course, we’ll be using a different website called SQLiteonline.com.
Instructions for how to access SQLiteonline.com, create a database, run queries and check output of the queries are found in the attached file Setting_Up_SQLiteonline_com.docx. Those instructions will provide information on how to take snippets of your output to cut and paste into Word for submission.
If you have questions, ASK.

Instructions
In case you missed it in earlier, please take the time to read the

Instructions
In case you missed it in earlier, please take the time to read the attached ‘Clarification’ document which explains the difference between Weeks 1,2,5 SQL Check Assignments (grading and feedback) vs Weeks 6-8 SQL assignments.
This assignment is composed of two deliverables. The directions for both deliverables are in the attached document.
The first deliverable, Week 5 Helpdesk SQL, guides you to produce a Word document with SQL code and screenshots of execution. You will attach that here.
The second deliverable, Week 5 SQL Check Helpdesk, is verification of your SQL results using an automatically graded online. which can be found under Quizzes. You may take the Week 5 SQL Check three times and your highest score will be posted to the Grades area. You are given multiple attempts so you can rework the SQL on the questions you miss. Do NOT attempt the quiz again without spending some time with your SQL queries; this is central to the learning process.
In order to earn full credit, you MUST do them both! Note if the first deliverable, the submitted Word document is incomplete, your posted grade for the Week 5 SQL Check will be modified. You should consider that a complete Word document, with SQL queries and screenshots is 50% of your grade on this assignment.
Attached to this assignment is the Word document containing your instructions, plus scripts (“Helpdesk_setup.sql” and “Helpdesk_insert.sql”) containing instructions your computer will need to make you the database so you can do this week’s homework.
Happy SQL!

Instructions
In case you missed it in earlier, please take the time to read the

Instructions
In case you missed it in earlier, please take the time to read the attached ‘Clarification’ document which explains the difference between Weeks 1,2,5 SQL Check Assignments (grading and feedback) vs Weeks 6-8 SQL assignments.
This assignment is composed of two deliverables. The directions for both deliverables are in the attached document.
The first deliverable, Week 5 Helpdesk SQL, guides you to produce a Word document with SQL code and screenshots of execution. You will attach that here.
The second deliverable, Week 5 SQL Check Helpdesk, is verification of your SQL results using an automatically graded online. which can be found under Quizzes. You may take the Week 5 SQL Check three times and your highest score will be posted to the Grades area. You are given multiple attempts so you can rework the SQL on the questions you miss. Do NOT attempt the quiz again without spending some time with your SQL queries; this is central to the learning process.
In order to earn full credit, you MUST do them both! Note if the first deliverable, the submitted Word document is incomplete, your posted grade for the Week 5 SQL Check will be modified. You should consider that a complete Word document, with SQL queries and screenshots is 50% of your grade on this assignment.
Attached to this assignment is the Word document containing your instructions, plus scripts (“Helpdesk_setup.sql” and “Helpdesk_insert.sql”) containing instructions your computer will need to make you the database so you can do this week’s homework.
Happy SQL!

Instructions
Complete instructions and data files are attached. Be sure to read

Instructions
Complete instructions and data files are attached. Be sure to read the Additional Clarification document as well.

Please take the time to read the attached ‘Clarification’ document which explain

Please take the time to read the attached ‘Clarification’ document which explains the difference between Weeks 1,2,5 SQL Check Assignments (grading and feedback) vs Week 6-8 SQL assignments.
This assignment is composed of two deliverables, a Word document (fill in the attached template) and an SQL Check online quiz to verify your answers. The directions for both deliverables are in the attached document.
The first deliverable guides you to produce a Word document with SQL code and screenshots of execution. You will attach that here.
The second deliverable, Week 1 SQL Check Mythical Creatures I, is verification of your SQL results using our automatically graded online quiz. You may take the Week 1 SQL Check three times and your highest score will be posted to the Grades area. You are given multiple attempts so you can rework the SQL on the questions you miss. Do NOT attempt the quiz again without spending some time with your SQL queries; this is central to the learning process.
In order to earn full credit, you MUST do them both! Note if the first deliverable, the submitted Word document is incomplete, your posted grade for the Week 1 SQL Check will be modified. You should consider that a complete Word document, with SQL queries and screenshots is 50% of your grade on this assignment.
In this Week 1 assignment, we introduce you to a single-table database. It requires you to
download and run an SQL script to set the database up on your work area
write and execute several SQL queries to demonstrate mastery
Attached to this assignment is the Word document containing your instructions, plus a script (“MythicalCreatures.sql”) containing instructions your computer will need to create the database so you can do this week’s assignment.
In other tutorials this week, you use the Khan Academy website to work through tutorials, create databases and queries and test code. In this assignment and in other assignments in the course, we’ll be using a different website called SQLiteonline.com.
Instructions for how to access SQLiteonline.com, create a database, run queries and check output of the queries are found in the attached file Setting_Up_SQLiteonline_com.docx. Those instructions will provide information on how to take snippets of your output to cut and paste into Word for submission.
If you have questions, ASK.

Instructions
In case you missed it in Week 1, please take the time to read the a

Instructions
In case you missed it in Week 1, please take the time to read the attached ‘Clarification’ document which explains the difference between Weeks 1,2,5 SQL Check Assignments (grading and feedback) vs Week 6-8 SQL assignments.
This assignment is a continuation of the Week 1 Mythical Creatures assignment.
This assignment is composed of two deliverables, a Word document (fill in the attached template) and an SQL Check online quiz to verify your answers. The directions for both deliverables are in the attached document.
The first deliverable guides you to produce a Word document with SQL code and screenshots of execution. You will attach that here.
The second deliverable, Week 2 SQL Check Mythical Creatures II, is verification of your SQL results using our automatically graded online quiz.You may take the Week 2 SQL Check three times and your highest score will be posted to the Grades area. You are given multiple attempts so you can rework the SQL on the questions you miss. Do NOT attempt the quiz again without spending some time with your SQL queries; this is central to the learning process.
In order to earn full credit, you MUST do them both! Note if the first deliverable, the submitted Word document is incomplete, your posted grade for the Week 2 SQL Check will be modified. You should consider that a complete Word document, with SQL queries and screenshots is 50% of your grade on this assignment.
In this Week 2 assignment, we introduce you to a single-table database. It requires you to
download and run an SQL script to set the database up on your work area
write and execute several SQL queries to demonstrate mastery
Attached to this assignment is the Word document containing your instructions, plus a script (“MythicalCreatures.sql”) containing instructions your computer will need to create the database so you can do this week’s assignment.
In other tutorials this week, you use the Khan Academy website to work through tutorials, create databases and queries and test code. In this assignment and in other assignments in the course, we’ll be using a different website called SQLiteonline.com.
Instructions for how to access SQLiteonline.com, create a database, run queries and check output of the queries are found in the attached file Setting_Up_SQLiteonline_com.docx. Those instructions will provide information on how to take snippets of your output to cut and paste into Word for submission.
If you have questions, ASK.

Hide Assignment Information
Instructions
Instructions
In case you missed it in W

Hide Assignment Information
Instructions
Instructions
In case you missed it in Week 1, please take the time to read the attached ‘Clarification’ document which explains the difference between Weeks 1,2,5 SQL Check Assignments (grading and feedback) vs Week 6-8 SQL assignments.
This assignment is a continuation of the Week 1 Mythical Creatures assignment.
This assignment is composed of two deliverables, a Word document (fill in the attached template) and an SQL Check online quiz to verify your answers. The directions for both deliverables are in the attached document.
The first deliverable guides you to produce a Word document with SQL code and screenshots of execution. You will attach that here.
The second deliverable, Week 2 SQL Check Mythical Creatures II, is verification of your SQL results using our automatically graded online quiz. You may take the Week 2 SQL Check three times and your highest score will be posted to the Grades area. You are given multiple attempts so you can rework the SQL on the questions you miss. Do NOT attempt the quiz again without spending some time with your SQL queries; this is central to the learning process.
In order to earn full credit, you MUST do them both! Note if the first deliverable, the submitted Word document is incomplete, your posted grade for the Week 2 SQL Check will be modified. You should consider that a complete Word document, with SQL queries and screenshots is 50% of your grade on this assignment.
In this Week 2 assignment, we introduce you to a single-table database. It requires you to
download and run an SQL script to set the database up on your work area
write and execute several SQL queries to demonstrate mastery
Attached to this assignment is the Word document containing your instructions, plus a script (“MythicalCreatures.sql”) containing instructions your computer will need to create the database so you can do this week’s assignment.
In other tutorials this week, you use the Khan Academy website to work through tutorials, create databases and queries and test code. In this assignment and in other assignments in the course, we’ll be using a different website called SQLiteonline.com.
Instructions for how to access SQLiteonline.com, create a database, run queries and check output of the queries are found in the attached file Setting_Up_SQLiteonline_com.docx. Those instructions will provide information on how to take snippets of your output to cut and paste into Word for submission.
If you have questions, ASK.