MySQL project

Chinook Database


In 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 you 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.


You 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 answer your question successfully. 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. To review your presentation, you will need to save your slides as a **PDF**.

Project Walkthrough

This video shows one of our instructors giving some great hints and tips for how to get started with your project: Walkthrough Video

Note: Josh references that this is the second project in the walkthrough above, please ignore that as this is the only project for this course.

Common 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.

Kemahiran: MySQL, Pengaturcaraan Pangkalan Data, SQL, Pentadbiran Pangkalan Data, PHP

Tentang Klien:
( 4 ulasan ) Jeddah, Saudi Arabia

ID Projek: #34001778

12 pekerja bebas membida secara purata $127 untuk pekerjaan ini


Dear sir, I have gone through your outsourced requirement " MySQL project " and have analyzed that I have right credentials ( PHP SQL MySQL Database Administration Database Programming ) to execute your esteemed pr Lagi

$20 USD dalam 7 hari
(122 Ulasan)
(29 Ulasan)
(21 Ulasan)

Hi, i am an expert in SQL script writing. I have a Bsc degree in computer science. Please consider for the task i will provide the best quality.

$50 USD dalam 3 hari
(28 Ulasan)

Hi , I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions in SQL Server environments. Proficient in an a Lagi

$30 USD dalam 3 hari
(14 Ulasan)

Hi I have 15 years of experience in SQL server Database development, MySQL development, postgress development, power bi, programming using python and c#. I will be able to help you with the project. Please ping me offl Lagi

$333.33 USD dalam 10 hari
(10 Ulasan)

السلام علیکم I am professional database expert and master of mySql. I checked your mention details and confident one that i can do it perfectly

$30 USD dalam sehari
(20 Ulasan)

⭐⭐⭐⭐⭐⭐ Hi ⭐⭐⭐⭐⭐⭐ Hi, I'm very interesting your project very well I'm good at PHP, MYSQL. As a senior developer , i have 8+ years of rich experience in web developing using PHP and MySQL. And I have rich experience in d Lagi

$20 USD dalam 7 hari
(7 Ulasan)

Dear hiring manager, I went through your project requirement of MySQL project of Chinook Database. I did Masters in Computer Science(2005) and currently working as Senior Database developer. I have thorough knowledge Lagi

$100 USD dalam 7 hari
(3 Ulasan)

Dear Client. ***"The sole reason we are in business is to make life less difficult for our clients"*** This is my favorite quote. So i will provide you the best service. As you can see in my profile, my skills will f Lagi

$20 USD dalam sehari
(1 Ulasan)

I am an energetic Web Designer with 7 years of experience creating usable, responsive websites for different organizations. Highly skilled in wireframing, designing, and developing creative digital experiences for Joom Lagi

$50 USD dalam sehari
(0 Ulasan)

Hi there, I can help you with this and would love to work with. Kindly share details so I can go through and start work ASAP. An experienced WordPress, Ecommerce, website, mobile app developer & expert in (PHP,HTML,Jav Lagi

$101 USD dalam 40 hari
(0 Ulasan)