Chicago Record Store
The Chinook example dataset is a free, open-source sample database for practicing SQL, based on a fictional music store.
It contains 11 tables with data on customers, employees, albums, tracks, and sales, and is available in formats like SQLite, MySQL, and PostgreSQL. The database is used for teaching database management and querying with SQL.
Dataset Includes
- Customers: Fictitious customer data.
- Employees: Information about sales agents.
- Sales: Data on invoices and line items.Music catalog: Tracks, albums, artists, and genres, derived from a real iTunes library.
- Other tables: Media types and playlists.
How to Use
- Query: Write and run SQL queries to answer questions, such as finding top-selling artists or sales by region.
- Analyze: Practice analyzing data to find trends and insights, like identifying the best-performing sales agents.
Why it's Useful.
- Educational tool: It's a practical way to learn about relational databases and SQL.
- Real-world simulation: It simulates a realistic business scenario, making practice more relevant.
- Multiple formats: It's compatible with many different database systems, allowing you to practice in the tool of your choice.
About the example dataset
The Chinook data model represents a digital media store, including tables for artists, albums, media tracks, invoices, and customers. Media-related data was created using real data from an Apple iTunes library. Customer and employee information was created using fictitious names and addresses that can be located on Google maps, and other well formatted data (phone, fax, email, etc.) Sales information was auto generated using random data for a four year period.