Learning Goal: I’m working on a mysql project and need support to help me learn.

Learning Goal: I’m working on a mysql project and need support to help me learn.IntroductionIn this project, you will query the Chinook Database. The Chinook Database holds information about a music store. For this project, you will be assisting the Chinook team with understanding the media in their store, their customers and employees, and their invoice information. To assist you in the queries ahead, the schema for the Chinook Database is provided below. You can see the columns that link tables together via the arrows.All of the below instructions are discussed in detail as we work through this lesson on your way to completing this project. The below serves as a quick reference of what you will be doing as you progress through the completion of this project.InstructionsYou will need to follow the instructions on the next three concepts to get the Chinook database up and running on your own machine, and check that it is set up correctly. There will be two parts to this project.The first part is a series of questions that will assure you have mastered the main concepts taught throughout the SQL lessons. Though these questions will not be “graded” by a reviewer, they will help you self assess.
The second part is a presentation. Similar to the first project, there isn’t a ‘right answer’ for the second portion of the project. You have the ability to be creative in the questions you ask. You will then write a SQL query to pull the data needed to successfully answer your question. Use the pulled data to build a visual (bar chart, histogram, or another plot) that answers your question. The essentials of your project submission are discussed in the next sections. In order to review your presentation, you will need to save your slides as a PDF.
Project WalkthroughThis video shows one of our instructors giving some great hints and tips for how to get started with your project: Walkthrough VideoCommon Questions and Answers:To find answers to common questions regarding this project, head to our knowledge base. Once you are there, in the drop-down, choose Any for the program and search for music and choose Music SQL Database in the project. Then take a look at the questions that have already been posed and answered to help you if you get stuck.PROJECT SPECIFICATIONMusic SQL DatabaseSQL QueriesCRITERIAMEETS SPECIFICATIONSThe student can write error-free SQL queries.All SQL queries run without errors and produce the intended results.The student can use joins correctly in SQL queries.Each SQL query needs to include one or more explicit join. The JOIN or JOINs should be necessary to the query. If a question does not require a JOIN please change the question to be one that does.Example:SELECT *FROM AlbumJOIN Track on Track.AlbumID = Album.AlbumIDThe student can use aggregations correctly in SQL queries.Each SQL query needs to include one or more aggregation. This could be a COUNT, AVG, SUM, or other aggregation.Student can answer multiple questions by using SQLThe student has used at least 4 unique SQL queries in their submission.PresentationCRITERIAMEETS SPECIFICATIONSThe student’s slides are organized well and are easy to read and understand.Each slide should have an appropriate title and the visualization descriptions should be free of significant factual, spelling and grammar mistakes.The student can create data visualizations that provide useful information.All visualizations should make logical sense and provide accurate information about the indicated area.The student can format data visualizations clearly and make good use of labeling.All visualizations include a title and axis labels, have a legend where applicable, and are easily understood.Every visualization should havechart title
x axis title
x axis labels
y axis title
y axis labels
Submission PhaseCRITERIAMEETS SPECIFICATIONSThe student has uploaded all files necessary for review.A PDF report has been uploaded and a .txt file with the queries has been uploaded in a single zipped folder fileSuggestions to Make Your Project Stand Out!To make you project standout, consider the following:Look for interesting patterns and insights in the data rather than simply providing summary statistics.
Use other advanced SQL functions, such as the case function.
Make good use of color, size, and shape in your visualizations.
Use the slide title and/or chart description on each slide to state the key insight of the visualization.
To submit your project, please do the following:Review your project against the project Rubric. Reviewers will use this to evaluate your work.
Create your slides with whatever presentation software you’d like (e.g. Google Slides, PowerPoint, Keynote, etc.).
In order to review your presentation, you will need to save your slides as a PDF. You can do this from within Google Slides by selecting File > Download as > PDF Document.Create a separate text file with each of the SQL queries used to create the visualizations.
Save the presentation as a PDF and the SQL queries in a text file(.txt) in the same folder.
Requirements: 4 Queries with its slides results

Posted in Uncategorized

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount