Practice Exercise- Sample Database Tutorial Basic SELECT Statement

Link to Video Tutorial on Setting Up the Sample Database 

https://www.screencast.com/t/OMwqFl4P Links to an external site.

You will practice some of the exercises from this Website

https://www.mysqltutorial.org/mysql-select-statement-query-data.aspx Links to an external site.

I selected the practice examples from this website that I would like you to focus on and placed them in the PDF document below.  Follow the tutorial in the PDF document transposing or writing the specified SQL script into a text editor. Run the script that you placed in the text editor in Maria DB to make sure that you wrote or transposed it correctly.  Make sure that all your script in the submitted SQL text file runs correctly and continuously. 

Video Explanation of Assignment

https://www.screencast.com/t/CXv07kPl

Link to Download PDF Tutorial Assignment

SELECT Statement Basics Tutorials.pdf Download SELECT Statement Basics Tutorials.pdf

You will use the Sample Database for the exercises in Assignment 

Link to Download Sample Database

mysqlsampledatabase.sql Download mysqlsampledatabase.sql

Link to Download ER Diagram for the Sample Database

Sample Database- ER Diagram.pdf Download Sample Database- ER Diagram.pdf

Link to Download Metadata for the Sample Database

Sample Database Metadata.pdf Download Sample Database Metadata.pdf

Use a SOURCE command to create and configure the database

 Submit an SQL text file created from following along with the tutorial

If you are using comments in the script files or file, you must use them correctly.  The script must run continuously.  Any commands that do not operate correctly due to improperly formatted comments will not be assessed in the final point accumulation for the assignment.