/Digital-Music-Store

Query a Digital Music Store Database, 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.

Digital-Music-Store

Introduction

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.

Database Schema

Set up your local environment:

The environment we'll use is pretty quick to set up and hopefully you'll be up and running in no time :)

First you need to:

After both have been downloaded:

  • Open up DB Browser to SQLite
  • Click on Open Database
  • Navigate to the chinook.db file
  • Click on the Execute SQL
  • Start querying your data
  • Use Notepad, Notepad++ or Atom to save queries

Project Components