SQL Odyssey is an engaging and educational game designed to help players learn and practice SQL (Structured Query Language) skills. The game is structured around a series of quests and exercises that challenge players to write SQL queries to solve various problems using a sample database.
The game uses the Chinook database, a sample database representing a digital media store, including tables for artists, albums, tracks, customers, invoices, and more. Players will navigate through different levels, each presenting unique challenges that require applying SQL knowledge to retrieve, manipulate, and analyze data.
About the origin of the content (Click to expand)
This game's exercises were originally developed by **Toulouse Ynov Campus**. I would like to thank them for their quality work. I have adapted and structured this content for my portfolio project, SQL Odyssey.
- Clone the repository to your local machine using your terminal:
git clone https://github.com/joshua31400/SQL-Odyssey.git
- Navigate to the project directory:
cd SQL-Odyssey - Get ready: Make sure you have a SQLite client installed. If not, you can download one from here (or use a tool like DBeaver or DataGrip).
- Open the database: Use your SQLite client to open the initial database file located at:
DataBase-Copy/chinook.db
- First, follow the quests and exercises in numerical order.
⚠️ Important: Keep in mind that some quests might require a fresh version of the database. You can simply copy whatever file is currently in theDataBase-Copyfolder to reset your environment before starting a new complex quest.- If your database gets corrupted or you are totally stuck, you can always re-download the original
chinook.dbfile from this repository. - Note: All solutions are present in the "Results" folder, but try to avoid peeking if you want a real challenge!
"Adapted and developed by Joshua BUDGEN"
Special thanks to Toulouse Ynov Campus and the Ytrack platform for providing the original series of exercises, allowing students to get hands-on experience with SQL.
Copyright © 2025 Joshua BUDGEN. All Rights Reserved.